[pgpool-general: 4130] Re: pgpool log file

Сергей Мелехин cpro29a at gmail.com
Wed Oct 21 11:14:59 JST 2015


We use
log_destination = 'syslog'
syslog_ident='pgpool'
syslog_facility = 'LOCAL3'
in pgpool.conf
and then use standard syslog facilities to save pgpool logs to separate
file and logrotate to rotate it.

С Уважением, Сергей Мелехин.

2015-10-21 1:07 GMT+10:00 Wolf Schwurack <wolf at uen.org>:

> I have pgpool.conf parameter ‘log_statement = on’ Which we want to log all
> statement. I rotate the log every day with logrotate. But pgpool.log keeps
> growing, it show 46G. When I check the file it show it as a Data file.
>
>
>
> How can I rotate the log file without restarting pgpool?
>
>
>
> Ubuntu 14.04.3
>
> pgpool-II version 3.4.0
>
> psql (9.4.4)
>
>
>
>
>
> Wolfgang Schwurack
>
> Database/System Administrator
>
> Utah Education Network
>
> 801-587-9444
>
> wolf at uen.org
>
>
>
>
>
>
>
>
>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20151021/d856717c/attachment.html>


More information about the pgpool-general mailing list