Postgres
От | Guru Prasad |
---|---|
Тема | Postgres |
Дата | |
Msg-id | Pine.LNX.4.20.0106161049490.21517-100000@Larry.bks обсуждение исходный текст |
Ответы |
Re: Postgres
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: