Re: Any last hope advice?

От:

Justin Clift <justin@postgresql.org>

Дата:

1 августа 2002 г. в 19:41:44

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

Any last hope advice?

От:

"Eliel Mamousette" <eliel_mamousette@hotmail.com>

Дата:

1 августа 2002 г. в 19:33:34

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

Re: Any last hope advice?

От:

"Eliel Mamousette" <eliel_mamousette@hotmail.com>

Дата:

2 августа 2002 г. в 11:29:01

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 
>To: Eliel Mamousette 
>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