From: | arsi(at)aranzo(dot)netg(dot)se |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Restoring database question, part 2.. |
Date: | 2006-08-15 15:25:38 |
Message-ID: | Pine.LNX.4.62.0608151712420.11395@aranzo.netg.se |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Gregory Stark | 2006-08-15 17:27:26 | dropping partitioned table waits forever |
Previous Message | lst_hoe01 | 2006-08-15 15:18:42 | Re: Unsubscribe |