pg_dump locks a table on dumping ... ?

From: "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_dump locks a table on dumping ... ?
Date: 2004-03-23 16:20:24
Message-ID: 20040323121850.Q3456@ganymede.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


'k, just had someone tell me that they believed that a pg_dump will lock a
table while the dump is happening ... my first thought/response was that
this would defeat the point of MVCC, no? And would make for a terrible
backup procedure on a very large database, since you'd just have made your
database useless for the duration ...

Can someone confirm/deny that the lock happens?

----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-03-23 16:22:45 Re: dollar quoting and pg_dump
Previous Message Heikki Linnakangas 2004-03-23 16:10:35 Re: Two-phase commit