Thread: pg_dump integrity question
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 theintegrity of the dumped data guaranteed? Does pg_dump lock the whole database when reading from it? Thanks for all your help. Hisham
On Thu, Oct 02, 2003 at 15:10:52 -0400, Hisham Al-Shurafa <halshurafa@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 theintegrity 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.
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