On Tue, 11 Aug 2009, Dimitri Fontaine wrote:
> We should somehow provide a default archive and restore command integrated
> into the main product, so that it's as easy as turning it 'on' in the
> configuration for users to have something trustworthy: PostgreSQL will keep
> past logs into a pg_xlog/archives subdir or some other default place, and
> will know about the setup at startup time when/if needed.
Wandering a little off topic here because this plan reminded me of
something else I've been meaning to improve...while most use-cases require
some sort of network transport for this to be useful, there is one obvious
situation where it would be great to have a ready to roll setup by
default. Right now, if people want to make a filesystem level background
of their database, they first have to grapple with setting up the archive
command to do so. If the system were shipped in a way that made that
trivial to active, perhaps using something like what you describe here,
that would reduce the complaints that PostgreSQL doesn't have any easy way
to grab a filesystem hotcopy of the database. Those rightly pop up
sometimes, and it would be great if the procedure were reduced to:
1) Enable archiving
2) pg_start_backup
3) rsync/tar/cpio/copy/etc.
4) pg_stop_backup
5) Disable archiving
Because the default archive_command was something that supported a
filesystem snapshot using a standard layout.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD