Any last hope advice? - Mailing list pgsql-general

From Eliel Mamousette
Subject Any last hope advice?
Date
Msg-id F136KjUbEtKVCvvMSaQ000088ef@hotmail.com
Whole thread Raw
List pgsql-general
I have a disaster machine where [for sake of brevity, I will leave
out how we got here] the only directory whose contents can be trusted
is the $PGDATA/base directory.

The platform is PG_VERSION 7.1 running on RedHat Linux 7.0, kernel
2.2.16.

After trying contrib/pg_resetxlog, I've still had no luck.

Any last resort solutions to be tried?  Through analysis of the files in
$PGDATAbase, I am able to identify the OID->DBname mappings, but am not
sure I can do that with the tables.  Since that's the case, is there a way
to
initdb and insert the OIDs for the databases into pg_database?

Any help would be appreciated,
eliel



_________________________________________________________________
MSN Photos is the easiest way to share and print your photos:
http://photos.msn.com/support/worldwide.aspx


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: changing varchar limits
Next
From: Manuel Cano Muñoz
Date:
Subject: Re: Referential integrity doesn't work? (Thanks a lot)