Thread: postgres 7.2.4 - errors after vacuuming/reindexing in single user mode

postgres 7.2.4 - errors after vacuuming/reindexing in single user mode

From
"Warren White"
Date:

We have a 7.2.4 postgres database that was bloated.  We went into postgres single user mode to

Vacuum and reindex the database. (postgres -0 –P)  We reindexed a number of indices explicitly.

We now cannot use the database, and are getting e.g.

ERROR: Relation 9262944 does not exist

 

What can we do to recover?  What happened, and what did we do wrong?

 

Thanks in advance,

 

 

Warren

 

Warren White

CTAC Engineer III

email: warren.white@edial.com

phone: 781.895.3611

cell:  781.738.3416

msn: warren.white@edial.com

 

eDial - a division of ALCATEL

266 2nd Avenue

Waltham, MA  02451