ERROR: REINDEX DATABASE: Can be executed only on the currently open database.

Поиск
Список
Период
Сортировка
От Clodoaldo Pinto Neto
Тема ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
Дата
Msg-id 20040411230133.74986.qmail@web40901.mail.yahoo.com
обсуждение исходный текст
Ответы Re: ERROR: REINDEX DATABASE: Can be executed only on the currently open database.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
I suspect there is something wrong because it takes 73s to delete a single line
from a table whith 140 lines. So I tried to reindex the database:

bash-2.05b$ postgres -P -O -D /var/lib/pgsql/data KakaoStats
LOG:  database system was shut down at 2004-04-11 19:55:10 BRT
LOG:  checkpoint record is at 7/9505D650
LOG:  redo record is at 7/9505D650; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 24438; next oid: 1850892
LOG:  database system is ready

POSTGRES backend interactive interface
1.307.2.1 2003/01/01 21:57:18

backend> reindex database KakaoStats
ERROR:  REINDEX DATABASE: Can be executed only on the currently open database.
backend>


______________________________________________________________________

Yahoo! Messenger - Fale com seus amigos online. Instale agora!
http://br.download.yahoo.com/messenger/

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

Предыдущее
От: Alexander Cohen
Дата:
Сообщение: pg_ctl written in c
Следующее
От: Edmund Dengler
Дата:
Сообщение: REINDEX slow?