logging postgres to syslog on centos, truncates the postgres message.

Started by Chris Barnesover 15 years ago3 messagesgeneral
Jump to latest
#1Chris Barnes
compuguruchrisbarnes@hotmail.com

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Chris Barnes (#1)
Re: logging postgres to syslog on centos, truncates the postgres message.

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

#3Chris Barnes
compuguruchrisbarnes@hotmail.com
In reply to: Tom Lane (#2)
Re: logging postgres to syslog on centos, truncates the postgres message.

On separate lines it is, thanks Tom.

Show quoted text

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