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

One more thing...

The vacuum command is giving the same error:

[root@s1 data]# vacuumdb -v -U postgres dans_pgsql
Password:
Asql: FATAL 1:  cannot find attribute 24 of relation
vacuumdb: vacuum  dans_pgsql failed

Is there another way to fix a corrupt database (assuming that is what the
problem here is)?

Thanks,
Tauren


> -----Original Message-----
> From: Tauren Mills [mailto:tauren@servlets.net]
> Sent: Friday, September 14, 2001 8:23 AM
> To: pgsql-admin@postgresql.org
> Subject: Problem with database: FATAL 1: cannot find attribute 24 of
> relation
>
>
> Help!
>
> One of my customers is having a problem with their database causing all of
> their sites to be down right now.  The problem seems to effect only their
> database, not any other databases on the server.  Here is the output when
> connecting to it:
>
> [root@s1 data]# psql -U postgres dans_pgsql
> Password:
> Asql: FATAL 1:  cannot find attribute 24 of relation
>
> I've searched the email archives as well as deja.com, but cannot find this
> error message mentioned anywhere.  Does anyone know what it means?  I've
> tried restarting postgres.  Can anyone help suggest what I can do to get
> this database working again?
>
> I have backups of all raw files on the server, but the customer
> has not done
> a dump of their database recently.  I rather doubt that restoring their
> database from tape would replace it in a consistent state.  Any
> thoughts on
> this as well?
>
> Thanks,
> Tauren
>
>
>