Physical replication slots and xlog space exhaust - Mailing list pgsql-admin

From Alex Balashov
Subject Physical replication slots and xlog space exhaust
Date
Msg-id 5C492AE6-272A-451D-9563-59A93162F2E6@evaristesys.com
Whole thread Raw
List pgsql-admin
We have a recurring human error problem where, upon doing a base copy to a new slave, we accidentally leave the
master’sphysical replication slots in place, forgetting to drop them from the slave config. 

After a while, transaction logs pile up on the slave — since no slaves are consuming them — and blow it out. This then
causesthe slave to stop downloading transaction logs from the master, causing them to accumulate due to its own
replicationslots. 

I understand the ultimate solution to this is to mind one’s replication slots and monitor disk usage fastidiously, but
isthere a config parameter for the maximum overall amount of transaction logs that can be kept accumulated on the
master,irrespectively of physical replication slots commitments? 

Thanks!

—
Sent from mobile, with due apologies for brevity and errors.


pgsql-admin by date:

Previous
From: Alvaro Aguayo Garcia-Rada
Date:
Subject: Re: BDR
Next
From: arvind chikne
Date:
Subject: Re: BDR