Re: Syslog line wrapping - Mailing list pgsql-admin

From Tom Lane
Subject Re: Syslog line wrapping
Date
Msg-id 5956.1285302092@sss.pgh.pa.us
Whole thread Raw
In response to Syslog line wrapping  (Evan Rempel <erempel@uvic.ca>)
List pgsql-admin
Evan Rempel <erempel@uvic.ca> writes:
> I am running Postgresql 8.3 and would like to get postgres to
> NOT wrap the syslog lines. Is ther any configuration to do this.
> Perhaps I can wrap them at a very large line number?

The problem we're up against is explained in src/backend/utils/error/elog.c:

     * Our problem here is that many syslog implementations don't handle long
     * messages in an acceptable manner. While this function doesn't help that
     * fact, it does work around by splitting up messages into smaller pieces.

If you are fortunate enough to have a less-broken-than-average syslog
facility, you could increase the PG_SYSLOG_LIMIT constant defined there.
On the whole, though, I'd suggest not depending on syslog.  It has
other issues besides this one, like sometimes losing messages entirely.

            regards, tom lane

pgsql-admin by date:

Previous
From: Evan Rempel
Date:
Subject: Syslog line wrapping
Next
From: Vladimir Rusinov
Date:
Subject: Re: Syslog line wrapping