Postgres Pro
Downloads
Home   >   mailing lists

Re: wal segment failed - Mailing list pgsql-admin

From David G. Johnston
Subject Re: wal segment failed
Date
Msg-id CAKFQuwbwwt_Oej528uJAZXywHWgmPrjv+YAtOPbTwz6JJPaKgQ@mail.gmail.com
Whole thread Raw
In response to wal segment failed  (Lucas Possamai <drum.lucas@gmail.com>)
Responses Re: wal segment failed  (Lucas Possamai <drum.lucas@gmail.com>)
List pgsql-admin
Tree view
On Tue, May 17, 2016 at 8:03 PM, Lucas Possamai <drum.lucas@gmail.com> wrote:

Failed to archive WAL segment `pg_xlog/00000002000011E800000012` on host `localhost:30022


Guys I'm getting that erro on my master server, and I believe that is causing a spike


archive command:

archive_command = 'exec nice -n 19 ionice -c 2 -n 7 ../../bin/archive_command.ssh_to_slaves.bash "%p" prod-db-01 prod-db-02 localhost:30022'



Any idea why?

If the reason you haven't show the logs of relevant errors from your script the following will hopefully point you in the right direction.

http://www.postgresql.org/docs/current/static/runtime-config-logging.html#GUC-LOGGING-COLLECTOR

General info on archive_command usage:

http://www.postgresql.org/docs/current/static/continuous-archiving.html

David J.

pgsql-admin by date:

Previous
From: Lucas Possamai
Date:
Subject: wal segment failed
Next
From: Lucas Possamai
Date:
Subject: Re: wal segment failed