When I did.... Is there any that I can run some commands to point it to libpq.so.5. I have LD_LIBRARY_PATH =/opt/postgres/9.0.2/lib. still it is pointing to /usr/lib .. Any suggestions?
ldd libpqwalreceiver.so
libpq.so.4 => /usr/lib/libpq.so.4
libgcc_s.so.1 => /usr/sfw/lib/libgcc_s.so.1
libssl.so.0.9.7 => /usr/sfw/lib/libssl.so.0.9.7
libcrypto.so.0.9.7 => /usr/sfw/lib/libcrypto.so.0.9.7
libresolv.so.2 => /usr/lib/libresolv.so.2
libsocket.so.1 => /usr/lib/libsocket.so.1
libnsl.so.1 => /usr/lib/libnsl.so.1
libpthread.so.1 => /usr/lib/libpthread.so.1
libc.so.1 => /lib/libc.so.1
libmp.so.2 => /lib/libmp.so.2
libmd.so.1 => /lib/libmd.so.1
libscf.so.1 => /lib/libscf.so.1
libdoor.so.1 => /lib/libdoor.so.1
libuutil.so.1 => /lib/libuutil.so.1
libgen.so.1 => /lib/libgen.so.1
libssl_extra.so.0.9.7 => /usr/sfw/lib/libssl_extra.so.0.9.7
libcrypto_extra.so.0.9.7 => /usr/sfw/lib/libcrypto_extra.so.0.9.7
libm.so.2 => /lib/libm.so.2
/platform/SUNW,SPARC-Enterprise/lib/libc_psr.so.1
Appreciate your help
Regards
On Sat, Jun 11, 2011 at 12:25 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
akp geek <akpgeek@xxxxxxxxx> writes:> *FATAL: could not connect to the primary server: invalid connection option
> After making the required changes to the Primary and slave , I have
> restarted the slave and I keep seeing the following in the logs.
> "replication"*
That message has to be caused by libpq, because the string 'invalid
connection option' occurs nowhere else in PG. I am guessing that you
have an 8.4 or older libpq.so that walreceiver.so is somehow linking to.
I don't know what Solaris' equivalent of LD_LIBRARY_PATH is, but I'd be
looking into that angle if I were you.
regards, tom lane
