Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1ZeSfa-00085K-JX for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 22 Sep 2015 18:52:02 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1ZeSfa-0003js-5o for pgsql-pkg-yum@arkaria.postgresql.org; Tue, 22 Sep 2015 18:52:02 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1ZeSfZ-0003jm-SH for pgsql-pkg-yum@postgresql.org; Tue, 22 Sep 2015 18:52:02 +0000 Received: from mout.gmx.net ([212.227.15.18]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1ZeSfW-0004KN-Oj for pgsql-pkg-yum@postgresql.org; Tue, 22 Sep 2015 18:52:00 +0000 Received: from auth2-smtp.messagingengine.com ([66.111.4.228]) by mail.gmx.com (mrgmx003) with ESMTPSA (Nemesis) id 0Mda8q-1a3rHM1wlQ-00POSS for ; Tue, 22 Sep 2015 20:51:56 +0200 Received: from compute2.internal (compute2.nyi.internal [10.202.2.42]) by mailauth.nyi.internal (Postfix) with ESMTP id A1D38202EF for ; Tue, 22 Sep 2015 14:51:54 -0400 (EDT) Received: from frontend2 ([10.202.2.161]) by compute2.internal (MEProxy); Tue, 22 Sep 2015 14:51:54 -0400 X-Sasl-enc: 6tMLKlhvzuV7orBk5rKTetRCo5GqrV0ziRpPQTcHuJra 1442947914 Received: from [192.168.1.59] (unknown [204.145.120.11]) by mail.messagingengine.com (Postfix) with ESMTPA id 6128F68018A; Tue, 22 Sep 2015 14:51:54 -0400 (EDT) Subject: Re: pgbouncer logrotate configuration To: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= References: <555211E1.3010805@gmx.net> <1431465887.4314.18.camel@gunduz.org> <5553BA44.7090701@gmx.net> Cc: pgsql-pkg-yum@postgresql.org From: Peter Eisentraut Message-ID: <5601A349.3000901@gmx.net> Date: Tue, 22 Sep 2015 14:51:53 -0400 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:38.0) Gecko/20100101 Thunderbird/38.2.0 MIME-Version: 1.0 In-Reply-To: <5553BA44.7090701@gmx.net> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K0:PPQGTQZS3eJRt16KZ4S15td2R4xISGJ5dn4bWfX0geTQ9gHXAT/ tIxf0XG9jGbCIrYz9j1qiT1vq3Vf3SSmuNlB0tNJb+umkEQbvsg0giB1kwTqbQRbfOpDBj9 24ddO8mOBCZYB90mrDniYqkPDov+g1P4FEGaPcLH7uDYpCaowOq4EgT7cGLhMSjJMv7ZaP5 1eQGCKiF8u+b+as/W8w3g== X-UI-Out-Filterresults: notjunk:1;V01:K0:qpxP+wYQCfU=:lusixOhcDcJirGfeAwKmRl MMb5YclshYKP2jh2ZZEDBJ4cdK3X1IXwN5WFSlRITCoHWh7UnAZnCjuCtdBmVabsHI5sZebKj tPxznWWyfQqyyXj3wxLTq72ysVzZ0z4JEk04sebtFEpPmD+UPDagAoWD2ULuD9a72T32idqav zh33nwjYaJKOLo3cQU6ZfwVQbUpvr+EUbaw9ddQMQUH6UjC8Aui6UyPDNOAiboQR5oilUo9fF dyzLMY/H3wrzkDMupoGFbjIkTKyCORLIm2LW8pdt//+hgC/ti6lJtf6gvixTZEuBspDmIBqnM 9T2gf+a3TQ+9+lkOhjy1ieHf95mBI8IpXd0ioHrQR8lTbeTs0dPVojC7oj+IzjiI6n/tXhcnV N9kXKhLe4CFdkYO83B+dafsSSUeKXa6qTi9H8vpd7/88MbNs404UrgRoTlmypdU7bd0avqOOP Vt8ipbap3CIoLXIMioghV7164pbgn8EPiZuPW9b5X+sk3SeAOOajfLJ6iWtYA1gX2B6g3GlgY aTyLk6EHL37Gf3FpkHiq9gxFcjIProzbEOWmP8zl2cyIa1yXC//sQrIHQ7yc8wCnXvpqE5r+n dMe40AuhjIYpPHJ5FbR1wNJIRXHV8TOtzA/miSZyO+HrN0USPUqCRf2sPzWDpX0v1JWRD+eWs iSkaLNIQ2ZeOIxLTZkHg1/rVEKXOZuFd1XBcGMjGoKygE8oYNOYC255cPByRDUklrK2SrO5cN yaiCXknDxUIZKC5jWMzC27FV4AEGFokRFRr5iw== X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-pkg-yum Precedence: bulk Sender: pgsql-pkg-yum-owner@postgresql.org On 5/13/15 4:55 PM, Peter Eisentraut wrote: > On 5/12/15 5:24 PM, Devrim Gündüz wrote: >> >> Hi, >> >> On Tue, 2015-05-12 at 10:44 -0400, Peter Eisentraut wrote: >>> The pgbouncer logrotate configuration seems a bit contradictory: >>> >>> /var/log/pgbouncer.log { >>> missingok >>> notifempty >>> sharedscripts >>> copytruncate >>> create 0640 pgbouncer pgbouncer >>> nodateext >>> postrotate >>> /bin/kill -HUP `cat /var/run/pgbouncer/pgbouncer.pid >>> 2>/dev/null` 2> /dev/null || true >>> endscript >>> } >>> >>> "create" is ignored if "copytruncate" is used. And having a postrotate >>> script to send a HUP signal is also pointless if copytruncate is used. >>> We need to decide on one way to do it: either copytruncate, or rename >>> and SIGHUP. >>> >>> It also seems to me that this might be a bit simpler if we created a >>> subdirectory /var/log/pgbouncer/ for all the log files. Then we >>> wouldn't have the permissions issues that the "create" directory is >>> attempting to solve. >> >> Just committed a fix for this. Can you please pull 9.4 tree and see >> whether all problems you reported have been fixed or not? I can push the >> packages tomorrow or so. > > I haven't tested it, but I think the currently committed logrotate file > won't work at all, because *both* the copytruncate the the postrotate > script were removed. You need to keep at least one. > > Also, I think the /var/log/pgbouncer/ directory needs to be created > somewhere in the spec file. This is still not fixed. -- Sent via pgsql-pkg-yum mailing list (pgsql-pkg-yum@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-pkg-yum