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