pg_class could not be found

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

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 majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

--
Martijn van Oosterhout <kleptog(at)svana(dot)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.

Thanks Martijn

if i dump the db (pg_dumpall), the delete the pgsql
dir, start a new pgsql dir, the import with template1,
this error gone and the db can be checked by your
excelent tool.

also what is

--Table arraytype.. Unknown type

thanks

--- Martijn van Oosterhout <kleptog(at)svana(dot)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
> majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list
> cleanly
>
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)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

Martijn van Oosterhout <kleptog(at)svana(dot)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

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 <kleptog(at)svana(dot)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
> majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list
> cleanly
>
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)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

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 <kleptog(at)svana(dot)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.

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 <kleptog(at)svana(dot)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 <kleptog(at)svana(dot)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