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

From Bruce Momjian
Subject Re: Point in time recovery?
Date
Msg-id 200303221728.h2MHSOZ14673@candle.pha.pa.us
Whole thread Raw
In response to Point in time recovery?  (<eivind.arnesen@netcom.no>)
List pgsql-general
There is no backpatch available --- a beta may be available in June.

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

eivind.arnesen@netcom.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@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073


pgsql-general by date:

Previous
From: "Ed L."
Date:
Subject: Re: 32/64-bit transaction IDs?
Next
From: Tom Lane
Date:
Subject: Re: Thousands INSERT going slow ...