|
Home > Archive > PostgreSQL Discussion > April 2006 > pgfsck for 8.0.4?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| patrick 2006-04-05, 8:25 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
| |
| Martijn van Oosterhout 2006-04-05, 8:25 pm |
| 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.
| |
| patrick 2006-04-05, 8:25 pm |
| 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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
| |
| Tom Lane 2006-04-05, 8:25 pm |
| "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
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
|
|
|
|
|