> > I am pretty sure that pg_dump produces a consistent snapshot, using > > the same transaction isolation mechanism (MVCC) as the database > > itself. If one of the gurus posts and says otherwise, believe him, > > not me. ;) > > My impression from reading the source was that it was consitant per-table > but not per-database. Meaning you'd get a consistant snapshot of a table, > but not of the entire system. > > I could be wrong though. I hope so... that could break some foreign key dependencies pretty badly... Greg ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl
