Re: could not open relation

From: Octavio Alvarez Piza <alvarezp(at)alvarezp(dot)ods(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: could not open relation
Date: 2004-05-22 18:32:14
Message-ID: 2624.63.84.67.25.1085250734.squirrel@alvarezp.ods.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, everybody!

I already solved it. Thank you.

First of, I forgot to mention the version(), so FYI, 7.4.1.

I followed Tom's advice in
http://archives.postgresql.org/pgsql-general/2004-03/msg01073.php

I shut down the PG instance.
postgres -D $PG_DATA -O -P $DBNAME
=# REINDEX DATABASE tbc_gamma
<EOF>

-P was necessary for the standalone backend to ignore the (damaged) indexes.

Done.

Hope this helps someone else someday.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message David Garamond 2004-05-22 19:44:31 how many record versions
Previous Message Vamsikrishna Mudrageda 2004-05-22 16:42:53 DB design opinions - Foreign Key usage