Pgbouncer
- By Data Platform
- Databases
Channel | Version | Revision | Published | Runs on |
---|---|---|---|---|
latest/stable | 5 | 5 | 17 Jan 2022 | |
latest/edge | 5 | 5 | 17 Jan 2022 |
juju deploy pgbouncer
You will need Juju 2.9 to be able to run this command. Learn how to upgrade to Juju 2.9.
Deploy universal operators easily with Juju, the Universal Operator Lifecycle Manager.
Platform:
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.