Skip site navigation (1) Skip section navigation (2)

Re: Postmaster startup messages

From: "Simon Riggs" <simon(at)2ndquadrant(dot)com>
To: "Peter Eisentraut" <peter_e(at)gmx(dot)net>
Cc: <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Postmaster startup messages
Date: 2007-06-01 08:06:17
Message-ID: 1180685178.26297.54.camel@silverbirch.site (view raw or flat)
Thread:
Lists: pgsql-hackers
On Wed, 2007-05-30 at 17:57 +0200, Peter Eisentraut wrote:
> Does anyone actually read these?
> 
> LOG:  database system was shut down at 2007-05-30 17:54:39 CEST
> LOG:  checkpoint record is at 0/42C4FC
> LOG:  redo record is at 0/42C4FC; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 0/593; next OID: 10820
> LOG:  next MultiXactId: 1; next MultiXactOffset: 0
> LOG:  database system is ready
> 
> Why not just:
> 
> LOG:  database system is ready
> 
> If people are worried that the startup might take longer, then maybe add
> 
> LOG:  database system is starting
> 
> before that.
> 
> Comments?

I understand the thought, but don't think that is a good idea.

Recovery considerations mean there can be more than one copy of a
database and it is important to be able to tell which one was just
started. The time a database was shutdown defines which copy we are
looking at. Debugging recovery is hard enough already, so please don't
remove this information.

Also, the startup signature would not be verbose enough to catch your
eye as you look through the log. If you want to change this, we should
have some additional eyecatcher text in there, e.g. ==============...

These lines don't have much meaning for me and could be DEBUG1:

> LOG:  redo record is at 0/42C4FC; undo record is at 0/0; shutdown TRUE
> LOG:  next transaction ID: 0/593; next OID: 10820
> LOG:  next MultiXactId: 1; next MultiXactOffset: 0

-- 
  Simon Riggs             
  EnterpriseDB   http://www.enterprisedb.com



In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2007-06-01 08:33:28
Subject: Re: Postmaster startup messages
Previous:From: Michael PaesoldDate: 2007-06-01 06:58:00
Subject: Re: Postmaster startup messages

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group