xlog flush request not satisfied after server reboot

Hackers,

I had a server reboot for an unknown reason, after the server restarted one
of the disks was not mounted before Postgresql tried to start. The startup
failed (see log below), after I mounted the disks and tried to start
Postgresql again there was a HINT about corrupted data and a WARNING about
invalid page headers. The warning didn't tell me which database had the
invalid page, so I decided to vacuum full all of the databases to see if I
received an error which I did (see below). The database with the error is
the largest ~300GB, I do have a backup if necessary, is there away to
recover without doing a restore?

Thanks for your help

Jim

startup with tablespace not mounted

----------------------------------------------------------------------------
-----------------------------

LOG: database system was interrupted at 2006-12-14 19:51:26 EST

LOG: checkpoint record is at 1F1/52C8A704

LOG: redo record is at 1F1/5291F0A0; undo record is at 0/0; shutdown FALSE

LOG: next transaction ID: 13019683; next OID: 4167831

LOG: next MultiXactId: 1; next MultiXactOffset: 0

LOG: database system was not properly shut down; automatic recovery in
progress

LOG: redo starts at 1F1/5291F0A0

PANIC: could not create directory "pg_tblspc/3717272": File exists

LOG: startup process (PID 4987) was terminated by signal 6

LOG: aborting startup due to startup process failure

LOG: logger shutting down

startup after tablespace was mounted

----------------------------------------------------------------------------
-----------------------------

LOG: database system was interrupted while in recovery at 2006-12-15
08:04:48 E

ST

HINT: This probably means that some data is corrupted and you will have to
use

the last backup for recovery.

LOG: checkpoint record is at 1F1/52C8A704

LOG: redo record is at 1F1/5291F0A0; undo record is at 0/0; shutdown FALSE

LOG: next transaction ID: 13019683; next OID: 4167831

LOG: next MultiXactId: 1; next MultiXactOffset: 0

LOG: database system was not properly shut down; automatic recovery in
progress

LOG: redo starts at 1F1/5291F0A0

WARNING: invalid page header in block 6196744 of relation "4158697";
zeroing ou

t page

LOG: connection received: host=s20a.contactbda.com port=1667

FATAL: the database system is starting up

WARNING: invalid page header in block 6196934 of relation "4158697";
zeroing ou

t page

LOG: record with zero length at 1F1/572B792C

LOG: redo done at 1F1/572B5BD0

LOG: database system is ready

Error message from vacuum

----------------------------------------------------------------------------
------------------------

ERROR: xlog flush request 1F6/3A0F605C is not satisfied --- flushed only to
1F1

/57CD76FC

CONTEXT: writing block 3387032 of relation 3717272/4158444/4158627

_____________________________________________
Jim Buttafuoco

Contact Telecom LLC

Office: 603-647-7170

Fax: 603-606-4243

Cell: 603-490-3409