Postgres

From: Guru Prasad <pnguruji(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Postgres
Date: 2001-06-16 05:40:54
Message-ID: Pine.LNX.4.20.0106161049490.21517-100000@Larry.bks
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql


Hi to list,

I had my database installed in my Slackware 7.0 (kernel 2.2.6). I was
using postgres 7.1 version. Now the database got corrupted. I had no clue
how it got corrupted. Basically, i did found that the data of various
users existing (in /usr/local/pgsql/data directory). But there were no
data existing in the following system catalogs.

pg_database. (except template0 & template1)
pg_shadow. (except postgres user. Previously 15 users were there.)
pg_tables. (Not showing any user created tables. Only system tables
get displayed).

But the data structure of individual tables exist somewhere. Suppose if i
do 'select * from tablename' then field names gets displayed but says 'no
rows'. At the same time, i am unable to get the structure through
\d tablename.

Is it possible to recover the data in any way. I am having a old dump of
data which i can use to reinstall but i wanted to know how it happened in
the first place. Atleast, i can take some steps so that it doesn't happen
again.

Could some one there help me out to recover the data.
Any help would be appreciated.

Regards,
Guru Prasad

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jarmo Paavilainen 2001-06-16 07:56:39 UNIQUE INDEX unaware of transactions (a spin of question)
Previous Message Manuel Sugawara 2001-06-16 04:52:22 Re: postgres dies while doing vacuum analyze

Browse pgsql-sql by date

  From Date Subject
Next Message Postgresql 2001-06-16 12:56:17 calling user defined function with parameters..
Previous Message Craig Longman 2001-06-16 05:07:29 casts and conversions