Warren Guy wrote:
Hi everyone
Was running a VACUUM on a database on a partition which was running out
of disk space. During VACUUM the server process died and failed to restart.
Running PostgreSQL 8.1.4
...
Jan 11 15:02:39 marshall postgres[73909]: [5-1] FATAL: the database
system is starting up
Jan 11 15:02:40 marshall postgres[73888]: [12-1] PANIC: block 463 unfound
Jan 11 15:02:41 marshall postgres[67977]: [5-1] LOG: startup process
(PID 73888) was terminated by signal 6
Jan 11 15:02:41 marshall postgres[67977]: [6-1] LOG: aborting startup
due to startup process failure
You say "was running out of disk space" - does that mean it did run out
of disk space? I don't see the error that caused this, just the results.
That would suggest to me that something unusual caused this (or you
clipped the log fragment too far down :-)
In any case, the first thing I'd try is to make your on-disk backups and
set it up as though it's PITR recovery you're doing. That way you can
stop the recovery before block 463 causes the failure. Oh, assuming
you've got the space you need on your partition of course.
HTH
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
