| 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: | Whole Thread | Raw Message | 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 |