Postgresql Hackers,
Just a quick but heartfelt "Thank You!" to all of you who make
postgresql as sturdy as it is. Noon today, our datacenter provider
suffered an, um, interruption in their uninterruptable redundant power
supply systems. Power was restored seconds later, and this is what the
postmaster had to say about it:
LOG: database system was interrupted at 2004-10-08 11:55:47 EDTFATAL: the database system is starting upLOG:
checkpointrecord is at 1C/2A4CF040LOG: redo record is at 1C/2A4CF040; undo record is at 0/0; shutdown
FALSELOG: next transaction ID: 16776013; next OID: 3686077LOG: database system was not properly shut down; automatic
recovery
in progressLOG: redo starts at 1C/2A4CF080LOG: record with zero length at 1C/2A521034LOG: redo done at
1C/2A521010FATAL: the database system is starting upFATAL: the database system is starting upLOG: database system is
ready
We were back online within minutes of the interruption w/o any data
loss.
So, I raise my glass to you! Thank you!
----
James Robinson
Socialserve.com