[EMAIL PROTECTED] wrote:
You should either have your backup application open the database and do a
BEGIN EXCLUSIVE; statement to ensure that no other processes can write to it
while you're backing it up
Derrell,
Just to clarify, you don't need to use an exclusive transaction. That
will acquire a write lock and unnecessarily block all other readers as
well. You only need to hold a read lock to prevent any other process
from acquiring a write lock.
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
