Re: pg_dumpall

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.

            regards, tom lane