Thread: Problems with my server...
Hi, there !! I've got a problem in my PostgreSQL server. Anytime I issue some commands (like vacuum...) I got the following message: prescricoes=> vacuum; ERROR: cannot find attribute 3 of relation pg_views prescricoes=> what can be wrong ?? I think that all my data is there and I have no views defined, so I really don't know what's going on... Can someone help me?? Thank you for your support, Paulo Ferreira
"Paulo Jorge Gomes Ferreira" <paulojf@srsleiria.min-saude.pt> writes: > I've got a problem in my PostgreSQL server. Anytime I issue some commands > (like vacuum...) I got the following message: > prescricoes=> vacuum; > ERROR: cannot find attribute 3 of relation pg_views What Postgres version are you running? (I suspect it must be pre-7.1.) It would seem that something bad has happened to some rows in pg_attribute. You might possibly be able to recover by reindexing pg_attribute, but I'm not sure that REINDEX exists or is trustworthy in whatever version you have. Probably the best advice is to try to pg_dump your database, and if that's successful re-initdb and reload. (You'd be well advised to update to 7.1.3 while you're at it.) regards, tom lane