On 14 September 2017 at 13:35, milist ujang <ujang.milist@xxxxxxxxx> 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;
