From: Kevin Grittner <kgrittn@ymail.com>
To: Mathis, Jason <jmathis@enova.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: postgresql says archive is failing but its not
Date: Fri, 9 Jan 2015 18:50:55 +0000 (UTC)
Message-ID: <1212562520.4253282.1420829455349.JavaMail.yahoo@jws100200.mail.ne1.yahoo.com> (raw)
In-Reply-To: <CABAbqyfKY=H7oXAg6+PybePNXWDw1V5BvbOjVZeFMsSh+dAqkA@mail.gmail.com>
References: <CABAbqyfKY=H7oXAg6+PybePNXWDw1V5BvbOjVZeFMsSh+dAqkA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
"Mathis, Jason" <jmathis@enova.com> wrote:
> On Fri, Jan 9, 2015 at 11:58 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
>> "Mathis, Jason" <jmathis@enova.com> wrote:
>>
>>> I am getting some weird archiving failed messages in the logs
>>> but nothing is failing. I *think* its just exiting with a non
>>> zero code from the script.
>>
>> The archive command (script or not) must exit with 0 if
>> successful. A nonzero exit code indicates failure.
>
> But if it was failing then I would be having a stack of *.ready
> files right? In fact I should have a
> "0000000100002ED0000000CB.ready" file but I don't. It weird man,
> so weird.
Well, you didn't show this script. Is it perhaps directly messing
with the *.ready files instead of leaving them to PostgreSQL to
manage? If it's doing one thing wrong (i.e., using a nonzero exit
code after copying to the archive directory) perhaps it's doing
something else wrong (like removing the copied WAL file or messing
with the *.ready files). If you mess with internals that you
shouldn't be touching, you can expect weird.
Perhaps the script was initially only getting one of these things
wrong and it was causing failures, so the author went further down
the rabbit hole in an attempt to get it sorta working?
--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: kgrittn@ymail.com, jmathis@enova.com
Subject: Re: postgresql says archive is failing but its not
In-Reply-To: <1212562520.4253282.1420829455349.JavaMail.yahoo@jws100200.mail.ne1.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox