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