By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,903 Members | 1,086 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,903 IT Pros & Developers. It's quick & easy.

pg_dump integrity question

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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)

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.