Re: could not open relation

Поиск
Список
Период
Сортировка
От Octavio Alvarez Piza
Тема Re: could not open relation
Дата
Msg-id 2624.63.84.67.25.1085250734.squirrel@alvarezp.ods.org
обсуждение исходный текст
Ответ на could not open relation "pg_trigger_tgrelid_tgname_index"  (Octavio Alvarez Piza <alvarezp@alvarezp.ods.org>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Lincoln Yeoh
Дата:
Сообщение: Re: Am I locking more than I need to?
Следующее
От: David Garamond
Дата:
Сообщение: how many record versions