pg_dump does a snapshot at backup start, so your backups will be consistent even if there is activity.
--------------------------------------------------------------------------- [EMAIL PROTECTED] wrote: > > > Hi: > > A question regarding backups. Commercial databases I've administered have had > some facility to freeze or redirect transactions when a backup is being taken > from a database which is online, in order to insure that the backup snapshots a > consistant database. > > Does postgresql have a similar facility, or do I have to script some solution, > perhaps forcing all sessions to be dropped before doing a pg_dump ? > > Thanks, > -- Pat > > > ------------------------------------------------- > This mail sent through IMP: http://horde.org/imp/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
