Revisions 639, 640, 641, 642

A new revision of Charmed PgBouncer has been published in the 1/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This section outlines the most important features and bug fixes in this release.

Features

• Updated juju 2 version to v2.9.51 (PR #375)
• Updated juju 3 version to v3.6.1+ (PR#449), (PR #377)
• Retrieve charm tracing libs from tempo_coordinator_k8s (PR #386)
• Relay traces traffic through grafana-agent and test integration with Tempo HA (PR #397)
• Enable round-robin connections to read-only backend nodes (PR #393) (DPE-5613)

Bug fixes

• General secrets resetting fix for Juju 3.6+ (PR#449)[DPE-6320][DPE-6325]
• PgBouncer COS dashboard bugfixes (PR#438)
• Make tox commands resilient to whitespace paths (PR #413) (DPE-6042)
• Fixed missing IP errors (PR #353)
• Don't set secrets until db is set (PR #373) (DPE-5564)
• Increased ruff rules (PR #390)
• Disabled conflicting build (PR #371)
• Stopped tracking channel for held snaps (PR #384)
• Handle secret permission error (PR #358)

Full Changelog: rev394...rev639

Requirements and compatibility

See the system requirements for more details about Juju versions and other software and hardware prerequisites.

Packaging

This charm is based on the Charmed PgBouncer snap . It packages:

• pgbouncer v.1.21
• prometheus-pgbouncer-exporter v.0.7.0

See the /lib/charms directory on GitHub for more details about all supported libraries.

See the metadata.yaml file on GitHub for a full list of supported interfaces.

Revisions 394, 395, 396, 397

A new revision of Charmed PgBouncer has been published in the 1/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This section outlines the most important features and bug fixes in this release.

Features

• Added HA cluster interface (PR #317) (DPE-4066)
• Added URI to relation data (improves UX) (PR #324) (DPE-4683)
• Add Unix socket access for principal charm (including strict SNAPs) (PR #337) (DPE-4683)

Bug fixes and maintenance

• Use poetry package-mode=false (PR #308)
• Switched test app interface (PR #310)
• Bumped data_interface and tempo libs (PR #318)
• Removed no longer necessary locales dependency (PR #328)
• Moved scheduled tests (PR #297)
• Shortened integration test job name (PR #292)

Full Changelog: rev278...rev394

Technical details

• If you are jumping over several stable revisions, check previous release notes before upgrading.
• See the system requirements page for more details about software and hardware prerequisites.

Packaging

This charm is based on the CharmedPgBouncer snap Revision 15/16 . It packages:

• pgbouncer v.1.21
• prometheus-pgbouncer-exporter v.0.7.0

Libraries and interfaces

This charm revision imports the following libraries:

• grafana_agent v0 for integration with Grafana
  • Implements cos_agent interface
• rolling_ops v0 for rolling operations across units
  • Implements rolling_op interface
• tempo_k8s v1, v2 for integration with Tempo charm
  • Implements tracing interface
• tls_certificates_interface v2 for integration with TLS charms
  • Implements tls-certificates interface

See the /lib/charms directory on GitHub for more details about all supported libraries.

See the metadata.yaml file on GitHub for a full list of supported interfaces.

Revisions 278, 279, 280, 281

A new revision of Charmed PgBouncer has been published in the 1/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This release contains no new features; only fixes.

Bug fixes

• [DPE-4772] Scaled up client should join the DB only when the subordinate is ready in #274
• [DPE-4811] Run CI on 3.4.4 in #283
• [DPE-4816] Add jinja2 as a dependency in #276
• [MISC] Suppress alias creation error in #284
• Test and CI stabilization fixes
• Python dependencies updates

Full Changelog: rev254...rev278

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 the Charmed PgBouncer snap revisions 3 (amd64) and 4 (arm64).
• Subordinate charms support LTS 22.04(jammy) and 20.04(focal) only

Revisions 254, 255, 256, 257

A new revision of Charmed PgBouncer has been published in the 1/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This section outlines the most important features and bug fixes in this release.

Features

• PR #210 - Added support for multiple databases
• PR #238 - Added support for tracing through tempo-k8s

Bug fixes

• PR #227 - Fixed PGB permissions issue when dropping tables after re-relating
• PR #254 - Fixed failure when collecting readonly dbs
• PR #257 - Fixed desync issue with PGB reporting the endpoint and credential of the database before being able to serve.
• PR #268 - Fixed upgrade bugs when switching charms

Full Changelog: rev173...rev254

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”
• Subordinate charms support LTS 22.04(jammy) and 20.04(focal) only
• VM charms based on the Charmed PgBouncer snap revisions 3 (amd64) and 4 (arm64).

Note

This release of the PgBouncer charm uses the new charmed-pgbouncer snap. In previous releases, it was based on the charmed-postgresql snap.

Upgrading will automatically switch the snaps.

Technical notes

• Check PgBouncer's system 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 us

Charmed PgBouncer is an open source project that warmly welcomes community contributions, suggestions, fixes, and constructive feedback.

• Raise software issues or feature requests on GitHub
• Report security issues through Launchpad
• Contact the Canonical Data Platform team through our Matrix channel.

Revisions 173, 174, 175, 176

A new revision of Charmed PgBouncer has been published in the 1/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This section outlines the most important features and bug fixes in this release.

Features

• New ARM support! [#196]
• Exposure of all endpoints via data-integrator [#137][DPE-3451]
• Add TLS support [#137][DPE-3452]
• All the functionality from previous revisions

Bug fixes

• [DPE-4221] Recreate auth_query on backend rerelation in #224
• [DPE-4202] data_platform_libs update in #207
• [DPE-3658] Add subordinate charms test in #195
• [DPE-3050] Template config in #159
• [DPE-3602] Fixed charm restart in #155
• [DPE-3535] Rerender config from secrets during upgrade in #150
• [DPE-3184] Update secrets implementation in #145
• [MISC] Fix secret keys in #148
• [MISC] Update Charmed PostgreSQL SNAP in #222

Full Changelog: rev88...rev173

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.4) revision 113
• Subordinate charms support LTS 22.04 and 20.04 only

Technical notes

• Upgrade via juju refresh is possible from revision 81+.
• 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

See the system requirements for more details about Juju versions and other software and hardware prerequisites.

Contact us

Charmed PgBouncer is an open source project that warmly welcomes community contributions, suggestions, fixes, and constructive feedback.

• Raise software issues or feature requests on GitHub
• Report security issues through Launchpad
• Contact the Canonical Data Platform team through our Matrix channel.

Revisions 88, 89

A new revision of Charmed PgBouncer has been published in the 1/stable channel.

See also: Releases overview page, How to perform an upgrade

What's changed

This section outlines the most important highlights, features and bug fixes in this release.

Highlights

• 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)

Minor features

• 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)

Bug fixes

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.

Full Changelog: rev80...rev88

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

See the system requirements for more details about Juju versions and other software and hardware prerequisites.

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.

Revisions 80, 81

A new revision of Charmed PgBouncer has been published in the 1/stable channel.

See also: Releases overview page, How to perform an upgrade

Highlights

• PgBouncer is updated from 1.18 to 1.21 [DPE-3040]
• Updated Python library dependencies [GH PR#158]

Bug fixes

• Juju Secrets fixes provided by updated data Interfaces library (LIBPATCH 24)
• Ported K8s fix for GitHub Issue #166 to VM charm [DPE-3113]

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.

Full Changelog: rev76...rev80

What is 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 the revision 85 to the revision 89)
• Principal charms support the latest LTS series “22.04” only
• Subordinate charms support LTS “22.04” and “20.04” only

Technical notes

• Upgrade (juju refresh) is possible from this revision 76+
• Please check the external components requirements
• Use this operator together with a modern operator "Charmed PostgreSQL"

How to reach us

If you would like to chat with us about your use-cases or ideas, you can reach us at Canonical Mattermost public channel or Discourse. Check all other contact details here.

Consider opening a GitHub issue if you want to open a bug report.
Contribute to the project!

Revisions 76, 77

The first stable revision of Charmed PgBouncer has been published in the 1/stable channel.

See also: Releases overview page, How to perform an upgrade

Highlights

• Add Juju 3 support (Juju 2 is still supported) [DPE-1761]
• Juju peer and relation secrets support [DPE-1765][DPE-2299]
• Charm minor upgrades and minor rollbacks [DPE-1770]
• "Charmed PostgreSQL" extensions support [DPE-2055]
• COS support [DPE-1778]
• Logs rotation [DPE-1757]
• The "data-integrator" support
• Support for modern postgresql_client, legacy pgsql and tls-certificates interfaces
• Workload updated to PgBouncer 1.18 (fixes for PostgreSQL 14)
• Complete documentation on CharmHub

What is inside the charms

• Charmed PgBouncer ships the latest PgBouncer “1.18.0-0ubuntu0.22.04.1”
• 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)
• Principal charms supports the latest LTS series “22.04” only.
• Subordinate charms support LTS “22.04” and “20.04” only.

Technical notes

• Upgrade (juju refresh) is possible from this revision 77+.
• Please check the external components requirements
• Use this operator together with a modern operator "Charmed PostgreSQL".

How to reach us

If you would like to chat with us about your use-cases or ideas, you can reach us at Canonical Mattermost public channel or Discourse. Check all other contact details here.

Consider opening a GitHub issue if you want to open a bug report.
Contribute to the project!