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

Thanks for the assistance!  Unfortunately, I still can't get in the way you
suggest.  I wasn't able to start postgres by simply typing "postgres
[dbname]", but here is what I did do.  First, I stop PostgreSQL (installed
from an RPM):

[root@s1 init.d]# /etc/rc.d/init.d/postgresql stop
$Stoping postgresql service:                              [  OK  ]

Then, I su to the postgres user:

[root@s1 init.d]# su - postgres

Then, I try running postgres like this:

bash$ postgres -d 5 -D /var/lib/pgsql/data dans_pgsql
invoking IpcMemoryCreate(size=1015808)
DEBUG:  database system was shut down at 2001-09-17 11:22:37 PDT
DEBUG:  CheckPoint record at (0, 305239168)
DEBUG:  Redo record at (0, 305239168); Undo record at (0, 0); Shutdown TRUE
DEBUG:  NextTransactionId: 3285885; NextOid: 498209
DEBUG:  database system is in production state
FindExec: searching PATH ...
ValidateBinary: can't stat "/bin/postgres"
FindExec: found "/usr/bin/postgres" using PATH
DEBUG:  connection: host=(null) user=postgres database=dans_pgsql
DEBUG:  InitPostgres
AATAL 1:  cannot find attribute 24 of relation
DEBUG:  proc_exit(1)
DEBUG:  shmem_exit(1)
DEBUG:  shutting down
DEBUG:  database system is shut down
DEBUG:  exit(1)
bash$ exit

Any more suggetions?

Thanks again!
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.
>