Thread: Any last hope advice?
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
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
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