Pgbouncer
- By PostgreSQL Charm Maintainers
- Databases
juju deploy pgbouncer
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
| Channel | Version | Revision | Published | Runs on |
|---|---|---|---|---|
| latest/stable | 3 | 3 | 29 Jul 2021 | |
| latest/edge | 3 | 3 | 29 Jul 2021 |
Platform:
About
Lightweight connection pooler for PostgreSQL. Read more
Relevant links
Discuss this charm
Share your thoughts on this charm with the community on discourse.
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.