Re: pgbouncer logrotate configuration

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Devrim Gündüz <devrim(at)gunduz(dot)org>
Cc: pgsql-pkg-yum(at)postgresql(dot)org
Subject: Re: pgbouncer logrotate configuration
Date: 2015-05-13 20:55:32
Message-ID: 5553BA44.7090701@gmx.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-pkg-yum

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.

In response to

Responses

Browse pgsql-pkg-yum by date

  From Date Subject
Next Message Laurent Wandrebeck 2015-05-14 09:39:17 RHEL7 pgbouncer package /run/pgbouncer rights glitch after reboot
Previous Message Devrim Gündüz 2015-05-13 07:19:06 Re: pg_upgrade support is broken?