Re: pg_dumpall

Out of interest, how does pg_dump manage to do a snapshot of a
database at an instant in time?

My mental picture of pg_dump was just a series of queries dumping out
the tables...

--- Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Steve Clark <sclark(at)netwolves(dot)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
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

___________________________________________________________
Support the World Aids Awareness campaign this month with Yahoo! For Good http://uk.promotions.yahoo.com/forgood/