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

From: "Warren White" <warren(dot)white(at)wlm(dot)edial(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: postgres 7.2.4 - errors after vacuuming/reindexing in single user mode
Date: 2005-07-26 21:48:16
Message-ID: 44F448E64E12BC4CB71D4DF5B4C0FCDD6F526C@exchange2003.edial.office
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)white(at)edial(dot)com

phone: 781.895.3611

cell: 781.738.3416

msn: warren(dot)white(at)edial(dot)com

eDial <http://www.edial.com/> - a division of ALCATEL
<http://www.alcatel.com/>

266 2nd Avenue

Waltham, MA 02451

Browse pgsql-general by date

  From Date Subject
Next Message Randall Perry 2005-07-26 21:53:35 Rules vs Triggers
Previous Message Scott Marlowe 2005-07-26 21:44:02 Re: back-end triggers front-end to update