Re: Problem with database: FATAL 1: cannot find attribute 24

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@svana.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@svana.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.
>