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

[milist ujang <ujang.milist@xxxxxxxxx>]

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@xxxxxxxxxxxxxxx> 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