Re: log statements span multiple lines

Поиск
Список
Период
Сортировка
От Stuart Kendrick
Тема Re: log statements span multiple lines
Дата
Msg-id 4CF2AFB1.5040507@fhcrc.org
обсуждение исходный текст
Ответ на Re: log statements span multiple lines  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi Tom,

Ah, I see.  For the moment, I've bumped PG_SYSLOG_LIMIT from 128 to 1024

Thank you,

--sk

On 11/28/2010 8:54 AM, Tom Lane wrote:
> Stuart Kendrick<skendric@fhcrc.org>  writes:
>> How do I tell postmaster to log SQL statements to a single line?
>
> Don't use syslog.
>
>> At the moment, a particular statement gets chopped up across multiple
>> syslog lines:
>
> The reason for this is that many syslog implementations have arbitrary
> limits on line lengths, and will drop or corrupt data beyond that.
>
> If you know what the limit is on your particular platform, you could
> adjust the chopping-point constant in elog.c.  (I would not recommend
> disabling the chopping behavior altogether.)  But on the whole it's
> probably better to switch to another logging method.
>
>             regards, tom lane

В списке pgsql-novice по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: debugging SQL statements
Следующее
От: Stuart Kendrick
Дата:
Сообщение: Re: debugging SQL statements