Skip site navigation (1) Skip section navigation (2)

Re: Consistent pg_dump's

From: "Gregory Wood" <gregw(at)com-stock(dot)com>
To: "PostgreSQL-General" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Consistent pg_dump's
Date: 2001-03-30 05:25:29
Message-ID: 007001c0b8d9$d94a8ed0$7889ffcc@comstock.com (view raw or flat)
Thread:
Lists: pgsql-general
> > 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


In response to

pgsql-general by date

Next:From: Gregory WoodDate: 2001-03-30 05:27:39
Subject: Re: function to operate on same fields, different records?
Previous:From: Gregory WoodDate: 2001-03-30 05:23:03
Subject: Re: database dirs very stange on solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group