<html><body><span style="font-family:Verdana; color:#000; font-size:10pt;"><div>Hi,</div><div> Yes it is set in both the user's .profile and also in /etc/profile. In both files it is set using:</div><div>LD_LIBRARY_PATH=/usr/sfw/lib:/usr/postgres/9.6-pgdg/lib<br>export LD_LIBRARY_PATH</div><div><br></div><div>That said, if I execute the following<br></div><div>su password<br></div><div>su postgres</div><div>echo $LD_LIBRARY_PATH</div><div><br></div><div>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?</div><div><br></div><div>Regards,<br></div><div><br></div><div>Rich Rutkowski</div><div><a href="mailto:rich(at)salepointdata(dot)com">rich(at)salepointdata(dot)com</a></div><div><br></div><div><br><br></div>
<blockquote id="replyBlockquote" webmail="1" style="border-left: 2px solid blue; margin-left: 8px; padding-left: 8px; font-size:10pt; color:black; font-family:verdana;">
<div id="wmQuoteWrapper">
-------- Original Message --------<br>
Subject: Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10<br>
From: Venkata B Nagothi <<a href="mailto:nag1010(at)gmail(dot)com">nag1010(at)gmail(dot)com</a>><br>
Date: Mon, December 19, 2016 5:03 pm<br>
To: <a href="mailto:rich(at)salepointdata(dot)com">rich(at)salepointdata(dot)com</a><br>
Cc: pgsql-general <<a href="mailto:pgsql-general(at)postgresql(dot)org">pgsql-general(at)postgresql(dot)org</a>><br>
<br>
<div dir="ltr"><div class="gmail_extra"><div><div class="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><br></div></div></div></div></div></div></div><div class="gmail_quote">On Mon, Dec 19, 2016 at 4:40 AM, <span dir="ltr"><<a href="mailto:rich(at)salepointdata(dot)com" target="_blank">rich(at)salepointdata(dot)com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div><span style="font-family:verdana;color:rgb(0,0,0);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" target="_blank">li<wbr>bpqwalreceiver.so</a>": <a href="http://ld.so" target="_blank">ld.so</a>.1: postgres: fatal: relocation error: file /usr/postgres/9.6-pgdg/lib/<a href="http://libpqwalreceiver.so" target="_blank">lib<wbr>pqwalreceiver.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 </div></span></div></blockquote><div><br></div><div>Do you have <span style="color:rgb(0,0,0);font-family:verdana;font-size:13.3333px">"/usr/postgres/9.6-pgdg/lib" part of</span> LD_LIBRARY_PATH variable ? </div><div><br></div><div>Regards,</div><div><font color="#000000" face="verdana"><span style="font-size:13.3333px">Venkata B N</span></font></div><div><font color="#000000" face="verdana"><span style="font-size:13.3333px"><br></span></font></div><div><font color="#000000" face="verdana"><span style="font-size:13.3333px">Database Consultant</span></font></div></div></div></div>
</div>
</blockquote></span></body></html>