how to get logger to not break up syslog messages

From: l1(at)nym(dot)hush(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: how to get logger to not break up syslog messages
Date: 2011-02-09 15:36:46
Message-ID: 20110209153647.20557E66F4@smtp.hushmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Zhengyu Hu 2011-02-09 16:14:38 Error in postgresqlExecStatement...RS-DBI driver: (could not Retrieve the result...)
Previous Message Jasen Betts 2011-02-09 12:16:53 Re: raise statement, how to do multi-line message