Re: how to get logger to not break up syslog messages

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: l1(at)nym(dot)hush(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: how to get logger to not break up syslog messages
Date: 2011-02-09 17:09:06
Message-ID: 29808.1297271346@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

l1(at)nym(dot)hush(dot)com writes:
> The problem I'm running into is that lines are getting broken up.

Yup, that's intentional.

> This causes problems with some other log-scanners I use. Is the
> problem postgres or syslog? I know syslog has a maximum message
> size, but it's a lot longer than what Postgres seems to use.

syslog's limit is platform-dependent, and at least on some platforms
it's pretty darn small. If you know for sure what your platform
can tolerate, you can alter PG_SYSLOG_LIMIT in
src/backend/utils/error/elog.c. There's no way to change it
without a recompile.

regards, tom lane

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Steve Crawford 2011-02-09 17:22:56 Re: how to get logger to not break up syslog messages
Previous Message Caradoc Jones 2011-02-09 16:33:25 Data Model Protection?