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