Re: PGSQL Database Recovery in Portland Oregon Area needed ASAP - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: PGSQL Database Recovery in Portland Oregon Area needed ASAP
Date
Msg-id 20060518053945.GB32755@svana.org
Whole thread Raw
In response to PGSQL Database Recovery in Portland Oregon Area needed ASAP  ("Mark Holm" <markh@infoarch.com>)
List pgsql-general
On Tue, May 16, 2006 at 09:53:54AM -0700, Mark Holm wrote:
> I have a client that is running an older version of Lyris List
> Manager against PostGres 7.1.2, that has crashed their database
> beyond my ability to recover it. The error that I am getting when we
> try and restart the database is:

Very old database, consider upgrading.

> I have gone through the stuff on-line concerning this error and
> attempted to reinitialize the database and restore the night before's
> backup, but apparently the backups were not quite setup correctly as
> I cannot get a valid restore either. I am out of my depth on this one
> and am willing to contract somebody to help get this database back
> on-line again ASAP, as the client is getting frantic. If you have
> proven experience doing this sort of recovery, please contact me at
> the number or email address below. I am not a member of the lists, so
> please contact me directly. Rates are negotiable, but I will have to
> clear them with client before we proceed.

Make sure you have a physical backup. pg_resetxlog may get you far
enough to start the server. Them immediatly dump, destroy the cluster
and restore. pg_resetxlog solves some problems, but you can't guarentee
your integrity anymore...

Have a ncie day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: PG_DIAG_STATEMENT_POSITION Where is it defined?
Next
From: Peter Kovacs
Date:
Subject: Re: Why won't it index scan?