Please cc the list so others can help. Yes, those tables are per-database. -- Jim C. Nasby, Sr. Engineering Consultant jnasby@xxxxxxxxxxxxx Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 -----Original Message----- From: arsi@xxxxxxxxxxxxxx [mailto:arsi@xxxxxxxxxxxxxx] 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@xxxxxxxxxxxxxx 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@xxxxxxxxxxxxx > Pervasive Software http://pervasive.com work: 512-231-6117 > vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461 >
