Tom Lane wrote: > Steve Clark <sclark@xxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
