Pgbouncer

Overview

PgBouncer is a lightweight connection pooler for PostgreSQL.

http://wiki.postgresql.org/wiki/PgBouncer

Usage

Installation

To deploy you'll need at a minimum: a cloud environment, a working Juju installation, and a successful bootstrap. Please refer to the Juju Getting Started documentation before continuing.

It is also recommended that you read the documentation for the postgresql charm so you understand how to set up postgresql in a master-slave relationship.

juju deploy postgresql
juju deploy pgbouncer
juju deploy postgresql-charmers-postgresql-client psql

juju relate postgresql:db-admin pgbouncer:backend-db-admin
juju relate psql:db pgbouncer:db  # Or db-admin

Charming

The pgbouncer charm implements the same interface as the PostgreSQL charm. See the PostgreSQL Client Interface for details. Both charms provide the db (standard privileges) and db-admin (administrative privileges) relations, and may be used interchangeably.

Configuration

See config.yaml for configuration options. Further details may be found in the pgbouncer documentation

Extra configuration

Some extra configuration can also be added through the pgbouncer-extra-config relation. Those configurations can be added to the pgbouncer and databases sections. A new config file will be included for each extra configuration.

Monitoring

This charm provides relations that support monitoring via Nagios using nrpe as a subordinate charm.

Support

This charm is maintained by Stuart Bishop on Launchpad. Please use the main Juju mailing list for general discussions.

Source is available in git at https://git.launchpad.net/pgbouncer-charm.

Bugs should be reported in the Launchpad Bugtracker.