Re: pg_dumpall

Tom Lane wrote:
> Steve Clark <sclark@netwolves.com> writes:
> > does pg_dumpall make consistent backups if the database is being used
> > concurrently?
> > Even though the man page doesn't say it does.
>
> That's intentional, because it doesn't.  What you get is a pg_dump
> snapshot of each database in sequence; those snapshots don't all
> correspond to the same time instant.  There isn't any good way to
> guarantee time coherence of dumps across two databases.

The fine point possibly being missed is that each database's dump
produced by pg_dumpall is, of course, self-consistent.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.