Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory

Поиск
Список
Период
Сортировка
От milist ujang
Тема Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory
Дата
Msg-id CACG9ogx8JzdYvv_qJCtBwxNUQbYHf3Wb48oJ8pcgjH4aVsC5nA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory  (Craig Ringer <craig@2ndquadrant.com>)
Ответы Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory  (Craig Ringer <craig@2ndquadrant.com>)
Список pgsql-general
Дерево обсуждения
Hi Craig,

Thanks again for pointing to inactive replication slot.
After inactive replication slot been dropped, the relfrozenxid now moving.

I wonder if  replication identifier will have some issue if left un-chained? since at other side there are inactive replication identifier.



On Fri, Sep 15, 2017 at 9:36 AM, Craig Ringer <craig@2ndquadrant.com> wrote:


Do you have any idle/old replication slots, perhaps from failed node joins or abandoned nodes not properly parted?

SELECT *
FROM pg_replication_slots;

Also check

SELECT oid,*
FROM pg_database;


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



--
regards

ujang jaenudin | DBA Consultant (Freelancer)
http://ora62.wordpress.com
http://id.linkedin.com/pub/ujang-jaenudin/12/64/bab

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

Предыдущее
От: George Neuner
Дата:
Сообщение: Re: [GENERAL] looking for a globally unique row ID
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: [GENERAL] BDR, near xid wraparound, a lot of files in pg_subtrans directory