PgBouncer Revision 88/89

_{February 21, 2024}

Dear community, we are excited to announce that the new Charmed PgBouncer operator is published in the 1/stable charmhub channel for IAAS/VM.

The PgBouncer charm releases multiple revisions simultaneously:

• Revision 88 is built for amd64 on Ubuntu 22.04 LTS
• Revision 89 is built for amd64 on Ubuntu 20.04 LTS

New features

• Juju 3.1.7 support (changes to Juju secrets)
• Charmed PostgreSQL snap updated from revision 89 to the revision 98
• Updated Python library dependencies (#128)

Bugfixes

Canonical Data issues are now public on both Jira and GitHub platforms. GitHub Releases provide a detailed list of bugfixes/PRs/commits for each revision.

Highlights for the current revision

• Removed binary python dependencies and build psycopg from source (#128)
• GH Action migrated to data platform shared workflows
• Juju Secrets fixes provided by updated data Interfaces library (LIBPATCH 25)

Inside the charms

• Charmed PgBouncer ships the latest PgBouncer 1.21.0-0ubuntu0.22.04.1~ppa1
• The Prometheus pgbouncer-exporter is “0.7.0-0ubuntu0.22.04.1~ppa1”
• VM charms based on Charmed PostgreSQL SNAP (Ubuntu LTS 22.04 - ubuntu:22.04-based) (updated from revision 89 to 98)
• Principal charms support the latest LTS series 22.04 only
• Subordinate charms support LTS 22.04 and 20.04 only

Technical notes

• Upgrade via juju refresh is possible from revision 81+.
• Please check the external components requirements
• Note: juju 3.1.6 doesn’t report when pre-upgrade-check action fails. Therefore, it is recommended to redeploy pgbouncer charm on Juju 3.1.7+
• Use this operator together with the Charmed PostgreSQL operator

Contact

Open a GitHub issue if you want to submit a bug report, or contribute to the project!

Check our Contacts page for more ways to reach us.