From: | "Tauren Mills" <tauren(at)servlets(dot)net> |
---|---|
To: | "Martijn van Oosterhout" <kleptog(at)svana(dot)org> |
Cc: | "Justin Clift" <justin(at)postgresql(dot)org>, "PostgreSQL General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Problem with database: FATAL 1: cannot find attribute 24 |
Date: | 2001-09-17 18:36:31 |
Message-ID: | NBBBLBKDJMGDNPMDGAABIEPNBOAB.tauren@servlets.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
One more thing...
I'm running version 7.1.2 installed from RPM on a Red Hat 6.2 server.
Tauren
> -----Original Message-----
> From: Martijn van Oosterhout [mailto:kleptog(at)svana(dot)org]
> Sent: Sunday, September 16, 2001 9:07 PM
> To: Tauren Mills
> Cc: Justin Clift; PostgreSQL General Mailing List
> Subject: Re: [GENERAL] Problem with database: FATAL 1: cannot find
> attribute 24
>
>
> On Sun, Sep 16, 2001 at 08:23:57PM -0700, Tauren Mills wrote:
> > We are getting this error message whenever we try to connect
> using psql, the
> > \c command in psql, the pg_dump command, the vacuum command, or the JDBC
> > driver:
> >
> > FATAL 1: cannot find attribute 24 of relation ^MA
>
> Looks like corruption.
>
> An idea. Kill off the postmaster, then start postgres directly from the
> command line (I beleive it's just ./postgres [dbname]). That
> should get you
> in because i think it's one of the queries psql sends on startup
> that fouls
> up.
>
> Anyway, once you have a prompt, type:
>
> select * from pg_class;
>
> and
>
> select * from pg_attribute where attnum = 24;
>
> Look for corruption and other strange data.
>
> HTH,
> --
> Martijn van Oosterhout <kleptog(at)svana(dot)org>
> http://svana.org/kleptog/
> > Magnetism, electricity and motion are like a three-for-two
> special offer:
> > if you have two of them, the third one comes free.
>
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-09-17 19:07:36 | Re: [GENERAL] pg_dump error - LOCALIZATION PROBLEM |
Previous Message | Tauren Mills | 2001-09-17 18:34:22 | Re: Problem with database: FATAL 1: cannot find attribute 24 |