Re: pg_dump integrity question
От
Bruno Wolff III
Тема
Re: pg_dump integrity question
Дата
Msg-id
20031002193739.GC18417@wolff.to
Ответ на
pg_dump integrity question (Hisham Al-Shurafa)
Список
Дерево обсуждения
pg_dump integrity question "Hisham Al-Shurafa" <halshurafa@rim.net>
Re: pg_dump integrity question Bruno Wolff III <bruno@wolff.to>
Re: pg_dump integrity question "scott.marlowe" <scott.marlowe@ihs.com>
On Thu, Oct 02, 2003 at 15:10:52 -0400, Hisham Al-Shurafa wrote: > Hello, > > > Anyone know if it is safe to do a pg_dump on a database while other programs might be making changes to the data? Is the integrity of the dumped data guaranteed? Does pg_dump lock the whole database when reading from it? It is safe to use pg_dump while other people are using the DB. It will dump the DB as it was when the dump started so that the dump is a consistant view of the DB. It does not lock the DB while doing this because with MVCC it doesn't have to.
В списке pgsql-general по дате отправления
