Re: Consistent pg_dump's

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: Doug McNaught <doug(at)wireboard(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Consistent pg_dump's
Date: 2001-03-29 22:56:30
Message-ID: m3wv98kwv5.fsf@dep1.fciencias.unam.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug McNaught <doug(at)wireboard(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-03-29 23:09:25 Re: Consistent pg_dump's
Previous Message Soma Interesting 2001-03-29 22:38:31 dynamic field names in a function.