From: Jim Nasby <jnasby@pervasive.com>
To: arsi@aranzo.netg.se
To: pgsql-admin@postgresql.org
Subject: Re: Restoring database question, part 2..
Date: Wed, 16 Aug 2006 10:53:30 -0500
Message-ID: <4D27CB1096EF1C408F4BFAB0046EC7B667D930@ausmailid.aus.pervasive.com> (raw)
References: <Pine.LNX.4.62.0608121331510.473@aranzo.netg.se>
<Pine.LNX.4.62.0608121958150.948@aranzo.netg.se>
<Pine.LNX.4.62.0608151712420.11395@aranzo.netg.se>
<20060815213108.GM21363@pervasive.com>
<Pine.LNX.4.62.0608161534360.14184@aranzo.netg.se>
Please cc the list so others can help.
Yes, those tables are per-database.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
-----Original Message-----
From: arsi@aranzo.netg.se [mailto:arsi@aranzo.netg.se]
Sent: Wed 8/16/2006 8:42 AM
To: Jim Nasby
Subject: Re: [ADMIN] Restoring database question, part 2..
Hi there,
one question to your response, are all the tables (especially the pg_*
ones) located under the data/base folder for each database??
I will try your suggestion. I am switching between my "not working"
database and the one that was installed when I had to reinstall my Linux.
Thanks for the answer,
Archie
> On Tue, Aug 15, 2006 at 05:25:38PM +0200, arsi@aranzo.netg.se wrote:
>>
>> 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.
>
> It sounds like you didn't get all the tables. If you do a SELECT
> relfilenode FROM pg_class WHERE relname='pg_inherits' on another 7.4
> database (I don't have one handy), you'll see what the filename should
> be so you can look for it.
>
> If you haven't done many DDL changes since the last backup, you could
> possibly restore an old copy and use that info to reconstruct
> pg_inherits.
> --
> Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
> Pervasive Software http://pervasive.com work: 512-231-6117
> vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: jnasby@pervasive.com, arsi@aranzo.netg.se
Subject: Re: Restoring database question, part 2..
In-Reply-To: <4D27CB1096EF1C408F4BFAB0046EC7B667D930@ausmailid.aus.pervasive.com>
References: <Pine.LNX.4.62.0608121331510.473@aranzo.netg.se> <Pine.LNX.4.62.0608121958150.948@aranzo.netg.se> <Pine.LNX.4.62.0608151712420.11395@aranzo.netg.se> <20060815213108.GM21363@pervasive.com> <Pine.LNX.4.62.0608161534360.14184@aranzo.netg.se> <4D27CB1096EF1C408F4BFAB0046EC7B667D930@ausmailid.aus.pervasive.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox