Re: Shutdown TRUE?

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