Re: replication terminated by primary server

Поиск
Список
Период
Сортировка
От Payal Singh
Тема Re: replication terminated by primary server
Дата
Msg-id CAK4ounxZNQ1_JHnsGttOPR8bA_MVEKJc+XuNtaW6Q85Wq+NNYQ@mail.gmail.com
обсуждение исходный текст
Ответ на replication terminated by primary server  (Bruyninckx Kristof <Kristof.Bruyninckx@cegeka.com>)
Ответы RE: replication terminated by primary server  (Bruyninckx Kristof <Kristof.Bruyninckx@cegeka.com>)
Список pgsql-general


On Wed, Dec 6, 2017 at 8:07 AM, Bruyninckx Kristof <Kristof.Bruyninckx@cegeka.com> wrote:

 

In our environment, we have a master slave replication setup that has been working stable for the last year.

Host systems are debian Jessie and we are using postgres 9.4.

Now recently we have experienced a crash/hung master, and after restarting the postgress services on here the replication stopped working. The master however is running seemingly normal, except for the errors reported when it got restarted. After this nothing error related is reported.


Might want to check the master postgres logs during and after crash as well. Also, check for wal file progress on master (select * from pg_stat_archiver). 

--
Payal Singh
Graduate Student
Department of Computer Science and Electrical Engineering
University of Maryland, Baltimore County

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

Предыдущее
От: "Peter J. Holzer"
Дата:
Сообщение: Re: Infinite replication loop with pglogical
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: ERROR: too many dynamic shared memory segments