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