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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
