Re: full db locking during dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: full db locking during dump
Дата
Msg-id 19670.1073615248@sss.pgh.pa.us
обсуждение исходный текст
Ответ на full db locking during dump  (Gregory Stone <guomo@yahoo.com>)
Список pgsql-general
Gregory Stone <guomo@yahoo.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Oleg Bartunov
Дата:
Сообщение: Re: website doc search is extremely SLOW
Следующее
От: "Glenn Wiorek"
Дата:
Сообщение: Re: [HACKERS] Announce: Search PostgreSQL related resources