Re: Postgres 9.6 Streaming Replication on Solaris 10

[<rich@xxxxxxxxxxxxxxxxx>]

Hi,

    Yes it is set in both the user's .profile and also in /etc/profile.  In both files it is set using:

LD_LIBRARY_PATH=/usr/sfw/lib:/usr/postgres/9.6-pgdg/lib
export LD_LIBRARY_PATH

That said, if I execute the following

su password

su postgres

echo $LD_LIBRARY_PATH

then echo returns blank.  Echo will return the correct value only in the usr login.  The question then is if postgres is running as usr postgres how does it know the value of LD_LIBRARY_PATH.  Isn't there another place where it must be set?

Regards,

Rich Rutkowski

rich@xxxxxxxxxxxxxxxxx

-------- Original Message --------
Subject: Re: Postgres 9.6 Streaming Replication on Solaris 10
From: Venkata B Nagothi <nag1010@xxxxxxxxx>
Date: Mon, December 19, 2016 5:03 pm
To: rich@xxxxxxxxxxxxxxxxx
Cc: pgsql-general <pgsql-general@xxxxxxxxxxxxxx>

On Mon, Dec 19, 2016 at 4:40 AM, <rich@xxxxxxxxxxxxxxxxx> wrote:

Hello List,

    I am setting up Postgres 9.6 for streaming replication.  The OS is Solaris X86  I downloaded the postgres solaris binaries from the Postres site and installed on 2 instances of Solaris 10.  I then used pg_dumpall to load the master server with data from our devel0pment server.  That all worked as advertised and was checked using pgAdmin Version 4.  No problems.  I then setup up the standby configuration and the master configuration and then used pg_basebackup from the standby to initialize its data.  Works, not a problem and verified using pgAdmin Version 4 that the data was there and read only.  However when a change was made on the master it does not appear on the standby.  A check of the standby server.log revealed the following message:

FATAL: could not load library "/usr/postgres/9.6-pgdg/lib/libpqwalreceiver.so": ld.so.1: postgres: fatal: relocation error: file /usr/postgres/9.6-pgdg/lib/libpqwalreceiver.so: symbol PQconnectdbParams: referenced symbol not found

The message repeats until the database is shutdown and restarted and then appears if a change is made on the master.  I think it is strange that this error is occurring on what appears to be a

Do you have "/usr/postgres/9.6-pgdg/lib" part of LD_LIBRARY_PATH variable ? 

Regards,

Venkata B N

Database Consultant