pgpool 2 rotate logs - Mailing list pgsql-performance

From Mariel Cherkassky
Subject pgpool 2 rotate logs
Date
Msg-id CA+t6e1nbNxymrFNivQr3m2RUH_1hi4_kKsKWYSPzn-_=_+TFUQ@mail.gmail.com
Whole thread Raw
Responses Re: pgpool 2 rotate logs
List pgsql-performance
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 ?

pgsql-performance by date:

Previous
From:
Date:
Subject: Re: Efficiently searching for the most recent rows where a columnmatches any result from a different query
Next
From: Tatsuo Ishii
Date:
Subject: Re: pgpool 2 rotate logs