Re: Corrupted database - how to recover - Mailing list pgsql-admin

From Johann Spies
Subject Re: Corrupted database - how to recover
Date
Msg-id 20100527143140.GA3823@sun.ac.za
Whole thread Raw
In response to Re: Corrupted database - how to recover  (Andreas Schmitz <mailinglist@longimanus.net>)
List pgsql-admin
On Thu, May 27, 2010 at 09:54:00AM +0200, Andreas Schmitz wrote:
>
> maybe you should consider using point in time recovery (pitr) if the
> database is mission critical.
>
> http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html

Thanks.  This is the first time I experienced this type of problem.
Fortunately the data was not that critical.  I agree that pitr should be
a part of any mission critical setup.

Regards
Johann
--
Johann Spies          Telefoon: 021-808 4599
Informasietegnologie, Universiteit van Stellenbosch

     "All that the Father giveth me shall come to me; and
      him that cometh to me I will in no wise cast out."
                                      John 6:37

pgsql-admin by date:

Previous
From: Nilesh Govindarajan
Date:
Subject: Re: How to add constraints without validating data.
Next
From: "Kevin Grittner"
Date:
Subject: Re: future development of xml capabilities