<div dir="ltr">We use<div><font face="monospace, monospace">log_destination = 'syslog'</font></div><div><font face="monospace, monospace">syslog_ident='pgpool'</font></div><div><font face="monospace, monospace">syslog_facility = 'LOCAL3'</font></div><div>in pgpool.conf</div><div>and then use standard syslog facilities to save pgpool logs to separate file and logrotate to rotate it.</div></div><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">С Уважением, Сергей Мелехин.</div></div>
<br><div class="gmail_quote">2015-10-21 1:07 GMT+10:00 Wolf Schwurack <span dir="ltr"><<a href="mailto:wolf@uen.org" target="_blank">wolf@uen.org</a>></span>:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div>
<p class="MsoNormal">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.
<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">How can I rotate the log file without restarting pgpool?<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Ubuntu 14.04.3<u></u><u></u></p>
<p class="MsoNormal">pgpool-II version 3.4.0<u></u><u></u></p>
<p class="MsoNormal">psql (9.4.4)<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Wolfgang Schwurack<u></u><u></u></p>
<p class="MsoNormal">Database/System Administrator<u></u><u></u></p>
<p class="MsoNormal">Utah Education Network<u></u><u></u></p>
<p class="MsoNormal">801-587-9444<u></u><u></u></p>
<p class="MsoNormal"><a href="mailto:wolf@uen.org" target="_blank">wolf@uen.org</a><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>_______________________________________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>