Re: Sample archive_command is still problematic

On 08/19/2014 10:39 AM, Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> writes:
>> Well, if we want a sample command in the docs, then we should actually
>> give a few different sample commands and even a sample shell script.  If
>> we give the users several alternatives, maybe they'll actually think
>> about it instead of just C&P.
>
> Sure, if we can think of some plausibly different samples.

I was thinking:

1. noclobber copy to a local/mounted dir (the current example)

2. rsync to a remote dir  with overwrite

3. windows command example (hopefully using rsync ... can anyone help
with this?)

4. Simple bash script example using rsync to a target server, with
noarchiving touch file etc.

I'd also like to mention pg_receivexlog, Barman, WAL-E, and RepMgr as
external utilites and alternatives.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com