Re: Large pg_xlog

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Large pg_xlog
Дата
Msg-id CAB7nPqSQxRby50oD7rkn5oR93KbOqmcoiu86GtP4hTR8-Vzs=A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Large pg_xlog  (Francisco Reyes <lists@natserv.net>)
Ответы Re: Large pg_xlog  (Francisco Reyes <lists@natserv.net>)
Список pgsql-general
On Tue, Sep 27, 2016 at 9:26 AM, Francisco Reyes <lists@natserv.net> wrote:
> The only times archive command failed I believe is because the volume where
> pg_xlog is ran out of space.
> FATAL:  archive command was terminated by signal 3: Quit
>
> There are 2 of those today. So that does not seem to be the cause.

What are the files in pg_xlog/archive_status? Do see a lot of .ready
entries? Perhaps you could de-bloat things by using archive_command =
'/bin/true' (REM on Windows as far as I recall).
--
Michael


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

Предыдущее
От: Francisco Reyes
Дата:
Сообщение: Re: Large pg_xlog
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: Replication slot on master failure