Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10

2016-12-22 Thread rich
Hi John,    I agree with you.  On Solaris I should not have to set LD_LIBRARY_PATH.  The location of the *.so files is baked in.  The strange part is that postgres starts up without errors and can be accessed from pgAdmin 4.  The problem is occurring from the replication functionality.  I am beginn

Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10

2016-12-21 Thread John R Pierce
On 12/19/2016 8:15 PM, r...@salepointdata.com wrote: Yes it is set in both the user's .profile and also in /etc/profile. In both files it is set using: LD_LIBRARY_PATH=/usr/sfw/lib:/usr/postgres/9.6-pgdg/lib export LD_LIBRARY_PATH That said, if I execute the following su password su postgr

Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10

2016-12-21 Thread rich
ubject: Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10 From: Venkata B Nagothi <nag1...@gmail.com> Date: Mon, December 19, 2016 5:03 pm To: r...@salepointdata.com Cc: pgsql-general <pgsql-general@postgresql.org> On Mon, Dec 19, 2016 at 4:40 AM, <r...@salepointdata.com&g

Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10

2016-12-19 Thread Venkata B Nagothi
On Mon, Dec 19, 2016 at 4:40 AM, 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