Re: Archiver not picking up changes to archive_command - Mailing list pgsql-general

From Greg Smith
Subject Re: Archiver not picking up changes to archive_command
Date
Msg-id 4BE8AEE0.7080701@2ndquadrant.com
Whole thread Raw
In response to Re: Archiver not picking up changes to archive_command  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Archiver not picking up changes to archive_command  (bricklen <bricklen@gmail.com>)
List pgsql-general
Tom Lane wrote:
> A look at the code shows that the archiver only notices SIGHUP once
> per outer loop, so the change would only take effect once you catch up,
> which is not going to help much in this case.  Possibly we should change
> it to check for SIGHUP after each archive_command execution.
>

I never considered this a really important issue to sort out because I
tell everybody it's unwise to put something complicated directly into
archive_command.  Much better to call a script that gets passed %f/%p,
then let that script do all the work; don't even have to touch the
server config if you need to fix something then.  The lack of error
checking that you get when just writing some shell commands directly in
the archive_command itself horrifies me in a production environment.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: peer-to-peer replication with Postgres
Next
From: Scott Marlowe
Date:
Subject: Re: peer-to-peer replication with Postgres