help: production db stuck in startup mode

Поиск
Список
Период
Сортировка
От Ed L.
Тема help: production db stuck in startup mode
Дата
Msg-id 200507201313.07635.pgsql@bluepolka.net
обсуждение исходный текст
Ответы Re: help: production db stuck in startup mode  ("Ed L." <pgsql@bluepolka.net>)
Список pgsql-general
I have a 7.4.6 db running on itanium hpux 11.23.  It appears a
vacuum ran out of disk space,

2005-07-20 13:47:43 [6161]   ERROR:  DBI::do failed for SQL
[VACUUM VERBOSE] to database clincomm:  DBI error:  PANIC:
could not write to file
"/users/postgresql-7.4.6/data/pg_xlog/xlogtemp.6178": No space
left on device

Pgsql was unresponsive, so we sent SIGINT, then SIGQUIT, both
with no response, so finally, sent SIGKILL, then used ipcrm to
clear the shm and semaphores.  Then restarted, but upon restart,
it's stuck in "FATAL:  the database system is starting up" mode.

Any clues???

Thanks,
Ed

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

Предыдущее
От: Dan Armbrust
Дата:
Сообщение: Re: index row size exceeds btree maximum, 2713 - Solutions?
Следующее
От: "Ed L."
Дата:
Сообщение: Re: help: production db stuck in startup mode