help: production db stuck in startup mode - Mailing list pgsql-general

From Ed L.
Subject help: production db stuck in startup mode
Date
Msg-id 200507201313.07635.pgsql@bluepolka.net
Whole thread Raw
Responses Re: help: production db stuck in startup mode
List 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 by date:

Previous
From: Dan Armbrust
Date:
Subject: Re: index row size exceeds btree maximum, 2713 - Solutions?
Next
From: "Ed L."
Date:
Subject: Re: help: production db stuck in startup mode