pg_dump integrity question

[Hisham Al-Shurafa]

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?
Thanks for all your help.

Hisham

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Bruno Wolff III]

On Thu, Oct 02, 2003 at 15:10:52 -0400,
Hisham Al-Shurafa <ha********@rim.net> 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.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

[scott.marlowe]

On Thu, 2 Oct 2003, 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?

read this:

http://www.postgresql.org/docs/7.3/static/backup.html
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings