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?
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 ?
