lock the database

From: Maggie Chan <mchan(at)corpmart(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: lock the database
Date: 2001-02-22 04:37:14
Message-ID: Pine.GSO.4.33.0102221233490.25852-100000@juventus.corpmart.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Terence Chan 2001-02-22 07:03:36 Re: date in european style
Previous Message Tom Lane 2001-02-22 04:28:07 Re: Using the correct index