Search Postgresql Archives

Re: setting up streaming error. Please help

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Thanks Tom .  

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:
>          After making the required changes to the Primary and slave , I have
> restarted the slave and I keep seeing the following in the logs.

> *FATAL:  could not connect to the primary server: invalid connection option
> "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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux