I am running postgres and data directory is on network volume.
postgres version 8.3
Server Crashed: 10:00 pm
Last known up: 9:30 pm (from log)
Checkpoint_Segments setting = 3 (conf)
When postgres try to recover from the crash it has no access to storage.
Once storage volume is re-connected:
There were index corruptions
Also some missing data... All records seems to be updated before/after Last 
know up (9:30).
I understand that some updates were in cache and haven't been written to the 
disk yet hence updates are lost.
However, it seems that record that were created long time ago (but updated 
before the crash occurs) is completely missing (unable to find even after 
reindex is done).
Does this make sense? or Is this impossible and record might be somewhere on 
the disk? 
Thank you very much for your time in advance.






Reply via email to