pg_dump locks a table on dumping ... ? - Mailing list pgsql-hackers

From Marc G. Fournier
Subject pg_dump locks a table on dumping ... ?
Date
Msg-id 20040323121850.Q3456@ganymede.hub.org
Whole thread Raw
Responses Re: pg_dump locks a table on dumping ... ?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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@hub.org           Yahoo!: yscrappy              ICQ: 7615664


pgsql-hackers by date:

Previous
From: Sailesh Krishnamurthy
Date:
Subject: Re: linked list rewrite
Next
From: Tom Lane
Date:
Subject: Re: pg_dump locks a table on dumping ... ?