Your message dated Mon, 14 Nov 2016 10:17:05 +0100
with message-id <[email protected]>
and subject line Re: Bug#819075: pgbouncer does not start on my Debian Jessie, 
but sais that starting is OK
has caused the Debian Bug report #819075,
regarding pgbouncer does not start on my Debian Jessie, but sais that starting 
is OK
to be marked as done.

This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.

(NB: If you are a system administrator and have no idea what this
message is talking about, this may indicate a serious mail system
misconfiguration somewhere. Please contact [email protected]
immediately.)


-- 
819075: http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=819075
Debian Bug Tracking System
Contact [email protected] with problems
--- Begin Message ---
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

--- End Message ---
--- Begin Message ---
Re: Alexey Malov 2016-04-13 
<CAHrzFpCvWL=wxKjpj=3bZ4DP+zMOn5--WQM=x2cj1kbpxoa...@mail.gmail.com>
> 

Re: Nikolay Shaplov 2016-11-14 <no.id>
> 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

Hi Nikolay, hi Alexey,

on Jessie, /etc/default/pgbouncer has START=0 set. With that, the
service behaves as you are describing. Arguably, this is confusing.
(The stretch version won't have this mechanism anymore.)

Please reopen the bug if the problem was something else. Thanks!

Christoph

Attachment: signature.asc
Description: PGP signature


--- End Message ---
_______________________________________________
Pkg-postgresql-public mailing list
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/pkg-postgresql-public

Reply via email to