Re: pg_dumpall

On Thu, 17 Jan 2008, Tom Lane wrote:

> There isn't any good way to guarantee time coherence of dumps across two
> databases.

Whether there's a good way depends on what you're already doing.  If
you're going to the trouble of making a backup using PITR anyway, it's not
hard to stop applying new logs to that replica and dump from it to get a
point in time backup across all the databases.  That's kind of painful now
because you have to start the server to run pg_dumpall, so resuming
recovery is difficult, but you can play filesystem tricks to make that
easier.

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD