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 <cr...@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