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/