Restoring database question, part 2..
От | arsi@aranzo.netg.se |
---|---|
Тема | Restoring database question, part 2.. |
Дата | |
Msg-id | Pine.LNX.4.62.0608151712420.11395@aranzo.netg.se обсуждение исходный текст |
Ответ на | Restoring database question.. (arsi@aranzo.netg.se) |
Ответы |
Re: Restoring database question, part 2..
|
Список | pgsql-admin |
Hi all, this is a follow question to my other question about moving the data folder (that holds all databases) as a method to restore the databases after my server was hacked and everything removed. After having read the manual, recieved some helpfuls responses I have carefully stopped the database, moved the newly installed data folder (under /var/lib/postgres) and copied over the old (before the hacking attempt) data folder. The database starts and I can select from the tables but I can't do \d <table> or dump the database. The error message is as follows: ERROR: could not open relation "pg_inherits": No such file or directory From what I can read about the pg_inherits (and other pg_* tables) is that it is a table that contains info about the tables in my database. What I can't find is where these should be located. Any help would be grateful. Thanks, Archie
В списке pgsql-admin по дате отправления: