On 09/07/2017 09:32 AM, Tom Lane wrote:
> Ron Johnson <ron.l.johnson@cox.net> writes:
>> On 09/07/2017 09:08 AM, Tom Lane wrote:
>>> Manual cleanup shouldn't be very hard, fortunately. Run pg_controldata
>>> to see where the last checkpoint is, and delete WAL files whose names
>>> indicate they are before that (but not the one including the checkpoint!).
>> All WAL files after log shipping was stopped will keep accumulating "forever"?
> Hmm ... on second thought, I think if you just remove the .ready/.done
> files, the next checkpoint should clean up the old WAL files. That'd
> certainly be safer than doing it manually.
This weekend, (early Sunday morning) WAL files on the master started
accumulating again. Now, .ready files are regenerated every time I delete
them, even though according to pg_controldate the last checkpoint was 28
minutes ago.
--
World Peace Through Nuclear Pacification
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general