Re: RHEL7 pgbouncer package /run/pgbouncer rights glitch after reboot - Mailing list pgsql-pkg-yum

From Jeff Frost
Subject Re: RHEL7 pgbouncer package /run/pgbouncer rights glitch after reboot
Date
Msg-id D5ED0701-5D83-409E-85B5-0512D3609AD3@pgexperts.com
Whole thread Raw
In response to Re: RHEL7 pgbouncer package /run/pgbouncer rights glitch after reboot  (Laurent Wandrebeck <l.wandrebeck@quelquesmots.fr>)
Responses Re: RHEL7 pgbouncer package /run/pgbouncer rights glitch after reboot
List pgsql-pkg-yum

On Jun 2, 2015, at 1:28 AM, Laurent Wandrebeck <l.wandrebeck@quelquesmots.fr> wrote:

Le 02/06/2015 01:47, Jeff Frost a écrit :


Sorry for the slow reply, but I’ve been on vacation.

I just cut a branch jf/fix_pgbouncer_varrundir to fix this.

Will probably get that merged the next time we build these.

np Jeff :)
Thanks for the branch.
Another point noticed since PG 9.4.2 and both its /tmp and /var/run sockets.
Shouldn’t pgbouncer definitely switch under postgres user and use /var/run too ?
I’ve had some glitches restarting pgbouncer after 9.4.2 updates.
My config here:
pg and pgbouncer use each other port (pg runs on 6432, pgb on 5432 for some apps not allowing to change port used).
I’ve switched pgbouncer under postgres user and put its socket file into /var/run/postgresql.
That’s imho definitely the simplest way to manage the change to /var/run as indicated in changelog:

* Fri May 22 2015 Devrim Gündüz <devrim@gunduz.org> - 9.4.2-2PGDG
- Create and own /var/run/postgresql directory. Per report from
  Pete Deffendol.

* Wed May 20 2015 Devrim Gündüz <devrim@gunduz.org> - 9.4.2-1PGDG
- Update to 9.4.2, per changes described at:
  http://www.postgresql.org/docs/9.4/static/release-9-4-2.html
- Add a new patch (Patch5) from Fedora:
  * Configure postmaster to create sockets in both /var/run/postgresql and /tmp;
    the former is now the default place for libpq to contact the postmaster.
- Add tmpfiles.d conf file

If you see any other (better) way to workaround these changes, that’s ok with me, provided it does not mess too much with running configs ;)

Oh, so you’re suggesting that pgbouncer use both socket directories as well?

That would require a pgbouncer patch to support multiple socket locations.



pgsql-pkg-yum by date:

Previous
From: Laurent Wandrebeck
Date:
Subject: Re: RHEL7 pgbouncer package /run/pgbouncer rights glitch after reboot
Next
From: Laurent Wandrebeck
Date:
Subject: Re: RHEL7 pgbouncer package /run/pgbouncer rights glitch after reboot