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. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
