pgbouncer.service sample

pgbouncer.service (text/x-dbus-service), 1.28 KB, created by Vasilis Lourdas on 2020-10-09 15:54:52 UTC

# Example systemd service unit for PgBouncer
#
# - Adjust the paths in ExecStart for your installation.
#
# - The User setting requires careful consideration.  PgBouncer needs
#   to be able to place a Unix-domain socket file where PostgreSQL
#   clients will look for it.  In the olden days, this was in /tmp,
#   but systems using systemd now prefer something like
#   /var/run/postgresql/.  But then some systems also lock down that
#   directory so that only the postgres user can write to it.  That
#   means you need to either
#
#   - run PgBouncer as the postgres user, or
#
#   - create a separate user and add it to the postgres group and
#     make /var/run/postgresql/ group-writable, or
#
#   - use systemd to create the sockets; see pgbouncer.socket nearby.
#
#   For packagers and deployment systems, this requires some
#   coordination between the PgBouncer and the PostgreSQL
#   packages/components.
#
[Unit]
Description=connection pooler for PostgreSQL
Documentation=man:pgbouncer(1)
Documentation=https://www.pgbouncer.org/
After=network.target
#Requires=pgbouncer.socket

[Service]
Type=notify
User=postgres
RuntimeDirectory=pgbouncer
ExecStart=/usr/bin/pgbouncer /etc/pgbouncer.ini
ExecReload=/bin/kill -HUP $MAINPID
KillSignal=SIGINT
#LimitNOFILE=1024

[Install]
WantedBy=multi-user.target