Re: Point in time recovery? - Mailing list pgsql-general

From Doug McNaught
Subject Re: Point in time recovery?
Date
Msg-id m3smtf47xz.fsf@varsoon.wireboard.com
Whole thread Raw
In response to Point in time recovery?  (<eivind.arnesen@netcom.no>)
List pgsql-general
<eivind.arnesen@netcom.no> writes:

> If an error occur (hardware or software failure) we would be able
> to load the last backup from pg_dump.  However, what about transactions
> that has occured after the last backup? Would we be able to roll
> forward to a particular point in time, so that the chances for data
> loss is minimal?  I've heard that this feature is currently missing,
> but that it will be introduced in version 7.4 which should be out this
> year.

This is the current plan, but it's not definite.  Whether it makes it
into 7.4 depends on whether it's done before the beta cutoff.

> My problem is that we cannot recommend this product unless this feature
> is present. If this feature won't be available until next release,
> is it possible to patch the current version or download a development
> version so that we could test that this feature really works?

From what I've seen on the -hackers list, it's not that far along yet.

> I really do not have much time, as we need to make a decision real
> soon, and without being 100% certain that PostgreSQL will meet our
> needs, we cannot recomment this product.

It's definitely not 100% certain at this point.

-Doug

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Thousands INSERT going slow ...
Next
From: Doug McNaught
Date:
Subject: Re: Getting Network Statistics