<div dir="rtl"><div dir="ltr">Hi,</div><div dir="ltr">I used the next command to start the pool and to start the log rotation : </div><div dir="ltr">pgpool -n 2>&1 | /usr/sbin/rotatelogs -l -f /PostgreSQL/pgpool/log/pgpool.log.%A 86400 &<br></div><div dir="ltr">pgpool started and the log was named : pgpool.log.Wednesday</div><div dir="ltr"><br></div><div dir="ltr">However, the next day after running this command, a new log is created at 01:11 am but the log is stuck and nothing is written to it. Right now my logs name is pgpool.log.Thursday and nothing is written to it. A new log is created but nothing is written to all the logs..</div><div dir="ltr"><br></div></div><div class="gmail_extra"><br><div class="gmail_quote"><div dir="ltr">2018-02-20 10:23 GMT+02:00 Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span>:</div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">> Hi,<br>
> I have installed pgpool 2 version 3.7.0 . I'm trying to configure log<br>
> rotation on the pgpool.log but It seems that something wrong. I configured<br>
> in logrotate conf file the parameters :<br>
><br>
> /PostgreSQL/pgpool/log/pgpool.<wbr>log {<br>
><br>
> daily<br>
><br>
> dateext<br>
><br>
> missingok<br>
><br>
> compress<br>
><br>
> notifempty<br>
><br>
> maxage 7<br>
><br>
> maxsize 21118320640<br>
><br>
> rotate 7<br>
><br>
> create 644 postgres postgres<br>
><br>
> postrotate<br>
><br>
> su - postgres -c "~/pgpool/bin/pgpool reload"<br>
><br>
> endscript<br>
><br>
> }<br>
><br>
> After the first rotation, an archive is generated but the pool stops<br>
> writing to the original log. Any idea what can be the reason ?<br>
<br>
</span>Because Pgpool-II does not the close log file upon receiving SIGHUP<br>
(issued by reload).<br>
<span class=""><br>
> If this isnt the way can you recommend how to do rotation on pgpool`s log ?<br>
<br>
</span>Probably the easiest way to do it is setting log_destination = 'syslog'.<br>
<br>
Another way to rotate logs is using Apache's rotatelogs program:<br>
<br>
~/pgpool -n 2>&1 | rotatelogs -f -n 3 > /PostgreSQL/pgpool/log/pgpool.<wbr>log 10M<br>
<br>
Will create and rotate pgpool.log, pgpool.log.1, pgpool.log.2 under<br>
/PostgreSQL/pgpool/log every time current log file exceeds 10M.<br>
<br>
I think you could use logrotate if you have a program which reads the<br>
log stream from stdin and write out it to specified file. Also it<br>
needs to accept some signals (for example SIGHUP) then close and open<br>
the log file. Perhaps it is not terribly hard to create such that<br>
program. Or even there's already such a program but I don't know.<br>
<br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
</blockquote></div><br></div>