Re: Large pg_xlog - Mailing list pgsql-general

From Michael Paquier
Subject Re: Large pg_xlog
Date
Msg-id CAB7nPqSQxRby50oD7rkn5oR93KbOqmcoiu86GtP4hTR8-Vzs=A@mail.gmail.com
Whole thread Raw
In response to Re: Large pg_xlog  (Francisco Reyes <lists@natserv.net>)
Responses Re: Large pg_xlog  (Francisco Reyes <lists@natserv.net>)
List 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 by date:

Previous
From: Francisco Reyes
Date:
Subject: Re: Large pg_xlog
Next
From: Michael Paquier
Date:
Subject: Re: Replication slot on master failure