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

[Mariel Cherkassky]

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/bf7a7b03/attachment.html>