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
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 |
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 |