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.