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@sss.pgh.pa.us> wrote:

> 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
>
> ---------------------------(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/