Thread: postgresql checking return status of archive_command?
hi all, First off, my thanks to everyone who responded to my last post regarding copying WAL segments to 2 standby servers. My scriptis working wonderfully now, but I have a followup question like the subject line. Does postgresql or any of its child processes check the return code of the command executedin the archive_command and does it log anything if that return code is NOT zero? I've been trying to think of easy ways to force an error to test, but thought I'd ask first. TIA, Jay
Hi, On Fri, 2014-07-11 at 10:01 -0400, John Scalia wrote: > Does postgresql or any of its child processes check the return code of > the command executed in the archive_command and does it log anything > if that return code is NOT zero? I've been trying to think of easy > ways to force an error to test, but thought I'd ask first. It does. It will throw an error to log file, if the return code is non-zero. Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Twitter: @DevrimGunduz , @DevrimGunduzTR
Attachment
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/11/2014 10:04 PM, Devrim Gündüz wrote: > It does. It will throw an error to log file, if the return code is > non-zero. One thing to watch out for is the unfortunate behaviour of pipe error handling, though. You want to set -o pipefail if you're using pipes. - -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/ iQEcBAEBAgAGBQJTwz5EAAoJELBXNkqjr+S2yxcH/jLNX/gqeb3mruemnP6wL5eQ mJxXq2EUcreyJcUuuE5PqtUtDUZUbqHtfcO+NQkloKDrJ6Oo8YNm7NCVWCBrfqdV bSCOIJaT6fosZIUY6GlqJXfSI7YZ98FZexXCb1B/r0cQU2NJXqOY9DS/Hae2RDSP qA83t4dl4boqC46I+s9qjIDKeDr8weXDHzA2Cv8D+nZpOY1ieoC8k98hE+2jJkcN Lyp+eVhPBaI+Puj8Tp5b5vvXGh1uFQjM73hufNk1QFLvPCpeca/1nzMQ+2FZQXx4 eQDSrC5c2NTFpjikXHxmljfqhzan+XixAhJpMWpIxgCzzwGWIHHtZJvfYcl+ofs= =ETgw -----END PGP SIGNATURE-----