Re: Point in time recovery?

<eivind(dot)arnesen(at)netcom(dot)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