pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Anto Prijosoesilo <antop64@yahoo.com>
To: pgsql-admin@postgresql.org
Subject: Corrupted DB. Help.
Date: Tue, 11 Dec 2001 23:38:45 -0800 (PST)
Message-ID: <20011212073845.67992.qmail@web13907.mail.yahoo.com> (raw)

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



view thread (3+ messages)  latest in thread

Message-ID: <20011212073845.67992.qmail@web13907.mail.yahoo.com>
Permalink:  ../20011212073845.67992.qmail@web13907.mail.yahoo.com/
Also on:    postgresql.org/message-id/20011212073845.67992.qmail@web13907.mail.yahoo.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: antop64@yahoo.com
  Subject: Re: Corrupted DB. Help.
  In-Reply-To: <20011212073845.67992.qmail@web13907.mail.yahoo.com>
  References: <20011212073845.67992.qmail@web13907.mail.yahoo.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox