Sorry for cross-posting this to both admin and general. I first posted to
admin, but as I'm desperate here and there is more activity in the general
list, I'm now posting it here as well.
---
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?
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