Re: WAL shipping and ever expanding pg_xlog

Поиск
Список
Период
Сортировка
От Michael Dengler
Тема Re: WAL shipping and ever expanding pg_xlog
Дата
Msg-id e8733d090706130644m471b8690m9998ba2d30f6f747@mail.gmail.com
обсуждение исходный текст
Ответ на WAL shipping and ever expanding pg_xlog  ("Michael Dengler" <michael.dengler@gmail.com>)
Ответы Re: WAL shipping and ever expanding pg_xlog  ("Merlin Moncure" <mmoncure@gmail.com>)
Список pgsql-performance
OK....it looks like the slave machine has run out of space and that caused the xlog files to pile up on the master.

Still...how do I prevent such all of the shipped WAL segments from remaining on the slave machine? Do I need to retain every single one? Can they be safely removed after the slave machine has restored the particular segment?

Thanks

Mike


On 6/13/07, Michael Dengler <michael.dengler@gmail.com> wrote:
Hi,

I'm doing WAL shipping to do a warm standby system (8.2.4).

The problem is that the pg_xlog dir on the master just gets bigger and bigger (never seems to truncate) and the corresponding archive directory on the slave also gets bigger and bigger. Is there a way to moderate this?

Thanks

Mike


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

Предыдущее
От: "Michael Dengler"
Дата:
Сообщение: WAL shipping and ever expanding pg_xlog
Следующее
От: Vivek Khera
Дата:
Сообщение: Re: Best use of second controller with faster disks?