Re: [ADMIN] Insuring consistant backups

2002-12-09 Thread Dan Langille
On 9 Dec 2002 at 21:33, [EMAIL PROTECTED] wrote: > 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 ? >From man pg_dump and http://www.postgresql.org/idocs/index.php?app- pgdump.html: pg_dump make

Re: [ADMIN] Insuring consistant backups

2002-12-09 Thread Bruce Momjian
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

[ADMIN] Insuring consistant backups

2002-12-09 Thread spinler
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 fa