Re: pg_archivecleanup should remove WAL files also in pg_xlog?

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: pg_archivecleanup should remove WAL files also in pg_xlog?
Дата
Msg-id AANLkTimHK-BUPed_62CE=wh8516BtGzudxs-fSiVPwdB@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_archivecleanup should remove WAL files also in pg_xlog?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Ответы Re: pg_archivecleanup should remove WAL files also in pg_xlog?  (Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>)
Список pgsql-hackers
On Mon, Dec 13, 2010 at 4:28 PM, Heikki Linnakangas
<heikki.linnakangas@enterprisedb.com> wrote:
> On 13.12.2010 08:44, Fujii Masao wrote:
>>
>> pg_archivecleanup removes unnecessary WAL files from the archive, but not
>> from pg_xlog directory. So, after failover, those WAL files might
>> exist in pg_xlog and be archived again later.
>
> A file that has already been archived successfully should not be archived
> again. The server keeps track of which files it has already archived with
> the .ready/.done files.

This seems to require
   * archiver to save the last archived WAL file name in the shmem   * walsender to send it to walreceiver   *
walreceiverto create .done file when it's arrived   * bgwriter not to remove WAL files which don't have .done file in
standby

Right? One good side effect of this is that we can prevent WAL files from
being removed from the standby before the master archives them.

Regards,

-- 
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jan Urbański
Дата:
Сообщение: hstores in pl/python
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: pg_archivecleanup should remove WAL files also in pg_xlog?