[pgpool-general: 5984] Re: pgpool.log rotation

[Mariel Cherkassky]

Tatuo, I think that I realized what is the problem but I dont know how to
solve it. I run the same command as you (interval of 15 seconds) and then I
close the session. The pgpool keeps running but nothing is written to the
log and the rotate log isnt working. Can you try to run the command and
then exit the session and check if the log rotates and if new rows are
entered into the log ?

2018-03-06 16:44 GMT+02:00 Mariel Cherkassky <mariel.cherkassky at gmail.com>:

> I realized that it is because the file pgpoo.log.Tuesday is overwritten
> every 15 seconds. Please update me if you have problems when you set the
> rotation interval  86400 .
>
> 2018-03-06 16:42 GMT+02:00 Mariel Cherkassky <mariel.cherkassky at gmail.com>
> :
>
>> I used the same command but in contrast to you in my case a new file isnt
>> created every 15 minutes. Moreover, when I close the session pgpool still
>> continues to work but no entries are entered to the log
>>
>>
>>
>> 2018-03-06 13:54 GMT+02:00 Tatsuo Ishii <ishii at sraoss.co.jp>:
>>
>>> > What do you mean by stopped the command before starting ? stopped what
>>> > exactly ?
>>>
>>> I thought you restarted pgpool next day. Now I realize you haven't
>>> restarted pgpool. So please ignore my question.
>>>
>>> I tested something like:
>>> pgpool ... 2>&1 | /usr/bin/rotatelogs -c -l -v -f /tmp/pgpool.log.%c 15 &
>>>
>>> and rotatelog created:
>>>
>>> /tmp/pgpool.log.Tue Mar  6 11:15:00 2018
>>> /tmp/pgpool.log.Tue Mar  6 11:15:15 2018
>>> /tmp/pgpool.log.Tue Mar  6 11:15:30 2018
>>>
>>> as expected (this is Ubuntu 16). Let me try with 86400 instead of 15
>>> tonight.
>>>
>>> Best regards,
>>> --
>>> Tatsuo Ishii
>>> SRA OSS, Inc. Japan
>>> English: http://www.sraoss.co.jp/index_en.php
>>> Japanese:http://www.sraoss.co.jp
>>>
>>> > 2018-03-06 4:23 GMT+02:00 Tatsuo Ishii <ishii at sraoss.co.jp>:
>>> >
>>> >> > Hi,
>>> >> > I used the next command to start the pool and to start the log
>>> rotation :
>>> >> > pgpool -n 2>&1 | /usr/sbin/rotatelogs -l -f
>>> >> > /PostgreSQL/pgpool/log/pgpool.log.%A 86400 &
>>> >> > pgpool started and the log was named : pgpool.log.Wednesday
>>> >> >
>>> >> > 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..
>>> >>
>>> >> Have you stopped the command before starting? I guess rotatelogs
>>> >> process reamains.
>>> >>
>>> >> Best regards,
>>> >> --
>>> >> Tatsuo Ishii
>>> >> SRA OSS, Inc. Japan
>>> >> English: http://www.sraoss.co.jp/index_en.php
>>> >> Japanese:http://www.sraoss.co.jp
>>> >>
>>>
>>
>>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20180306/3929d595/attachment-0001.html>