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 functioning installation of postgres 9.6 on Solaris 10. Did I miss a configuration setting?
Thanks in advance for any guidance on this issue.
Rich Rutkowski