Insuring consistant backups - Mailing list pgsql-admin

From spinler@kmtel.com
Subject Insuring consistant backups
Date
Msg-id 1039491185.3df560710c432@www.kmtel.com
Whole thread Raw
Responses Re: Insuring consistant backups
Re: Insuring consistant backups
List pgsql-admin

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/


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL 7.3 Installation on SCO
Next
From: Bruce Momjian
Date:
Subject: Re: Insuring consistant backups