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