pg_class could not be found - PostgreSQL Database

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..."Pi ng"
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*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #1

Subscribe Reply

2520

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..."Pi ng"
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*******@postg resql.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

iD8DBQFAwInfY5T wig3Ge+YRApWKAJ 9ECgZykwS7H2ycn SX9eEk7O64smwCd FXMJ
A1vFaIuVNtg8f3I p0BH7UEg=
=eGw8
-----END PGP SIGNATURE-----

Nov 23 '05 #2

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

Nov 23 '05 #3

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..."Pi ng"
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*******@postg resql.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..."Pi ng"
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*******@postg resql.org so that your
message can get through to the mailing list cleanly

Nov 23 '05 #4

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

iD8DBQFAwkeXY5T wig3Ge+YRAkP4AK CBMD2lzYj9OQNt9 TXoFOx5zTvmRQCf XBtW
7ltzlTWOO3AYYAW EGT/IUZ8=
=Pk5J
-----END PGP SIGNATURE-----

Nov 23 '05 #5

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

Nov 23 '05 #6

zhicheng wang

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..."Pi ng"
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*******@postg resql.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

Nov 23 '05 #7

Martijn van Oosterhout

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.

Nov 23 '05 #8

zhicheng wang

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

Nov 23 '05 #9

Similar topics

1717

Temp tables represented in pg_class?

by: Jeff Boes | last post by:

Is there any way to distinguish temporary tables from "regular" ones by the contents of pg_class (or some other table of metadata)? (I'm using PG 7.3.4.) -- Jeff Boes vox 269.226.9550 ext 24 Database Engineer fax 269.349.9076 Nexcerpt, Inc. http://www.nexcerpt.com ...Nexcerpt... Extend your Expertise

PostgreSQL Database

2031

ERROR: fixrdesc: no pg_class entry for pg_class

by: Thomas Bamesberger | last post by:

Hi, yes i know, this question has already been asked and i found it in the archives, but i didnt find an answer for this problem, so maybe one of you can help me? My PostgreSQL Database has been up and running exactly for one year, but last week after rebooting the error message "fixrdesc: no pg_class entry for pg_class" appeared on the screen. So is there any way to solve this problem or to recover the data at least?

PostgreSQL Database

2850

SELECT 'pg_catalog.pg_class'::regclass::oid

by: Tom Hebbron | last post by:

Hi list, test=# SELECT 'pg_catalog.pg_class'::regclass::oid; oid ------ 1259 (1 row) test=# SELECT '1259'::oid::regclass; regclass

PostgreSQL Database

3499

grant not working on pg_class

by: Gregory Stone | last post by:

I've got a problem where any group or user permissions to the pg_class table aren't being registered by either psql or the JDBC driver. I issue the following command: GRANT ALL ON TABLE pg_class TO GROUP apps; -OR- GRANT ALL ON TABLE pg_class TO sculptor; Both apps and sculptor are valid user and group names respectively. The command executes fine and the following query produces:

PostgreSQL Database

3624

pg_class and relfilenode

by: muteki muteki | last post by:

Hi, I am currently having the corrupted tables issues described in the following link (possibly caused by power failure, which happens pretty often) http://archives.postgresql.org/pgsql-admin/2003-04/msg00012.php. Since we have our systems being deployed to numerous remote systems (psql 7.2.3), upgrading the entire database (with data migration) will be the least preferable solution. I am thinking of creating a script that

PostgreSQL Database

1816

reindexing, pg_class (and other system tables)

by: Sally Sally | last post by:

Very strange things are happening when I am reindexing a table. I did this with postmaster running as a standalone. The index for the table prior to reindexing is on a separate disk and I created a sym link (due to lack of space). When the reindexing is done I see new files created under /data/base/dbnumber/ but when I look at pg_class table it is pointing still to the old index because the oid I get is the older one. What does this mean?...

PostgreSQL Database

2548

oid file, but no pg_class row for it

by: Ed L. | last post by:

While dealing with filesystem bloat issues, I found a large file named 43710738, recently updated and sitting in one of my database directories, $ ls -lh ../../../data/base/11259315/43710738 -rw------- 1 dba dba 1016M Nov 3 17:05 ../../../data/base/11259315/43710738 .... with no corresponding entry that I can find in pg_class with that oid (I thought they were all in there). I tried dumping the database, knowing the...

PostgreSQL Database

2921

404 Not Found

by: NormD | last post by:

We have a client-server app using Web Services on an IIS machine. The trace below shows that .NET is searching around for some things (e.g., SystemDrawing.DLL and System.Drawing.EXE) and taking a LONG time to locate them. Time after time. The application DOES run, so it is ultimately finding what it needs. How can we tell "it" where these are located (should we even have to?) so it can look directly there instead of searching? ...

.NET Framework

4629

no matching symbolic information found

by: sora | last post by:

Hi, I've developed a MFC program under VS 6.0. My debugger *was* working fine and I've used it often for my project. Then, one day, the errors below appear and they prevent me from using the debugger. I know that I get these warnings because the OS symbols arn't installed (a few of them loaded fine). As far as I can remember, I didn't touch anything that should mess with the debugger so I don't know how to fix it and I need to be able to...

C / C++

8440

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

8780

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

8549

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

8636

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5661

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4192

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

4358

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

2005

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1763

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General