Re: pgpool + BDR, is it possible?

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: pgpool + BDR, is it possible?
Дата
Msg-id CAMsr+YGJzUciimCvNg0TNmzM1S+Lcso_ApKPMRXb99-TDMB6Vw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pgpool + BDR, is it possible?  ("Ruth Melendo" <rmelendo@teltronic.es>)
Ответы Re: pgpool + BDR, is it possible?
Список pgsql-admin


On 17 March 2015 at 21:58, Ruth Melendo <rmelendo@teltronic.es> wrote:

My problem is that sometimes database stops replying.  All I can see is that I have registers in that table

 

SELECT * FROM pg_logical_slot_get_binary_changes('bdr_17911_6120567807158814813_1_16385__', NULL, 1, 'interactive', 'true')

 

When I get to this situation, I suppose that means that some transaction have not finish well. So, what can I do to recovery my replication?


Check the PostgreSQL server error log to find out what's going on and go from there. You need to find out what's going on, why replication apply has stopped progressing. Assuming it has.

BTW, you should use the "peek" functions not the "get" functions on an existing slot used by something else. Otherwise you might consume changes, causing them not to get replayed and resulting in inconsistencies.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

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

Предыдущее
От: "Gilberto Castillo"
Дата:
Сообщение: Re: [ADMIN] Parâmetros para melhor performance do servidor
Следующее
От: "Ruth Melendo"
Дата:
Сообщение: Re: pgpool + BDR, is it possible?