Re: bdr appears to be trying to replicate to itself

Поиск
Список
Период
Сортировка
От Craig Ringer
Тема Re: bdr appears to be trying to replicate to itself
Дата
Msg-id CAMsr+YFKCwUAoU6OJ1pqozeroBVXCRO65Efhd=57Vhf_TWwPzA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: bdr appears to be trying to replicate to itself  (Cj B <blackc2004@gmail.com>)
Ответы Re: bdr appears to be trying to replicate to itself
Список pgsql-general
Дерево обсуждения
On 17 November 2015 at 00:33, Cj B <blackc2004@gmail.com> wrote:
 
select pg_drop_replication_slot(‘bdr_16385_6188730679935789649_1_16385__’)

Correct.
 
What impact will this have?

If the slot is unused, it'll allow the WAL that's being held by the slot to be removed. It'll also unpin the catalog xmin to allow autovacuum to clean up dead tuples in the catalogs.

This doesn't explain how the system got into this state. For that it'd really be necessary to see the steps taken during setup. BDR tries to protect against attempts to replicate-from-self. Presumably there's an oversight in those checks. If you're able to reproduce this state I'd like to hear details on how.

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

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