From: | Alfred Perlstein <bright(at)wintelcom(dot)net> |
---|---|
To: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: yowch: dumpRules(): SELECT failed for table website. |
Date: | 2000-05-24 10:00:00 |
Message-ID: | 20000524025959.T28097@fw.wintelcom.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
* Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> [000524 02:58] wrote:
> > -----Original Message-----
> > From: Alfred Perlstein [mailto:bright(at)wintelcom(dot)net]
> >
> > * Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> [000524 02:40] wrote:
> > > > -----Original Message-----
> > > > From: pgsql-hackers-owner(at)hub(dot)org
> > [mailto:pgsql-hackers-owner(at)hub(dot)org]On
> > > > Behalf Of Alfred Perlstein
> > > >
> > > > while doing a pg_dump of a table after postgresql made a mess
> > of itself:
> > > >
> > > > dumpRules(): SELECT failed for table website. Explanation from
> > > > backend: 'ERROR: cache lookup of attribute 1 in relation
> > 9892634 failed
> > > > '.
> > > >
> > > > Guys, there has to be a simple command to fix a corrupted database.
> > > >
> > > > I'm really killing myself over here trying to mix REINDEX, VACUUM
> > > > along with creating temp tables and reinserting the data
> > which gives me:
> > > >
> > >
> > > How did you issue REINDEX command ?
> >
> > postmaster -p 1080 -o "-O -P"
> > was run
> > then:
> >
> > psql -p 1080 webcounter
> > REINDEX DATABASE webcounter force;
> >
>
> Hmm,shutdown postmaster and invoke standalone postgres.
>
> postgres -O -P webmaster
> REINDEX DATABASE webcounter force;
> ^D
gah!
~/scripts % postgres -O -P webmaster
DEBUG: Data Base System is starting up at Wed May 24 02:24:49 2000
DEBUG: Data Base System was shut down at Wed May 24 02:24:46 2000
DEBUG: Data Base System is in production state at Wed May 24 02:24:49 2000
FATAL 1: Database "webmaster" does not exist in the system catalog.
FATAL 1: Database "webmaster" does not exist in the system catalog.
not good :(
--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."
From | Date | Subject | |
---|---|---|---|
Next Message | Alfred Perlstein | 2000-05-24 10:10:06 | Re: Re: yowch: dumpRules(): SELECT failed for table website. |
Previous Message | Nishad PRAKASH | 2000-05-24 09:49:22 | \dS and \df <pattern> crashing psql |