Re: WAL & ready files retained after turning off log shipping

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: WAL & ready files retained after turning off log shipping
Date: 2017-09-07 14:32:23
Message-ID: 7481.1504794743@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Olarte 2017-09-07 15:11:14 Re: column names query
Previous Message Ron Johnson 2017-09-07 14:25:09 Re: WAL & ready files retained after turning off log shipping