Re: [GENERAL] WAL & ready files retained after turning off log shipping - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] WAL & ready files retained after turning off log shipping
Date
Msg-id 7481.1504794743@sss.pgh.pa.us
Whole thread Raw
In response to Re: [GENERAL] WAL & ready files retained after turning off logshipping  (Ron Johnson <ron.l.johnson@cox.net>)
List pgsql-general
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.

            regards, tom lane


pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: [GENERAL] WAL & ready files retained after turning off logshipping
Next
From: Francisco Olarte
Date:
Subject: Re: [GENERAL] column names query