| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Maggie Chan <mchan(at)corpmart(dot)com> |
| Cc: | <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: lock the database |
| Date: | 2001-02-24 11:21:56 |
| Message-ID: | Pine.LNX.4.30.0102241220180.1317-100000@peter.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net http://yi.org/peter-e/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | R D | 2001-02-24 11:22:53 | Indexes and Views |
| Previous Message | Stephan Szabo | 2001-02-24 07:21:19 | Re: relation does not exist |