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
