| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Shutdown TRUE? |
| Date: | 2001-09-20 23:28:01 |
| Message-ID: | Pine.LNX.4.30.0109210126370.684-100000@peter.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net http://funkturm.homeip.net/~peter
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-09-21 00:00:08 | Re: Shutdown TRUE? |
| Previous Message | Tom Lane | 2001-09-20 23:26:57 | Re: Shutdown TRUE? |