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

Bo Peng pengbo at sraoss.co.jp
Tue Feb 20 11:15:16 JST 2018


Hi,

I think you should restart rsyslog after logrotate like


    postrotate
        /bin/kill -HUP `cat /var/run/syslogd.pid 2> /dev/null` 2> /dev/null || true
    endscript



On Mon, 19 Feb 2018 12:43:04 +0200
Mariel Cherkassky <mariel.cherkassky at gmail.com> wrote:

> Hi,
> I have installed pgpool 2 version 3.7.0 . I'm trying to configure log
> rotation on the pgpool.log but It seems that something wrong. I configured
> in logrotate conf file the parameters :
> 
> /PostgreSQL/pgpool/log/pgpool.log {
> 
>         daily
> 
>         dateext
> 
>         missingok
> 
>         compress
> 
>         notifempty
> 
>         maxage 7
> 
>         maxsize 21118320640
> 
>                 rotate 7
> 
>                 create 644 postgres postgres
> 
>                 postrotate
> 
>         su - postgres -c "~/pgpool/bin/pgpool reload"
> 
>                 endscript
> 
> }
> 
> After the first rotation, an archive is generated but the pool stops
> writing to the original log. Any idea what can be the reason ?
> 
> If this isnt the way can you recommend how to do rotation on pgpool`s log ?
> 
> Thanks , Mariel.


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS, Inc. Japan



More information about the pgpool-general mailing list