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

From Kevin Grittner
Subject Re: postgresql.conf archive_command example
Date
Msg-id 4E60C7C80200002500040B4D@gw.wicourts.gov
Whole thread Raw
In response to Re: postgresql.conf archive_command example  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> wrote:
> maybe instead of shipping a more complicated script we should be
> trying to eliminate (or at least reduce) the need for a more
> complicated script.
That was the intent of my pg_archiveto suggestion.  I'll amend it
(based on other comments) to allow for a URL as an alternative way
to specify the directory.  So your archive_command might be:
'pg_archiveto /var/pgsql/backup/wal/ %p %f'
or:
'pg_archiveto http://backup-server/mydbserver/wal/ %p %f'
or maybe:
'pg_archiveto /mnt/someremotedirectory/ %p %f'
-Kevin


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: postgresql.conf archive_command example
Next
From: "Kevin Grittner"
Date:
Subject: Re: postgresql.conf archive_command example