Обсуждение: logging postgres to syslog on centos, truncates the postgres message.

Hoping someone can help me with this problem.

I am logging postgres to syslog on a CentOS release 5.4 (Final)   ( 2.6.18-164.el5 ). When I look for an update statement it appears to
be truncated and missing the whole statement.

Is there a quick way to resolve this? Is it linux or postgres?

Thanks,

Chris

Chris Barnes <compuguruchrisbarnes@hotmail.com> writes:
> I am logging postgres to syslog on a CentOS release 5.4 (Final)   ( 2.6.18-164.el5 ). When I look for an update
statementit appears to 
> be truncated and missing the whole statement.

Our code for logging to syslog does split long lines into multiple
messages --- are you sure you're not just failing to see the rest
of the statement?

            regards, tom lane

On separate lines it is, thanks Tom.

> To: compuguruchrisbarnes@hotmail.com
> CC: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] logging postgres to syslog on centos, truncates the postgres message.
> Date: Thu, 9 Sep 2010 10:39:10 -0400
> From: tgl@sss.pgh.pa.us
>
> Chris Barnes <compuguruchrisbarnes@hotmail.com> writes:
> > I am logging postgres to syslog on a CentOS release 5.4 (Final) ( 2.6.18-164.el5 ). When I look for an update statement it appears to
> > be truncated and missing the whole statement.
>
> Our code for logging to syslog does split long lines into multiple
> messages --- are you sure you're not just failing to see the rest
> of the statement?
>
> regards, tom lane
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general