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

From Dimitri Fontaine
Subject Re: postgresql.conf archive_command example
Date
Msg-id 87pqjjida2.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: postgresql.conf archive_command example  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: postgresql.conf archive_command example
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
>> I'm also wondering if providing some shell script examples of a
>> fault-tolerant script to handle archiving would be useful.
>
> I think it would.

My usual advice is to avoid having to write one if possible, because
it's more complex than it looks.  What about recommending existing
solutions, such as walmgr from Skytools?

Even better, what about including a default archiving tool, that could
be either another script in bin/ or rather an internal command.  The
default would accept a location as argument, for simple needs you mount
a remote filesystem and there you go.  If you need something more
complex, you still can provide it yourself.

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: PATCH: regular logging of checkpoint progress
Next
From: Dimitri Fontaine
Date:
Subject: Re: pg_restore --no-post-data and --post-data-only