Tom Lane writes:
> Huh? If you zap the postmaster with kill -9, the last checkpoint record
> in the WAL log will not have the shutdown bit set.
It does here:
peter ~$ pg-install/bin/postmaster -D pg-install/var/data
DEBUG: database system was shut down at 2001-09-20 18:52:58 CEST
DEBUG: checkpoint record is at 0/146F54
DEBUG: redo record is at 0/146F54; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 136; next oid: 16579
DEBUG: database system is ready
Killed
peter ~$ pg-install/bin/postmaster -D pg-install/var/data
DEBUG: database system was interrupted at 2001-09-20 22:27:00 CEST
DEBUG: checkpoint record is at 0/146F54
DEBUG: redo record is at 0/146F54; undo record is at 0/0; shutdown TRUE
DEBUG: next transaction id: 136; next oid: 16579
DEBUG: database system was not properly shut down; automatic recovery in progress
DEBUG: ReadRecord: record with zero length at 0/146F94
DEBUG: redo is not required
DEBUG: database system is ready
--
Peter Eisentraut peter_e@gmx.net http://funkturm.homeip.net/~peter