Postgres Pro
Downloads
Home   >   mailing lists

Thread: lock the database

lock the database

From
Maggie Chan
Date:
Hello

I am using postgreSQL 7.0.2. Is it necessary to lock the database before
backup the database (using pg_dump), if not necessary, will the database corrupt when someone is
accessing the database during pg_dump processing?

Thanks in advance!

Maggie

Re: lock the database

From
Peter Eisentraut
Date:
Maggie Chan writes:

> I am using postgreSQL 7.0.2. Is it necessary to lock the database before
> backup the database (using pg_dump), if not necessary, will the database corrupt when someone is
> accessing the database during pg_dump processing?

No need to lock.  The dumped data will be a consistent snapshot of the
time when pg_dump started to run (or briefly thereafter anyway).
Anything done to the database after pg_dump started will not be in the
dump.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/