Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Ysdgu-0003ME-4D for pgsql-pkg-yum@arkaria.postgresql.org; Wed, 13 May 2015 20:55:44 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Ysdgt-0000Wy-DF for pgsql-pkg-yum@arkaria.postgresql.org; Wed, 13 May 2015 20:55:43 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1Ysdgs-0000Ws-To for pgsql-pkg-yum@postgresql.org; Wed, 13 May 2015 20:55:43 +0000 Received: from mout.gmx.net ([212.227.15.19]) by makus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.84) (envelope-from ) id 1Ysdgp-0000Av-Lz for pgsql-pkg-yum@postgresql.org; Wed, 13 May 2015 20:55:41 +0000 Received: from auth1-smtp.messagingengine.com ([66.111.4.227]) by mail.gmx.com (mrgmx001) with ESMTPSA (Nemesis) id 0LnxxQ-1ZPTTF05V2-00g3Bp for ; Wed, 13 May 2015 22:55:37 +0200 Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailauth.nyi.internal (Postfix) with ESMTP id 3D8072027E for ; Wed, 13 May 2015 16:55:35 -0400 (EDT) Received: from frontend1 ([10.202.2.160]) by compute1.internal (MEProxy); Wed, 13 May 2015 16:55:35 -0400 X-Sasl-enc: 1kvjAjOx4cnhl8JFLjogyhJGAmR/Pj324yr2CknE7SXr 1431550535 Received: from [192.168.1.117] (unknown [204.145.120.11]) by mail.messagingengine.com (Postfix) with ESMTPA id EDEDDC00017; Wed, 13 May 2015 16:55:34 -0400 (EDT) Message-ID: <5553BA44.7090701@gmx.net> Date: Wed, 13 May 2015 16:55:32 -0400 From: Peter Eisentraut User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.6.0 MIME-Version: 1.0 To: =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= CC: pgsql-pkg-yum@postgresql.org Subject: Re: pgbouncer logrotate configuration References: <555211E1.3010805@gmx.net> <1431465887.4314.18.camel@gunduz.org> In-Reply-To: <1431465887.4314.18.camel@gunduz.org> Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K0:BQ9xBDPEOZwuipw9ih7uZB5QQEzJBGSZee7GylMuv2cuefXaZoM 073Y2oyp7KujSMw6jw1poJlAoqhDwMAMWnpEkvA0LFV44Cr8my94whJJuwxi91w7okqGlq+ 4m24tD3zn54mTsDFJDViDNQLtk8bjddCfeGo52b75pryO9WRTERR6ezzOBgQrl1BtnkF3Ee 7xMoAKH+bHcO4O/7e7dVQ== X-UI-Out-Filterresults: notjunk:1; X-Pg-Spam-Score: -1.9 (-) 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/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. -- 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