help: production db stuck in startup mode

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: help: production db stuck in startup mode
Date: 2005-07-20 19:13:07
Message-ID: 200507201313.07635.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2005-07-20 19:19:28 Re: help: production db stuck in startup mode
Previous Message Dan Armbrust 2005-07-20 18:31:00 Re: index row size exceeds btree maximum, 2713 - Solutions?