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

Поиск
Список
Период
Сортировка
От Venkata B Nagothi
Тема Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10
Дата
Msg-id CAEyp7J8r5gVpA7oF=Rfp78JfQi5cQSHxyoObPmf-aC17HL=cAw@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10  (<rich@salepointdata.com>)
Список pgsql-general

On Mon, Dec 19, 2016 at 4:40 AM, <rich@salepointdata.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/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 ? 

Regards,
Venkata B N

Database Consultant

В списке pgsql-general по дате отправления:

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: [GENERAL] Is there a way to Send attachments with email usingpgmail postgreSQl?
Следующее
От:
Дата:
Сообщение: Re: [GENERAL] Postgres 9.6 Streaming Replication on Solaris 10