Thread: DEBUG lines in server log

DEBUG lines in server log

From
Bruce Momjian
Date:
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,
Pennsylvania19026
 


Re: DEBUG lines in server log

From
Tom Lane
Date:
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