By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,512 Members | 747 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,512 IT Pros & Developers. It's quick & easy.

ERROR: fixrdesc: no pg_class entry for pg_class

P: n/a
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
Share this Question
Share on Google+
1 Reply

P: n/a
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.