Received: from web13907.mail.yahoo.com (web13907.mail.yahoo.com [216.136.175.70]) by postgresql.org (8.11.3/8.11.4) with SMTP id fBC7cjm01451 for ; Wed, 12 Dec 2001 02:38:45 -0500 (EST) (envelope-from antop64@yahoo.com) Message-ID: <20011212073845.67992.qmail@web13907.mail.yahoo.com> Received: from [203.151.189.2] by web13907.mail.yahoo.com via HTTP; Tue, 11 Dec 2001 23:38:45 PST Date: Tue, 11 Dec 2001 23:38:45 -0800 (PST) From: Anto Prijosoesilo Subject: Corrupted DB. Help. To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Archive-Number: 200112/84 X-Sequence-Number: 2807 Hi, One of my databases was running on PostgreSQL 6.5.1 and I accidentally corrupted the pg_class file. After I restored the file from a backup, postgres would come up but I can't see my tables. Only the system tables are visible and trying to SELECT * FROM mytable returned 0 rows. SELECT * FROM pg_class only shows the system tables, but VACUUM would go through all the tables. pg_class' entry in pg_class table shows that it has 95 tuples but only 47 of them are listed when I do SELECT * FROM pg_class. Can someone help me recover my tables? Thanks. __________________________________________________ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com