DEBUG messages

I've searched the docs., faqs and mailing lists for this but didn't find
anything.

Everytime I startup our postgres db, I get DEBUG messages as follows

DEBUG: database system was shut down at 2001-11-28 16:35:55 PST
DEBUG: CheckPoint record at (0, 2246696)
DEBUG: Redo record at (0, 2246696); Undo record at (0, 0); Shutdown TRUE
DEBUG: NextTransactionId: 753; NextOid: 19745
DEBUG: database system is in production state

Can someone tell me how to display only ERROR messages?

Added to TODO:

* Change DEBUG tag used in server logs

Seems it should say NOTICE. People are seeing DEBUG and think they have
debugging enabled.

-- 
  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

Hello,

How would I store jpeg file into postgresql and retrieve this jpeg
file for display in my web page? I tried the lo_export and lo_import
functions but do we have other means without resorting to these functions?

manny

lo_export and lo_import work on the backend side. If you are using php as
server side language, there are similar php functions that allow you to
open/read/write large objects.

--
Ing. Denis Gasparin: denis@edistar.com
---------------------------
Programmer & System Administrator - Edistar srl
www.edistar.com

Alle 03:56, gioved� 6 dicembre 2001, hai scritto:

Bruce Momjian <pgman@candle.pha.pa.us> writes:

Added to TODO:
* Change DEBUG tag used in server logs
Seems it should say NOTICE.

It had better *not* be a NOTICE, because there is no attached client
to forward the message to.

There is some confusion in the elog() design between message severity
level and message destination, viz DEBUG goes only to postmaster log,
NOTICE and up go to client and log. And then we have a separate
DebugLevel variable that controls how many places will emit DEBUG
messages. It might be better to unify this into a single mechanism.
Maybe replace
if (DebugLevel > 2)
elog(DEBUG, ...)
with
elog(DEBUG2, ...)
and then have two GUC variables consulted by elog that tell the
minimum message level to send to the log and the client respectively.

regards, tom lane

Bruce Momjian <pgman@candle.pha.pa.us> writes:

Added to TODO:
* Change DEBUG tag used in server logs
Seems it should say NOTICE.

It had better *not* be a NOTICE, because there is no attached client
to forward the message to.

Oh, that is a bummer. I see the guy's point about it being misleading
in the log, but I hate to add complexity to do it.

-- 
  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

Bruce Momjian <pgman@candle.pha.pa.us> writes:

Added to TODO:
* Change DEBUG tag used in server logs
Seems it should say NOTICE.

It had better *not* be a NOTICE, because there is no attached client
to forward the message to.

There is some confusion in the elog() design between message severity
level and message destination, viz DEBUG goes only to postmaster log,
NOTICE and up go to client and log. And then we have a separate
DebugLevel variable that controls how many places will emit DEBUG
messages. It might be better to unify this into a single mechanism.
Maybe replace
if (DebugLevel > 2)
elog(DEBUG, ...)
with
elog(DEBUG2, ...)
and then have two GUC variables consulted by elog that tell the
minimum message level to send to the log and the client respectively.

Tom, my idea on this was to emit NOTICE to clients only if a client
exists, and in postmaster startup, it does not. Frankly, assuming a
client exists for all NOTICE elogs is a bug anyway.

-- 
  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