On 14 September 2017 at 13:35, milist ujang <ujang.mil...@gmail.com> wrote:
> HI list, > > I have a database with bdr environment which keep alerting these messages > in log file: > > HINT: Close open transactions soon to avoid wraparound problems. > WARNING: oldest xmin is far in the past > 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
