Insuring consistant backups

From: spinler(at)kmtel(dot)com
To: pgsql-admin(at)postgresql(dot)org
Subject: Insuring consistant backups
Date: 2002-12-10 03:33:05
Message-ID: 1039491185.3df560710c432@www.kmtel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2002-12-10 03:50:48 Re: Insuring consistant backups
Previous Message Jesus Sandoval 2002-12-10 01:53:50 Applictaion data Logging