[Pkg-postgresql-public] Bug#819075: pgbouncer does not start on my Debian Jessie, but sais that starting is OK

[Nikolay Shaplov]

Package: pgbouncer
Version: 1.5.4-6+deb8u1
Severity: important



I am trying to run pgbouncer in Debian Jessie (in lxc container if it is important)

I've installed pgbouncer package, and started the service, it said everything is ok:

$ sudo /etc/init.d/pgbouncer start
[ ok ] Starting pgbouncer (via systemctl): pgbouncer.service.

but no pgbouncer process were actually started

$ ps aux | grep pg
nataraj   5562  0.0  0.0  12744  2192 pts/2    S+   16:31   0:00 grep pg

sudo ls /var/run/postgresql/
gives no output.

Meanwhile pgbouncer and pgbouncer's config is workable. If I start it manually it starts to work and do something:

$ sudo su postgres

$ /usr/sbin/pgbouncer /etc/pgbouncer/pgbouncer.ini 
2016-03-23 16:36:10.827 5630 LOG File descriptor limit: 65536 (H:65536), max_client_conn: 100, max fds possible: 110
2016-03-23 16:36:10.827 5630 LOG listening on 127.0.0.1:6432
2016-03-23 16:36:10.827 5630 LOG listening on unix:/var/run/postgresql/.s.PGSQL.6432
2016-03-23 16:36:10.827 5630 LOG process up: pgbouncer 1.5.4, libevent 2.0.21-stable (epoll), adns: evdns2

And you can see it's pid file in another console.

$ sudo ls /var/run/postgresql/
pgbouncer.pid


I still can not undertand why it does not work. This seems to be some systemd issue and I even do not know how to debug it




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

Kernel: Linux 3.16.0-4-amd64 (SMP w/8 CPU cores)
Locale: LANG=ru_RU.UTF-8, LC_CTYPE=ru_RU.UTF-8 (charmap=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
ii  libevent-2.0-5     2.0.21-stable-2
ii  lsb-base           4.1+Debian13+nmu1
ii  postgresql-common  165

pgbouncer recommends no packages.

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

-- Configuration Files:
/etc/pgbouncer/pgbouncer.ini [Errno 13] Отказано в доступе: u'/etc/pgbouncer/pgbouncer.ini'
/etc/pgbouncer/userlist.txt [Errno 13] Отказано в доступе: u'/etc/pgbouncer/userlist.txt'

-- no debconf information