470,614 Members | 1,447 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,614 developers. It's quick & easy.

ERROR: fixrdesc: no pg_class entry for pg_class

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?

Info: PGSQL 7.2 on Midori Linux, booting from CF with database data
stored on the harddisk.

Thx in advance

--
Thomas Bamesberger <ba***@bms-austria.com>
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Nov 11 '05 #1
1 1905
Thomas Bamesberger <ba***@bms-austria.com> writes:
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?


Ouch. You have a problem :-(

Are you seeing this failure when you connect to any database in the
cluster, or just one? If the former, I'd guess that you've been
ignoring messages about needing a cluster-wide VACUUM for a little too
long, and you're now hosed due to transaction wraparound. If the
latter, it's probably localized data corruption in that database's
system catalog. Which is not necessarily any better news, but there
are a couple of desperation measures you can try:

1. Remove the "pg_internal.init" file in the broken database, then see
if you can start a backend.

2. Try to start a standalone backend and reindex the system catalogs.
(See the REINDEX man page for details on this rather arcane procedure.)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by Dave Smith | last post: by
3 posts views Thread by muteki muteki | last post: by
8 posts views Thread by zhicheng wang | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.