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.