Justin, thanks for that tip. I'd read that article and tried pgfsck before
crying out for help. The problem is that pgfsck reports that it "can't find
class pg_attribute" when it's pointed to any of the tables in the database.
Anyone seen that kind of problem before and been able to fix it?
thanks,
eliel
>From: Justin Clift <justin@postgresql.org>
>To: Eliel Mamousette <eliel_mamousette@hotmail.com>
>CC: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] Any last hope advice?
>Date: Fri, 02 Aug 2002 09:41:42 +1000
>
>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
_________________________________________________________________
Join the world�s largest e-mail service with MSN Hotmail.
http://www.hotmail.com