Re: Shutdown TRUE? - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Shutdown TRUE?
Date
Msg-id Pine.LNX.4.30.0109210126370.684-100000@peter.localdomain
Whole thread Raw
In response to Re: Shutdown TRUE?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Shutdown TRUE?
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: "Gowey, Geoffrey"
Date:
Subject: Changing columns
Next
From: Tom Lane
Date:
Subject: Re: Shutdown TRUE?