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 EDT
FATAL: the database system is starting up
LOG: checkpoint record is at 1C/2A4CF040
LOG: redo record is at 1C/2A4CF040; undo record is at 0/0; shutdown FALSE
LOG: next transaction ID: 16776013; next OID: 3686077
LOG: database system was not properly shut down; automatic recovery in progress
LOG: redo starts at 1C/2A4CF080
LOG: record with zero length at 1C/2A521034
LOG: redo done at 1C/2A521010
FATAL: the database system is starting up
FATAL: the database system is starting up
LOG: 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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
