<html><body><span style="font-family:Verdana; color:#000; font-size:10pt;"><div>Hello List,</div><div> 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:</div><div><br></div><div>
</div><div style="margin-bottom: 0in; line-height: 100%">FATAL: could not
load library "/usr/postgres/9.6-pgdg/lib/<a href="http://libpqwalreceiver.so">libpqwalreceiver.so</a>":
<a href="http://ld.so">ld.so</a>.1: postgres: fatal: relocation error: file
/usr/postgres/9.6-pgdg/lib/<a href="http://libpqwalreceiver.so">libpqwalreceiver.so</a>: symbol
PQconnectdbParams: referenced symbol not found</div><div style="margin-bottom: 0in; line-height: 100%"><br></div><div style="margin-bottom: 0in; line-height: 100%">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?</div><div style="margin-bottom: 0in; line-height: 100%"><br></div><div style="margin-bottom: 0in; line-height: 100%">Thanks in advance for any guidance on this issue.<br></div><div style="margin-bottom: 0in; line-height: 100%"><br></div><div></div><div><br></div><div>Rich Rutkowski</div><div><br></div><div><a href="mailto:rich(at)salepointdata(dot)com">rich(at)salepointdata(dot)com</a></div><div><br></div></span></body></html>