Re: Point in time recovery?

There is no backpatch available --- a beta may be available in June.

---------------------------------------------------------------------------

eivind(dot)arnesen(at)netcom(dot)no wrote:
> Hi!
>
> I work at a research institution (about 600 empoyees), and
> we are currently evaluating open source databases, particularly
> PostgreSQL for internal use..We currently have a multitude
> of commercial databases deployed (Oracle, MS SQL, Ingres, Interbase,
> etc.), but we would like to introduce and officially
> support an open source alternative to our researchers.
>
> In order to recommend and support PostgreSQL, we need to make sure
> that our data will be safe using PostgreSQL. I find the documentation
> inadequate with respect to database backup.
>
> 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.
>
> 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?
>
> 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.
>
> I would very much appreciate any relevant information on this matter.
>
> Eivind.
>
>
>
>
>
>
>
>
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073