On Mon, 2005-07-18 at 12:25, FM wrote:
> Is it possible to backup postgresql databases without locking tables.
Yes and no.
No, it's actually possible to backup postgresql without a lock.
However, it's an access shared lock, so it's not a blocking lock.
Also, the backup is coherent for a whole database at the point in time
the backup was initiated.
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2005-07-18 17:58:31|
|Subject: Re: backing up without lock ?|
|Previous:||From: Mogin Mohandas||Date: 2005-07-18 17:33:39|
|Subject: unable to configure|