From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Tauren Mills <tauren(at)servlets(dot)net> |
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 04:07:09 |
Message-ID: | 20010917140709.A22462@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 | Charles Tassell | 2001-09-17 04:47:45 | Re: [HACKERS] Where do they find the time??? Great |
Previous Message | Justin Clift | 2001-09-17 03:25:12 | Re: [HACKERS] Where do they find the time??? Great Bridge |