Re: Consistent pg_dump's - Mailing list pgsql-general

From Manuel Sugawara
Subject Re: Consistent pg_dump's
Date
Msg-id m3wv98kwv5.fsf@dep1.fciencias.unam.mx
Whole thread Raw
In response to Consistent pg_dump's  (Alexey Rodriguez Yakushev <alexey@serinbol.com>)
List 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.

pgsql-general by date:

Previous
From: Alfred Perlstein
Date:
Subject: Re: Consistent pg_dump's
Next
From: Alfonso Peniche
Date:
Subject: Re: create user