Re: lock the database - Mailing list pgsql-admin

From Peter Eisentraut
Subject Re: lock the database
Date
Msg-id Pine.LNX.4.30.0102241220180.1317-100000@peter.localdomain
Whole thread Raw
In response to lock the database  (Maggie Chan <mchan@corpmart.com>)
List pgsql-admin
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/


pgsql-admin by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: relation does not exist
Next
From: R D
Date:
Subject: Indexes and Views