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

Tatsuo Ishii ishii at sraoss.co.jp
Tue Mar 6 20:54:08 JST 2018


> 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
>>


More information about the pgpool-general mailing list