Re: pgfsck for 8.0.4?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "patrick" <patrick(at)11h11(dot)com>
Cc: "Martijn van Oosterhout" <kleptog(at)svana(dot)org>, pgsql-general(at)postgresql(dot)org
Subject: Re: pgfsck for 8.0.4?
Date: 2006-04-05 22:33:53
Message-ID: 12829.1144276433@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"patrick" <patrick(at)11h11(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2006-04-05 22:55:34 Re: pg 8.1.3 on AIX
Previous Message David Gama Rodrí­guez 2006-04-05 22:15:30 % tsearch gendict