| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | (Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Jose Norberto" <nn_jose(at)hotmail(dot)com>) |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Locking a database |
| Date: | 2001-05-01 14:35:34 |
| Message-ID: | 3.0.5.32.20010501223534.008b3790@192.228.128.13 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 03:08 PM 4/30/01 -0400, Tom Lane wrote:
>"Jose Norberto" <nn_jose(at)hotmail(dot)com> writes:
>> I want to make a pg_dump of a database, but I must be sure that no one is
>> logged in.
>
>Why?
>
>pg_dump will return a consistent state of the database even if other
>transactions are proceeding meanwhile.
Maybe it's a final dump before a db upgrade/swap.
The consistent database state must also be consistent with what the rest of
the world thinks.
e.g. no customers ordering stuff or users doing stuff that's left out in
the pg_dump.
Cheerio,
Link.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F. O'Connell | 2001-05-01 15:13:28 | Re: Primary Keys |
| Previous Message | Aaron Watters | 2001-05-01 13:50:03 | Re: Report Writer for PostgreSQL |