On Mon, Dec 19, 2016 at 4:40 AM, <r...@salepointdata.com> 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/li > bpqwalreceiver.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
