Re: Consistent pg_dump's

Manuel Sugawara <masm@fciencias.unam.mx>

From: Manuel Sugawara <masm@fciencias.unam.mx>
To: Doug McNaught <doug@wireboard.com>
Cc: pgsql-general@postgresql.org
Date: 2001-03-29T22:56:30Z
Lists: pgsql-general
Doug McNaught <doug@wireboard.com> writes:

> 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.  ;)

Yes, you are right, this is done in pg_dump with the command:

set transaction isolation level serializable

Regards,
Manuel.