Re: wal segment failed

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Tue, May 17, 2016 at 8:03 PM, Lucas Possamai <drum.lucas@xxxxxxxxx> 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.