Consistent state for pg_dump and pg_dumpall - Mailing list pgsql-general

From Michael Nolan
Subject Consistent state for pg_dump and pg_dumpall
Date
Msg-id CAOzAquJyPRRmdsoXim+sDFW9212ve9K3qQ327HjUf2bNBp9-Ng@mail.gmail.com
Whole thread Raw
Responses Re: Consistent state for pg_dump and pg_dumpall
List pgsql-general
The documentation for pg_dump says that dump files are created in a consistent state.

Is that true across multiple tables in the same pg_dump command?  (Obviously it would not be true if I dumped tables using separate pg_dump commands.  But if I put the database into a backup state using 'pg_start_backup', would separately executed pg_dump commands be in a consistent state across the set of dump files?)

The documentation for pg_dumpall does not say that its dump file is in a consistent state (eg, across all tables), but it does say that it uses pg_dump to dump clusters.  So, how consistent are the tables in pg_dumpall files? 
--
Mike Nolan



pgsql-general by date:

Previous
From: William Dunn
Date:
Subject: Can we simulate Oracle Flashback with pg_export_snapshot()?
Next
From: "David G. Johnston"
Date:
Subject: Re: Consistent state for pg_dump and pg_dumpall