Re: postgresql.conf archive_command example - Mailing list pgsql-hackers

From Robert Haas
Subject Re: postgresql.conf archive_command example
Date
Msg-id CA+TgmoY6xcvT_TPFUwuxR4ur7iPOzonoBE=Bq1w1aHSnqFeBUQ@mail.gmail.com
Whole thread Raw
In response to Re: postgresql.conf archive_command example  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: postgresql.conf archive_command example
List pgsql-hackers
On Fri, Sep 2, 2011 at 3:29 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Robert Haas <robertmhaas@gmail.com> writes:
>> Another thought I have here is to wonder whether we should change
>> something on the server side so that we don't NEED such a complicated
>> archive_command.  I mean, copying a file to a directory somewhere is
>> not fundamentally a complex operation.  Nor is using ssh to copy it to
>> another machine.
>
> It is once you consider error handling and catering to N combinations of
> user requirements.
>
> I think the notion that we should get rid of archive_command in favor of
> something more hard-wired is sheer lunacy.  We have a nicely decoupled
> arrangement for dealing with these issues now; why would we want to pull
> them into the server?

I wasn't really proposing to get rid of it, but I do wonder if there
are some configuration parameters we could add somewhere that would
make common cases easier without making really complex things
impossible.

> Now, providing a more useful sample script is certainly reasonable.

Yep, so let's start with that.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql.conf archive_command example
Next
From: "Kevin Grittner"
Date:
Subject: Re: CF2011-09