Re: [HACKERS] pg_inherits: not found, but visible

[Hiroshi Inoue]

Joel Burton wrote: > > On Wed, 21 Mar 2001, Hiroshi Inoue wrote: > > > Joel Burton wrote: > > > > > > Postmaster crashed on me, and on restart, pg_inherits cannot be found. > > > I can see it in pg_class (and it shows up w/ \dS), but any attempt to > > > modify anything fails with "pg_inherits: No such file or directory". > > > > > > I've reindexed the database (w/postgres -P -O). Vacuuming fails (w/error > > > above). > > > > > > What could this be? Is there any hope? > > > > > > > Try the following queries. > > 1) select oid from pg_database where datname = your_db_name; > > 2) select oid, relfilenode from pg_class where relname = 'pg_inherits'; > > > > For example I get the followings in my environment. > > 1) oid = 18720 > > 2) relfilenode(==oid) = 16567; > > > > and I could find a $PGDATA/base/18720/16567 file. > > Could you find such a file ? > > No. I do have the db directory, and all of the other file for the existing > classes, but not this. > Just a confirmation. What is a result of the second query in your current environment ? > Any ideas why this would disappear? I have no idea but this is really a disastrous phenomenon. > Or any ideas about how to get my > existing data out? (I have a dump from about 36 hours ago; it would be > nice to extract some more recent data!) > Are you using inheritance ? regards, Hiroshi Inoue ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly