Home > mailing lists

postgres 7.2.4 - errors after vacuuming/reindexing in single user mode - Mailing list pgsql-general

From	Warren White
Subject	postgres 7.2.4 - errors after vacuuming/reindexing in single user mode
Date	July 27, 2005 13:34:39
Msg-id	44F448E64E12BC4CB71D4DF5B4C0FCDD6F526C@exchange2003.edial.office Whole thread Raw
List	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

phone: 781.895.3611

cell: 781.738.3416

msn: warren.white@edial.com

eDial - a division of ALCATEL

266 2nd Avenue

Waltham, MA 02451

From: "DracKewl"
Date: 27 July 2005, 13:34:35
Subject: Cursor Issue??

From: "Ben Trewern"
Date: 27 July 2005, 13:34:40
Subject: Re: PostgreSQL, Lazarus and zeos ?