Someone on IRC complained about these lines in the server log:

DEBUG:  database system was shut down at 2001-11-26 16:44:06 EST
DEBUG:  checkpoint record is at 0/1361168
DEBUG:  redo record is at 0/1361168; undo record is at 0/0; shutdown TRUE
DEBUG:  next transaction id: 4484; next oid: 147882
DEBUG:  database system is ready

Should they be there, and should they say DEBUG?

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Mon, 26 Nov 2001 16:45:41 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
DEBUG lines in server log
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Someone on IRC complained about these lines in the server log:
> DEBUG:  database system was shut down at 2001-11-26 16:44:06 EST
> DEBUG:  checkpoint record is at 0/1361168
> DEBUG:  redo record is at 0/1361168; undo record is at 0/0; shutdown TRUE
> DEBUG:  next transaction id: 4484; next oid: 147882
> DEBUG:  database system is ready

> Should they be there, and should they say DEBUG?

They look like DEBUG messages to me ;-)

I would certainly not want the postmaster to start up completely
silently; the "database system is ready" message should absolutely not
be removed.  The "when shut down" output also seems moderately useful
to admins.  The middle three lines are perhaps not useful in normal
operation but I can see them being pretty important in a failure
scenario, so I'm not that much in a hurry to take them out either.

What exactly was the complaint, or rationale for complaining?

			regards, tom lane

Mon, 26 Nov 2001 18:44:07 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: DEBUG lines in server log 