[Pkg-postgresql-public] Bug#813487: pgbouncer: Upgrading pgbouncer drops connections when run with systemd

[Chris Butler]

Package: pgbouncer
Version: 1.7-1.pgdg80+1
Severity: normal

Hi,

In the good old sysvinit days, an upgrade to pgbouncer could be done seamlessly
because the init script used the -R flag to tell pgbouncer to take over from the
existing daemon. However, it seems like this doesn't happen when using systemd.

Is there any way to bring back zero connection loss upgrades under systemd?

-- System Information:
Debian Release: 8.3
  APT prefers stable-updates
  APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)

Kernel: Linux 2.6.32-042stab108.2 (SMP w/40 CPU cores)
Locale: LANG=en_GB.UTF-8, LC_CTYPE=en_GB.UTF-8 (charmap=UTF-8) (ignored: LC_ALL set to en_GB.UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)

Versions of packages pgbouncer depends on:
ii  libc6              2.19-18+deb8u2
ii  libevent-2.0-5     2.0.21-stable-2
ii  libssl1.0.0        1.0.1k-3+deb8u2
ii  lsb-base           4.1+Debian13+nmu1
ii  postgresql-common  172.pgdg80+1

pgbouncer recommends no packages.

Versions of packages pgbouncer suggests:
ii  python           2.7.9-1
pn  python-psycopg2  <none>

-- Configuration Files:
/etc/default/pgbouncer changed [not included]
/etc/pgbouncer/pgbouncer.ini [Errno 13] Permission denied: u'/etc/pgbouncer/pgbouncer.ini'
/etc/pgbouncer/userlist.txt [Errno 13] Permission denied: u'/etc/pgbouncer/userlist.txt'

-- no debconf information