Re: Point in Time Backups

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Point in Time Backups
Date: 2002-10-23 18:02:06
Message-ID: 20021023140206.J18036@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Thu, Oct 17, 2002 at 06:47:23AM -0500, D. S. Johnson wrote:
> As most DB's know to get full integrity in a backup you either have to
> perform cold backups or have a point in time capable hot backup. If
> Postgresql is truely useful as a production database you need a full
> point in time backup and recovery system. I would consider using
> Postgres for several commercial applications but, not at the expense of
> losing my clients due to loss of data.

Point in time will apparently be available in 7.4; there's a patch
sitting queued up for just this purpose, but it wasn't ready in time
for the 7.3 feature freeze.

In the meantime, you can buy cheap insurance by replicating your
database.

A

--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Boes 2002-10-23 18:08:30 Re: Print line?
Previous Message Gareth Kirwan 2002-10-23 17:36:32 Re: shared memory number