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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [GENERAL] WAL & ready files retained after turning off log shipping
Дата
Msg-id 7481.1504794743@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [GENERAL] WAL & ready files retained after turning off logshipping  (Ron Johnson <ron.l.johnson@cox.net>)
Список 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 по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: [GENERAL] WAL & ready files retained after turning off logshipping
Следующее
От: Francisco Olarte
Дата:
Сообщение: Re: [GENERAL] column names query