pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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
>




view thread (3+ messages)

Message-ID: <4D27CB1096EF1C408F4BFAB0046EC7B667D930@ausmailid.aus.pervasive.com>
Permalink:  ../4D27CB1096EF1C408F4BFAB0046EC7B667D930@ausmailid.aus.pervasive.com/
Also on:    postgresql.org/message-id/4D27CB1096EF1C408F4BFAB0046EC7B667D930@ausmailid.aus.pervasive.com

 · 

reply

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