Обсуждение: Syslog line wrapping

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 is that we want a program to analyze the logs for us, and with the line breaks it
is very difficult, although not impossible, to get a program to do this.

Evan Rempel.

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

On tor, 2010-09-23 at 20:55 -0700, Evan Rempel wrote:
> 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?

PostgreSQL 8.4 increased the line length.