From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Joel Burton <jburton(at)scw(dot)org> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: pg_inherits: not found, but visible |
Date: | 2001-03-21 00:38:22 |
Message-ID: | 3AB7F7FE.20D4E463@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2001-03-21 00:40:49 | Re: Beta 6 Regression results on Redat 7.0. |
Previous Message | Tom Lane | 2001-03-21 00:32:56 | Re: pg_inherits: not found, but visible |