Re: BUG #5741: syslog line length - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #5741: syslog line length
Date
Msg-id BANLkTinedFHCU48tn2--s1bi+dvdpfyWHQ@mail.gmail.com
Whole thread Raw
In response to BUG #5741: syslog line length  ("heasley" <heas@shrubbery.net>)
Responses Re: BUG #5741: syslog line length
List pgsql-bugs
On Tue, Nov 2, 2010 at 12:17 PM, heasley <heas@shrubbery.net> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A05741
> Logged by: =A0 =A0 =A0 =A0 =A0heasley
> Email address: =A0 =A0 =A0heas@shrubbery.net
> PostgreSQL version: 8.4
> Operating system: =A0 solaris
> Description: =A0 =A0 =A0 =A0syslog line length
> Details:
>
> * Max string length to send to syslog(). =A0Note that this doesn't count =
the
> =A0* sequence-number prefix we add, and of course it doesn't count the pr=
efix
> =A0* added by syslog itself. =A0 =A0 =A0On many implementations it seems =
that the
> hard
> =A0* limit is approximately 2K bytes including both those prefixes.
> =A0*/
> #ifndef PG_SYSLOG_LIMIT
> #define PG_SYSLOG_LIMIT 1024
> #endif
>
> solaris' syslogd limits the line length to 1024, with a
> FQDN and it's silly "msg ID" quite a bit is dropped by
> syslogd.

You can recompile with -DPG_SYSLOG_LIMIT=3D<some smaller value>.

We could add a configuration setting for this, if it's affecting a lot
of people.

--=20
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #6063: compatability issues
Next
From: Matthijs Bomhoff
Date:
Subject: Re: Bug with plpgsql, temp tables and TOAST?