pgbouncer not finding pidfile - Mailing list pgsql-general

From Tobias Fielitz
Subject pgbouncer not finding pidfile
Date
Msg-id 53D72418.8030007@streethawk.com
Whole thread Raw
Responses Re: pgbouncer not finding pidfile  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Hi,

I am trying to start pgbouncer via upstart script. The upstart logs
(/var/log/upstart/pgbouncer.log) tell me:
/var/run/postgresql/pgbouncer.pid: No such file or directory [2]

but when starting pgbouncer from the console with:

 > sudo service pgbouncer start

it works fine and the pidfile is created.

Here is the upstart script (/etc/init/pgbouncer.conf):

start on (net-device-up and local-filesystems and runlevel [2345])
stop on runlevel [016]

setuid postgres
setgid postgres
respawn limit 10 30

exec /usr/sbin/pgbouncer /etc/pgbouncer/pgbouncer.ini

The permissions for the folder seem ok:

 > ls -lsah /var/run/ | grep postgresql
0 drwxrwsr-x  2 postgres   postgres    100 Jul 29 04:18 postgresql

I have no clue whats wrong.
Any help would be appreciated.
Tobi

Attachment

pgsql-general by date:

Previous
From: Sameer Kumar
Date:
Subject: Monitoring PostgreSQL with BMC Patrol and Sentry Monitoring Studio
Next
From: Bror Jonsson
Date:
Subject: Problems with pg_upgrade.