Hi Eliel,
There is a file utility for PostgreSQL Database Recovery mentioned on
the front page of the PostgreSQL Technical Documentation site:
http://techdocs.postgresql.org
It's under the "Recovery" heading of the "Technical Guides and
Documents" section on the front page.
Hope that helps. I haven't used it, but it might be the right tool
(definitely make a backup copy of everything in your $PGDATA/base
directory and all it's subdirectories first).
Hope this helps.
:-)
Regards and best wishes,
Justin Clift
Eliel Mamousette wrote:
>
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi
