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

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(at)2ndquadrant(dot)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