I am running postgres postgres version 8.3 on OS X. The data directory is on network volume. The network volume was disconnected and server crashed. Log reported that last know up was 9:30 pm (about 30 min prior to the server crash.) My conf Checkpoint_Segments setting = 3 (not sure if this is all helpful info) When postgres try to recover from the crash the volume was still not mounted. Once storage volume is re-connected: There were index corruptions. I fixed all that with single user mode. There were also some missing record... I understand that some updates were lost because they 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.
- Re: [GENERAL] Why facebook used m... Dave Page
- Re: [GENERAL] Why facebook used m... Scott Marlowe
- Re: [GENERAL] Why facebook used m... David Boreham
- Re: [GENERAL] Why facebook used m... Tom Lane
- Re: [GENERAL] Why facebook used m... Fredric Fredricson
- Re: [GENERAL] Why facebook used m... David Boreham
- Re: [GENERAL] Why facebook used mysql ? Chris Browne
- Re: [GENERAL] Why facebook used mysql ? Lincoln Yeoh
- Re: [GENERAL] Why facebook used mysql ? Ron Mayer
- Re: [GENERAL] Why facebook used mysql ? r t
- [GENERAL] when postgres failed to recover ... anypossibility
- Re: [GENERAL] when postgres failed to ... Craig Ringer
- Re: [GENERAL] when postgres faile... Gabriele Bartolini
- Re: [GENERAL] when postgres faile... anypossibility
- Re: [GENERAL] when postgres faile... Craig Ringer
- Re: [GENERAL] Why facebook used mysql ? Sandeep Srinivasa
- Re: [GENERAL] Why facebook used mysql ? David Boreham
- Re: [GENERAL] Why facebook used mysql ? Sandeep Srinivasa
- Re: [GENERAL] Why facebook used mysql ? David Boreham
- Re: [GENERAL] Why facebook used mysql ... Scott Marlowe
- Re: [GENERAL] Why facebook used m... David Boreham