pg_dump locks a table on dumping ... ?

Поиск
Список
Период
Сортировка
От Marc G. Fournier
Тема pg_dump locks a table on dumping ... ?
Дата
Msg-id 20040323121850.Q3456@ganymede.hub.org
обсуждение исходный текст
Ответы Re: pg_dump locks a table on dumping ... ?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Sailesh Krishnamurthy
Дата:
Сообщение: Re: linked list rewrite
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump locks a table on dumping ... ?