Ajay Dalvi wrote:

>Hello all,
>I am from India - Pune
>
>
>I have PostGreSql 7.3.4 installed on RedHat Linux 9.
>
>I want to do the Replication on PostGreSql databases
>
>I am going to use Slony 1.1.0 for Replication.
>
>I am follwing the installation steps that are given in
>Slony-I-Install.txt in Slony 1.1.0 source.
>
>
>But while installing , during configuration step i am getting an error
>
>error: Your version of libpq doesn't have PQunescapeBytea
>     this means that your version of PostgreSQL is lower than 7.3
>     and thus not supported by Slony-I.
>     
>Though i am having PostGreSql Version 7.3.4, this error is comming.
>
>So if anyone is having any solution about this error please let me know
>as soon as possible
>
>
>Following is the output that is geting displayed after running
>'configure' file
>--with-pgconfigdir represents path of the 'pg_config' utility.
>
>
>[root at paloalto slony1-1.1.0]# ./configure --with-pgconfigdir=/usr/bin
>checking build system type... i686-pc-linux-gnu
>checking host system type... i686-pc-linux-gnu
>checking which template to use... linux
>configure: using CFLAGS=
>checking for gcc... gcc
>checking for C compiler default output... a.out
>checking whether the C compiler works... yes
>checking whether we are cross compiling... no
>checking for suffix of executables...
>checking for suffix of object files... o
>checking whether we are using the GNU C compiler... yes
>checking whether gcc accepts -g... yes
>checking for ld used by GCC... /usr/bin/ld
>checking if the linker (/usr/bin/ld) is GNU ld... yes
>checking for perl... /usr/bin/perl
>checking for tar... /bin/tar
>checking for flex... flex
>checking for bison... bison -y
>checking for sed... sed
>checking for the pthreads library -lpthreads... no
>checking whether pthreads work without any flags... no
>checking whether pthreads work with -Kthread... no
>checking whether pthreads work with -kthread... no
>checking for the pthreads library -llthread... no
>checking whether pthreads work with -pthread... yes
>checking for joinable pthread attribute... PTHREAD_CREATE_JOINABLE
>checking if more special flags are required for pthreads... no
>checking for cc_r... gcc
>checking how to run the C preprocessor... gcc -E
>checking for ANSI C header files... yes
>checking for sys/types.h... yes
>checking for sys/stat.h... yes
>checking for stdlib.h... yes
>checking for string.h... yes
>checking for memory.h... yes
>checking for strings.h... yes
>checking for inttypes.h... yes
>checking for stdint.h... yes
>checking for unistd.h... yes
>checking fcntl.h usability... yes
>checking fcntl.h presence... yes
>checking for fcntl.h... yes
>checking limits.h usability... yes
>checking limits.h presence... yes
>checking for limits.h... yes
>checking stddef.h usability... yes
>checking stddef.h presence... yes
>checking for stddef.h... yes
>checking sys/socket.h usability... yes
>checking sys/socket.h presence... yes
>checking for sys/socket.h... yes
>checking sys/time.h usability... yes
>checking sys/time.h presence... yes
>checking for sys/time.h... yes
>checking for inttypes.h... (cached) yes
>checking for gettimeofday... yes
>checking for dup2... yes
>checking for alarm... yes
>checking for memset... yes
>checking for select... yes
>checking for strdup... yes
>checking for strerror... yes
>checking for strtol... yes
>checking for strtoul... yes
>checking for int32_t... yes
>checking for uint32_t... yes
>checking for u_int32_t... yes
>checking for int64_t... yes
>checking for uint64_t... yes
>checking for u_int64_t... yes
>checking for ssize_t... yes
>checking for POSIX signal interface... yes
>checking for pg_config... /usr/bin/pg_config
>checking for correct version of PostgreSQL... 7.3
>checking for PQunescapeBytea in -lpq... no
>configure: error: Your version of libpq doesn't have PQunescapeBytea
>     this means that your version of PostgreSQL is lower than 7.3
>     and thus not supported by Slony-I.
>
>  
>
Look at the config.log file; that will show in detail what the configure
script has done.

Near the end, you will see indication of it compiling a test program
checking for the handling of PQunescapeBytea.

On my system, this portion read:

configure:5209: checking for correct version of PostgreSQL
configure:5237: result: 8.0
configure:5346: checking for PQunescapeBytea in -lpq
configure:5379: gcc -o conftest -g -O2   -L/opt/OXRS/dbs/pgsql8/lib
conftest.c -lpq   >&5
configure:5382: $? = 0
configure:5385: test -s conftest
configure:5388: $? = 0
configure:5399: result: yes

You'll presumably find that some error was raised when compiling the
test program on your system.

The nature of the error will hopefully point to how to resolve it.

I have often run into this situation on AIX when flags weren't set to
compile all of the programs that use libpq with -lpthreads; while that
was an AIX-specific issue that probably doesn't apply to you, it's
likely to be something about as simple.