[rsyslog] log ., except logs by "postgres"

Fri Mar 19 00:58:37 CET 2010

Am 19.03.2010 00:52, david at lang.hm wrote:

>> OK, with ' it started to log again, but still postgres gets to both 
>> /var/log/syslog and /var/log/postgresql/postgresql_log.
>>
>> So, not as expected.
> 
> what does the raw log message look like again?

Like these ones:

Mar 19 07:47:32 db10 postgres[4539]: [87-1] 2010-03-19 07:47:32 SGT LOG:  duration: 0.234 ms  statement: COMMIT
Mar 19 07:47:32 db10 postgres[4539]: [88-1] 2010-03-19 07:47:32 SGT LOG:  duration: 0.042 ms  statement: BEGIN; SET TRANSACTION ISOLATION LEVEL READ 

where postgres[number] can differ.

-- 
Tomasz Chmielewski
http://wpkg.org

[rsyslog] log *.*, except logs by "postgres"

[rsyslog] log ., except logs by "postgres"