how to get logger to not break up syslog messages - Mailing list pgsql-novice

From l1@nym.hush.com
Subject how to get logger to not break up syslog messages
Date
Msg-id 20110209153647.20557E66F4@smtp.hushmail.com
Whole thread Raw
Responses Re: how to get logger to not break up syslog messages
List pgsql-novice
Hi

I'm using the syslog as my log destination.  Here are the
configuration settings I have:

log_destination='syslog'
logging_collector='off'
syslog_facility='LOCAL1'
syslog_ident='postgres2'

The problem I'm running into is that lines are getting broken up.
For example:

Feb  9 07:12:50 S1 postgres2[14294]: [2-1] 2011-02-09 07:12:50.633
EST::: LOG:  automatic vacuum of table "mydb.public.mydata": index
scans: 1
Feb  9 07:12:50 S1 postgres2[14294]: [2-2] #011pages: 0 removed,
1773 remain
Feb  9 07:12:50 S1 postgres2[14294]: [2-3] #011tuples: 1107
removed, 74884 remain
Feb  9 07:12:50 S1 postgres2[14294]: [2-4] #011system usage: CPU
0.11s/0.16u sec elapsed 17.70 sec

This causes problems with some other log-scanners I use.  Is the
problem postgres or syslog?  I know syslog has a maximum message
size, but it's a lot longer than what Postgres seems to use.  If
postgres is the issue here, is there a way to configure postgres to
produce a single log message instead of spreading it across lines?

Thanks


pgsql-novice by date:

Previous
From: Jasen Betts
Date:
Subject: Re: raise statement, how to do multi-line message
Next
From: Zhengyu Hu
Date:
Subject: Error in postgresqlExecStatement...RS-DBI driver: (could not Retrieve the result...)