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

Re: [PATCHES] Patch to update log levels

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Patches <pgsql-patches(at)postgresql(dot)org>, pgsql-docs(at)postgresql(dot)org
Subject: Re: [PATCHES] Patch to update log levels
Date: 2007-09-21 01:27:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docspgsql-patches
Hash: SHA1

Joshua D. Drake wrote:
> Tom Lane wrote:
>> "Joshua D. Drake" <jd(at)commandprompt(dot)com> writes:
>>> Here is a patch that documents the syslog log levels and their
>>> correlation to the PostgreSQL log levels per:
>> This seems like quite the wrong place to document it --- I'd have
>> thought somewhere near the discussion of syslog logging would be
>> appropriate.  Putting it here means you're in the face of people
>> who do not even have syslog (ie, Windows users)
> Fair enough. Except that we don't really talk about syslog anywhere. We
> do here:
> Which is pretty much where I put it.
> Do we have some kind of correlation for eventlog on windows? Then I
> could just use a table to show the relationships. Something like:

Is this correct for Windows?

1392 	    switch (level)
1393 	    {
1394 	        case DEBUG5:
1395 	        case DEBUG4:
1396 	        case DEBUG3:
1397 	        case DEBUG2:
1398 	        case DEBUG1:
1399 	        case LOG:
1400 	        case COMMERROR:
1401 	        case INFO:
1402 	        case NOTICE:
1403 	            eventlevel = EVENTLOG_INFORMATION_TYPE;
1404 	            break;
1405 	        case WARNING:
1406 	            eventlevel = EVENTLOG_WARNING_TYPE;
1407 	            break;
1408 	        case ERROR:
1409 	        case FATAL:
1410 	        case PANIC:
1411 	        default:
1412 	            eventlevel = EVENTLOG_ERROR_TYPE;
1413 	            break;
1414 	    }


Joshua D. Drake

> Log Level
> PostgreSQL		Syslog		EventLog
> Panic			LOG_CRIT	Usual Behavior
> Sincerely,
> Joshua D. Drake
>> 			regards, tom lane

- ---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

- --

      === The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564   24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997
Donate to the PostgreSQL Project:
PostgreSQL Replication:

Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla -


In response to


pgsql-docs by date

Next:From: Magnus HaganderDate: 2007-09-21 08:30:01
Subject: Re: [PATCHES] Patch to update log levels
Previous:From: Joshua D. DrakeDate: 2007-09-21 01:10:07
Subject: Re: Patch to update log levels

pgsql-patches by date

Next:From: Tom LaneDate: 2007-09-21 02:02:12
Subject: Re: adjust chr()/ascii() to prevent invalidly encoded data
Previous:From: Tom LaneDate: 2007-09-21 01:26:50
Subject: Re: curious regression failures

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