Re: pgfsck for 8.0.4? - Mailing list pgsql-general

From Tom Lane
Subject Re: pgfsck for 8.0.4?
Date
Msg-id 12829.1144276433@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgfsck for 8.0.4?  ("patrick" <patrick@11h11.com>)
List pgsql-general
"patrick" <patrick@11h11.com> writes:
> this is what i got when trying it:
> ./pgfsck -D /virtual/data -s 8192 -d mydb
> -- Detected database format 8.0
> Couldn't find relation pg_class(1259)

I really seriously doubt that pgfsck would help at all anyway.
I think you've either not yet got your transaction counter fixed,
or you've got some other problem with sewing the new and old parts
of the installation together.  One possibility is that your pg_shadow
table (which would have been in global) needs to be tweaked; are you
sure it's got the right usesysid values for all your users?

            regards, tom lane

pgsql-general by date:

Previous
From: David Gama Rodrí­guez
Date:
Subject: % tsearch gendict
Next
From: Bruce Momjian
Date:
Subject: Re: pg 8.1.3 on AIX