Re: pg_archivecleanup with multiple slaves

Поиск
Список
Период
Сортировка
От Fujii Masao
Тема Re: pg_archivecleanup with multiple slaves
Дата
Msg-id BANLkTi=S7bm_2jQfhLZec1OXyUVSW8K7HQ@mail.gmail.com
обсуждение исходный текст
Ответ на pg_archivecleanup with multiple slaves  (Ben Lancaster <benlancaster@holler.co.uk>)
Ответы Re: pg_archivecleanup with multiple slaves
Список pgsql-admin
On Fri, May 20, 2011 at 7:59 PM, Ben Lancaster
<benlancaster@holler.co.uk> wrote:
> The problem I have is that pg_archivecleanup (running on one of the slaves) was removing WAL logs before the other
slavehad picked up the changes, thus breaking replication for the second slave. As an interim fix, I simply disabled
theautomatic cleanup and figured I'd worry about it later. 

I'm afraid there is no clean solution. In order to address this
problem, we probably
should change the master for 9.2 so that it collects the information
about the cutoff
point from each standby and calls pg_archivecleanup.

Regards,

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

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

Предыдущее
От: Ben Lancaster
Дата:
Сообщение: Re: pg_archivecleanup with multiple slaves
Следующее
От: Craig James
Дата:
Сообщение: Who is causing all this i/o?