Thread: pgfsck for 8.0.4?

pgfsck for 8.0.4?

From
"patrick"
Date:
since i can't recover my database with $PGDATA/base - $PGDATA/pg_xlog -
$PGDATA/pg_clog, but not the global. i get always no realtions founds. i was
browsing the web and found this tool :

is there a new version compatible with version 8 of postgres?
http://svana.org/kleptog/pgsql/pgfsck.html

patrick



Re: pgfsck for 8.0.4?

From
Martijn van Oosterhout
Date:
On Wed, Apr 05, 2006 at 05:29:36PM -0400, patrick wrote:
> since i can't recover my database with $PGDATA/base - $PGDATA/pg_xlog -
> $PGDATA/pg_clog, but not the global. i get always no realtions founds. i
> was browsing the web and found this tool :
>
> is there a new version compatible with version 8 of postgres?
> http://svana.org/kleptog/pgsql/pgfsck.html

Nope. Someone was looking into it once but never heard anything since.

Quick hint, have you actually connected to othe correct database, maybe
that's why there's nothing in it?
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.

Attachment

Re: pgfsck for 8.0.4?

From
"patrick"
Date:
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)


mydb should be a text or the oid... hum...
patrick

Re: pgfsck for 8.0.4?

From
Tom Lane
Date:
"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