Restoring database question, part 2..

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

In response to

Responses

Browse pgsql-admin by date

  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