On Mon, 2005-07-18 at 12:25, FM wrote:
> Hello,
> 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.
http://www.postgresql.org/docs/8.0/static/app-pgdump.html