--- title: Charmhub | Deploy PgBouncer using Charmhub - The Open Operator Collection description: Deploy the latest version of PgBouncer on any cloud. url: https://charmhub.io/pgbouncer/docs/h-admin-console --- # PgBouncer [Canonical](https://charmhub.io/publisher/data-platform "View all packages from Canonical") * [Canonical](https://charmhub.io/publisher/data-platform "View all packages from Canonical") * [Databases](https://charmhub.io/?filter=databases) Platform: 24.04 22.04 20.04 18.04 16.04 1/stable 1092 ``` juju deploy pgbouncer --channel 1/stable ``` [Learn to deploy on juju >](https://juju.is/docs/juju/manage-applications) --- #### Relevant links * [Homepage](https://ubuntu.com/data/postgresql) --- #### Contacts ##### Maintainers + [Canonical Data Platform](mailto:data-platform@lists.launchpad.net) * [Submit a bug](https://github.com/canonical/pgbouncer-operator/issues) --- Share your thoughts on this charm with the community on discourse. [Join the discussion](https://discourse.charmhub.io/) # How to access the PgBouncer admin console This guide demonstrates how to access the [PgBouncer admin console](https://www.pgbouncer.org/usage.html#admin-console) when integrated with PostgreSQL and the data-integrator charm. ## [Reveal the admin user credentials](https://charmhub.io/pgbouncer/docs/h-admin-console#p-41272-reveal-the-admin-user-credentials) Find the Juju secret ID: ``` $ SECRET_ID=$(juju secrets --format=json | jq -r 'to_entries[] | select(.value.label == "pgb-peers.pgbouncer.app") | .key') ``` > If your PgBouncer app was deployed with a different name, make sure to modify the label to `"pgb-peers..app"` Reveal the password: ``` $ juju show-secret --reveal $SECRET_ID --format=json | jq -r '.[].content.Data["admin-password"]' ``` ## [Connect to the internal PgBouncer database](https://charmhub.io/pgbouncer/docs/h-admin-console#p-41272-connect-to-the-internal-pgbouncer-database) Connect using `psql` with the following URI format: ``` psql postgresql://pgbouncer_admin_:@:/pgbouncer ``` Note that The PgBouncer database will always be called `pgbouncer` and the admin username will follow the pattern of `pgbouncer_admin_{pgbouncer app name}` Example: ``` $ juju status Model Controller Cloud/Region Version SLA Timestamp admin-console localhost-localhost localhost/localhost 3.6.14 unsupported 14:41:41+02:00 App Version Status Scale Charm Channel Rev Exposed Message data-integrator active 1 data-integrator latest/edge 368 no pgbouncer active 1 pgbouncer 1/edge 900 no postgresql 16.11 active 1 postgresql 16/edge 1031 no Unit Workload Agent Machine Public address Ports Message data-integrator/0* active idle 1 10.7.41.82 pgbouncer/0* active idle 10.7.41.82 6432/tcp postgresql/0* active idle 0 10.7.41.101 5432/tcp Primary ``` ``` $ psql postgresql://pgbouncer_admin_pgbouncer:XHDgj1d3ZRn9egRWoCS9QH7N@10.7.41.82:6432/pgbouncer psql (18.2, server 1.21.0/bouncer) WARNING: psql major version 18, server major version 1.21. Some psql features might not work. Type "help" for help. pgbouncer=# show stats; database | total_xact_count | total_query_count | total_received | total_sent | total_xact_time | total_ query_time | total_wait_time | avg_xact_count | avg_query_count | avg_recv | avg_sent | avg_xact_time | av g_query_time | avg_wait_time -----------+------------------+-------------------+----------------+------------+-----------------+------- -----------+-----------------+----------------+-----------------+----------+----------+---------------+--- -------------+--------------- pgbouncer | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 testdb1 | 0 | 0 | 0 | 419 | 0 | 0 | 64884 | 0 | 0 | 0 | 0 | 0 | 0 | 0 (2 rows) ``` ---