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

[Mariel Cherkassky]

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