From: | Venkata B Nagothi <nag1010(at)gmail(dot)com> |
---|---|
To: | rich(at)salepointdata(dot)com |
Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Postgres 9.6 Streaming Replication on Solaris 10 |
Date: | 2016-12-20 01:03:12 |
Message-ID: | CAEyp7J8r5gVpA7oF=Rfp78JfQi5cQSHxyoObPmf-aC17HL=cAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, Dec 19, 2016 at 4:40 AM, <rich(at)salepointdata(dot)com> 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 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/li
> bpqwalreceiver.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 ?
Regards,
Venkata B N
Database Consultant
From | Date | Subject | |
---|---|---|---|
Next Message | rich | 2016-12-20 04:15:11 | Re: Postgres 9.6 Streaming Replication on Solaris 10 |
Previous Message | Alban Hertroys | 2016-12-19 19:50:04 | Re: Is there a way to Send attachments with email using pgmail postgreSQl? |