Thread: backing up without lock ?
Hello, Is it possible to backup postgresql databases without locking tables. Thanks
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
On Mon, 2005-07-18 at 12:51, Scott Marlowe wrote: > 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. That should be NOT POSSIBLE (with pg_dump)... sigh, I need an editor.
Hi, do you need an fs-backup or only dumps? You can Backup with Dumps and archived WAL's by using pg_dump + pg_start/stop_backuo(). If you need a fs-backup, maybe xfs_freeze with syncing the complete database (including WAL's) is a solution. Best regards, Martin Am Montag, den 18.07.2005, 13:25 -0400 schrieb FM: > Hello, > Is it possible to backup postgresql databases without locking tables. > > Thanks > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
On 7/18/05, FM <dist-list@lexum.umontreal.ca> wrote: > Hello, > Is it possible to backup postgresql databases without locking tables. You mean, like: http://www.postgresql.org/docs/current/static/backup-online.html Or do you need a "dump" of database (then use pg_dumpall). Regards, Dawid
Hi, do you need an fs-backup or only dumps? You can Backup with Dumps and archived WAL's by using pg_dump + pg_start/stop_backuo(). If you need a fs-backup, maybe xfs_freeze with syncing the complete database (including WAL's) is a solution. Best regards, Martin Am Montag, den 18.07.2005, 13:25 -0400 schrieb FM: > Hello, > Is it possible to backup postgresql databases without locking tables. > > Thanks > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings