Pgbouncer

By PostgreSQL Charm Maintainers
Databases

You will need Juju 2.9 to be able to run this command. Learn how to upgrade to Juju 2.9.

Filter by series:

Channel	Version	Base
latest/stable	2	16.04 18.04
latest/edge	2	16.04 18.04

Platform:

16.04 18.04

About

Lightweight connection pooler for PostgreSQL. Read more

Relevant links

Discuss this charm

Share your thoughts on this charm with the community on discourse.

Join the discussion

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 cs:postgresql
juju deploy cs:~postgresql-charmers/pgbouncer
juju deploy cs:~postgresql-charmers/postgresql-client psql

juju add-relation postgresql:db-admin pgbouncer:backend-db-admin
juju add-relation 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 interchangably.

Configuration

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

Monitoring

This charm provides relations that support monitoring via Nagios using cs:nrpe_external_master 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.