Re: full db locking during dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: guomo(at)yahoo(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: full db locking during dump
Date: 2004-01-09 02:27:28
Message-ID: 19670.1073615248@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Gregory Stone <guomo(at)yahoo(dot)com> writes:
> I have a situation where I am doing a pg_dump from my database. I want to
> make sure that noone is inserting into the tables being dump during the
> dump. Does the MVCC architecture make it a moot point

It's moot. You get a consistent snapshot as of the dump start time,
regardless.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2004-01-09 02:54:26 Re: Backend start-up failed FATAL : non-superuser
Previous Message Gregory Stone 2004-01-09 02:11:03 full db locking during dump