pg_class could not be found

[zhicheng wang]

hi,

has any one used Martijn van Oosterhout's PostgreSQL
table checker and dumper (pgfsck, at
http://svana.org/kleptog/pgsql/pgfsck.html)?

i ran this again my database and it gives this error:

Couldn't find relation pg_class(1259)

does any one know what this is about

cheng
=====
Best wishes
Z C Wang

__________________________________________________ __________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Martijn van Oosterhout]

Sigh. Sorry, that tool really needs some TLC to get it working across
all the versions of PostgreSQL I don't have access to. It's looking for
pg_class and is assuming it's OID 1259 and trying to open that file.
Evidently it's failing.

You'd need to indicate the version of the database, maybe strace it to
see where it's going wrong.

Hope this helps,

On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng wang wrote:

hi,

has any one used Martijn van Oosterhout's PostgreSQL
table checker and dumper (pgfsck, at
http://svana.org/kleptog/pgsql/pgfsck.html)?

i ran this again my database and it gives this error:

Couldn't find relation pg_class(1259)

does any one know what this is about

cheng


=====
Best wishes
Z C Wang





__________________________________________________ __________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly
--
Martijn van Oosterhout <kl*****@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.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFAwInfY5Twig3Ge+YRApWKAJ9ECgZykwS7H2ycnSX9eE k7O64smwCdFXMJ
A1vFaIuVNtg8f3Ip0BH7UEg=
=eGw8
-----END PGP SIGNATURE-----

[Tom Lane]

Martijn van Oosterhout <kl*****@svana.org> writes:

Sigh. Sorry, that tool really needs some TLC to get it working across
all the versions of PostgreSQL I don't have access to. It's looking for
pg_class and is assuming it's OID 1259 and trying to open that file.
Evidently it's failing.

I don't think it's a version issue; pg_class has always been OID 1259
(and relfilenode 1259, too). You might have version issues once you
started looking inside pg_class, but not before that.

Remember this is the guy whose disk drive seems to have committed major
sins of omission on his last shutdown. I think the file's probably just
plain gone :-(

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[zhicheng wang]

hi,
i can see the file 1259 is there and the db apparently
working normal and can be started/stopped OK.

if your tool cannot work on this set of db, does it
mean that the db is problematic? i am realy worried.

thanks in advance for advice.

cheng

--- Martijn van Oosterhout <kl*****@svana.org> wrote:

Sigh. Sorry, that tool really needs some TLC to get
it working across
all the versions of PostgreSQL I don't have access
to. It's looking for
pg_class and is assuming it's OID 1259 and trying to
open that file.
Evidently it's failing.

You'd need to indicate the version of the database,
maybe strace it to
see where it's going wrong.

Hope this helps,

On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng
wang wrote:

hi,

has any one used Martijn van Oosterhout's PostgreSQL

table checker and dumper (pgfsck, at
http://svana.org/kleptog/pgsql/pgfsck.html)?

i ran this again my database and it gives this

error:

Couldn't find relation pg_class(1259)

does any one know what this is about

cheng
=====
Best wishes
Z C Wang

__________________________________________________ __________

Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

---------------------------(end of

broadcast)---------------------------

TIP 3: if posting/reading through Usenet, please

send an appropriate

subscribe-nomail command to

ma*******@postgresql.org so that your

message can get through to the mailing list

cleanly

--
Martijn van Oosterhout <kl*****@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 part 2 application/pgp-signature

=====
Best wishes
Z C Wang

__________________________________________________ __________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Martijn van Oosterhout]

Maybe, but it doesn't work in some common cases apparently, I just
don't have anything setup on my machine to test everything out. I don't
even know which version you're running.

Like I said, it's needs a lot of TLC.

On Sat, Jun 05, 2004 at 06:37:55PM +0100, zhicheng wang wrote:

hi,
i can see the file 1259 is there and the db apparently
working normal and can be started/stopped OK.

if your tool cannot work on this set of db, does it
mean that the db is problematic? i am realy worried.

thanks in advance for advice.

cheng --
Martijn van Oosterhout <kl*****@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.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFAwkeXY5Twig3Ge+YRAkP4AKCBMD2lzYj9OQNt9TXoFO x5zTvmRQCfXBtW
7ltzlTWOO3AYYAWEGT/IUZ8=
=Pk5J
-----END PGP SIGNATURE-----

[zhicheng wang]

we are running redhat version 7.3.6-1 for EL AS3. most
of our db can be analyised by your tool. bot only one
is not. if we dump this one, init a db, then import
with template1, things are ok and your tool can be
used against this new db.

any suggestions?
please

cheng

--- Martijn van Oosterhout <kl*****@svana.org> wrote:

Maybe, but it doesn't work in some common cases
apparently, I just
don't have anything setup on my machine to test
everything out. I don't
even know which version you're running.

Like I said, it's needs a lot of TLC.

On Sat, Jun 05, 2004 at 06:37:55PM +0100, zhicheng
wang wrote:

hi,
i can see the file 1259 is there and the db apparently

working normal and can be started/stopped OK.

if your tool cannot work on this set of db, does

it

mean that the db is problematic? i am realy

worried.

thanks in advance for advice.

cheng

--
Martijn van Oosterhout <kl*****@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 part 2 application/pgp-signature

=====
Best wishes
Z C Wang

__________________________________________________ __________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[zhicheng wang]

hi,
i can see the file 1259 is there and the db apparently
working normal and can be started/stopped OK.

if your tool cannot work on this set of db, does it
mean that the db is problematic? i am realy worried.

thanks in advance for advice.

cheng

--- Martijn van Oosterhout <kl*****@svana.org> wrote:

Sigh. Sorry, that tool really needs some TLC to get
it working across
all the versions of PostgreSQL I don't have access
to. It's looking for
pg_class and is assuming it's OID 1259 and trying to
open that file.
Evidently it's failing.

You'd need to indicate the version of the database,
maybe strace it to
see where it's going wrong.

Hope this helps,

On Fri, Jun 04, 2004 at 02:33:08PM +0100, zhicheng
wang wrote:

hi,

has any one used Martijn van Oosterhout's PostgreSQL

table checker and dumper (pgfsck, at
http://svana.org/kleptog/pgsql/pgfsck.html)?

i ran this again my database and it gives this

error:

Couldn't find relation pg_class(1259)

does any one know what this is about

cheng
=====
Best wishes
Z C Wang

__________________________________________________ __________

Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

---------------------------(end of

broadcast)---------------------------

TIP 3: if posting/reading through Usenet, please

send an appropriate

subscribe-nomail command to

ma*******@postgresql.org so that your

message can get through to the mailing list

cleanly

--
Martijn van Oosterhout <kl*****@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 part 2 application/pgp-signature

=====
Best wishes
Z C Wang

__________________________________________________ __________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

[Martijn van Oosterhout]

Maybe, but it doesn't work in some common cases apparently, I just
don't have anything setup on my machine to test everything out. I don't
even know which version you're running.

Like I said, it's needs a lot of TLC.

On Sat, Jun 05, 2004 at 06:37:55PM +0100, zhicheng wang wrote:

hi,
i can see the file 1259 is there and the db apparently
working normal and can be started/stopped OK.

if your tool cannot work on this set of db, does it
mean that the db is problematic? i am realy worried.

thanks in advance for advice.

cheng --
Martijn van Oosterhout <kl*****@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.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFAwkeXY5Twig3Ge+YRAkP4AKCBMD2lzYj9OQNt9TXoFO x5zTvmRQCfXBtW
7ltzlTWOO3AYYAWEGT/IUZ8=
=Pk5J
-----END PGP SIGNATURE-----

[zhicheng wang]

we are running redhat version 7.3.6-1 for EL AS3. most
of our db can be analyised by your tool. bot only one
is not. if we dump this one, init a db, then import
with template1, things are ok and your tool can be
used against this new db.

any suggestions?
please

cheng

--- Martijn van Oosterhout <kl*****@svana.org> wrote:

Maybe, but it doesn't work in some common cases
apparently, I just
don't have anything setup on my machine to test
everything out. I don't
even know which version you're running.

Like I said, it's needs a lot of TLC.

On Sat, Jun 05, 2004 at 06:37:55PM +0100, zhicheng
wang wrote:

hi,
i can see the file 1259 is there and the db apparently

working normal and can be started/stopped OK.

if your tool cannot work on this set of db, does

it

mean that the db is problematic? i am realy

worried.

thanks in advance for advice.

cheng

--
Martijn van Oosterhout <kl*****@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 part 2 application/pgp-signature

=====
Best wishes
Z C Wang

__________________________________________________ __________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly