Skip to content

Releases: canonical/postgresql-operator

Revisions 552, 553

13 Feb 11:54
@carlcsaposs-canonical carlcsaposs-canonical
rev552
ac5df63
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revisions 552, 553 Latest
Latest

A new revision of Charmed PostgreSQL has been published in the 14/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

Minor features

  • Several S3 stability improvements (PR #642)
  • Removed patching of private ops class. (PR #617)
  • Switched charm libs from tempo_k8s to tempo_coordinator_k8s and relay tracing traffic through grafana-agent (PR #640)
  • Implemented more meaningful group naming for multi-group tests (PR #625)
  • Ignoring alias error in case alias is already existing (PR #637)
  • Stopped tracking channel for held snaps (PR #638)
  • Added pgBackRest logrotate configuration (PR #645) (DPE-5601)
  • Grant priviledges to non-public schemas (PR #647) (DPE-5387)
  • Added tls and tls-ca fields to databag (PR #666)
  • Merged update_tls_flag into update_endpoints (PR #669)
  • Made tox commands resilient to white-space paths (PR #678) (DPE-6042)
  • Added microceph (local backup) integration test + bump snap version (PR #633) (DPE-5386)
  • Add max_locks_per_transaction config option in (PR#718) (DPE-5533)
  • Split PITR backup test in AWS and GCP (PR #605) (DPE-5181)

Bug fixes

  • Juju secrets resetting fix on Juju 3.6 in (PR#726) (DPE-6320) (DPE-6325)
  • Fallback to trying to create bucket without LocationConstraint in (PR#690)
  • Added warning logs to Patroni reinitialisation (PR #660)
  • Fixed some postgresql.conf parameters for hardening (PR #621) (DPE-5512)
  • Fixed lib check (PR #627)
  • Allow --restore-to-time=latest without a backup-id in (PR#683)
  • Clean-up duplicated Patroni config reloads in (PR#682)
  • Filter out degraded read only endpoints in (PR#679) (DPE-5714)
  • remove clutter from singlestat panels in cos (PR#702)
  • Catch wrong parameters exception on bucket create function call (PR#701) (DPE-5713)
  • Split topology script (PR#729) (DPE-6377)
  • Fix typos in COS alert rules (PR#724) (DPE-6171)
  • Add plugins preload libs to regular startup parameters (PR#741) (DPE-6056)

Full Changelog: rev467...rev552

Requirements

The minimum Juju version required to reliably operate all features in this release is v3.4.3.

The recommended Juju version for this charm is v3.6.1+.

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

Assets 2
Loading

Revisions 467, 468

18 Sep 12:56
@github-actions github-actions
rev467
5d05a9e
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revisions 467, 468

A new revision of Charmed PostgreSQL has been published in the 14/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

Minor features

Bug fixes

Full Changelog: rev429...rev467

Known limitations

Requirements

The minimum Juju version required to reliably operate all features in this release is v3.4.3+.

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

Loading

Revisions 429, 430

29 Jun 00:00
@github-actions github-actions
rev429
3e4c39b
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revisions 429, 430

A new revision of Charmed PostgreSQL has been published in the 14/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

Minor features

  • Added timescaledb plugin/extension (PR#470)
    • See the Configuration tab for a full list of supported plugins/extensions
  • Added incremental and differential backup support (PR #479) (DPE-4462)
  • Added support for disabling the operator (PR#412) (DPE-2469)
  • Added support for subordination with:
  • Added configuration option for backup retention time (PR#474)(DPE-4401)
  • Added experimental_max_connections config option (PR#472)
  • Added check for replicas encrypted connection (PR#437)

Bug fixes

  • Fixed slow charm bootstrap time (PR#413)
  • Fixed large objects ownership (PR#349)
  • Fixed secrets crash for "certificates-relation-changed" after the refresh (PR#475)
  • Fixed network cut tests (PR#346) (DPE-3257)

Full Changelog: rev363...rev429

Requirements

The minimum Juju version required to reliably operate all features in this release is v3.4.2+.

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

Packaging

This charm is based on the charmed-postgresql snap (pinned revision 113). It packages:

Loading

Revision 363

23 Feb 01:55
@github-actions github-actions
rev363
cc14fb8
This commit was created on GitHub.com and signed with GitHub’s verified signature.
GPG key ID: B5690EEEBB952194
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revision 363

A new revision of Charmed PostgreSQL has been published in the 14/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

Minor features

  • [CORE] Juju 3.1.7+ support (#2037120)
  • [PLUGINS] pgVector extension/plugin (DPE-3159)
  • [PLUGINS] New PostGIS plugin (#312)
  • [PLUGINS] More new plugins - 50 in total

Bug fixes

  • DPE-3199 Stabilized internal Juju secrets management
  • DPE-3258 Check system identifier in stanza (backups setup stabilization)

Full Changelog: rev351...rev363

Packaging

  • Charmed PostgreSQL ships the latest PostgreSQL 14.10-0ubuntu0.22.04.1
  • PostgreSQL cluster manager Patroni updated to v.3.1.2
  • Backup tools pgBackRest updated to v.2.48
  • The Prometheus postgres-exporter is 0.12.1-0ubuntu0.22.04.1~ppa1
  • VM charms based on Charmed PostgreSQL SNAP (Ubuntu LTS 22.04 - ubuntu:22.04-based) revision 96
  • Principal charms supports the latest LTS series 22.04 only
  • Subordinate charms support LTS 22.04 and 20.04 only

Requirements

The minimum Juju version required to reliably operate all features in this release is v3.4.2+.

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

Loading

Revision 351

13 Jan 14:52
@github-actions github-actions
rev351
0d7a03a
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revision 351

A new revision of Charmed PostgreSQL has been published in the 14/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

Minor features

Bug fixes

  • Fixed enabling extensions when new database is created (PR#252)(DPE-2569)
  • Block the charm if the legacy interface requests roles (DPE-3077)

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

Full Changelog: rev336...rev351

Packaging

  • Charmed PostgreSQL ships the latest PostgreSQL “14.9-0ubuntu0.22.04.1”
  • PostgreSQL cluster manager Patroni updated to "3.2.1"
  • Backup tools pgBackRest updated to "2.48"
  • The Prometheus postgres-exporter is "0.12.1-0ubuntu0.22.04.1~ppa1"
  • VM charms based on Charmed PostgreSQL SNAP (Ubuntu LTS “22.04” - ubuntu:22.04-based) revision 89
  • Principal charms supports the latest LTS series “22.04” only
  • Subordinate charms support LTS “22.04” and “20.04” only

Requirements

The minimum Juju version required to reliably operate all features in this release is v3.1.6+.

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

Loading

Revision 336

19 Oct 09:51
@github-actions github-actions
rev336
8706c52
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revision 336

A new revision of Charmed PostgreSQL has been published in the 14/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

Other new features

Bugfixes

  • DPE-1624, DPE-1625 Backup/restore fixes
  • DPE-1926 Remove fallback_application_name field from relation data
  • DPE-1712 Enabled the user to fix network issues and rerun stanza related hooks
  • DPE-2173 Fix allowed units relation data field
  • DPE-2127 Fixed databases access
  • DPE-2341 Populate extensions in unit databag
  • DPE-2218 Update charm libs to get s3 relation fix
  • DPE-1210, DPE-2330, DPE-2212 Open port (ability to expose charm)
  • DPE-2614 Split stanza create and stanza check
  • DPE-2721 Allow network access for pg_dump, pg_dumpall and pg_restore
  • DPE-2717 Copy dashboard changes from K8s and use the correct topology dispatcher
  • [MISC] More resilient topology observer

Canonical Data issues are now public on both Jira and GitHub platforms.

Full Changelog: rev288...rev336

Technical notes

  • juju refresh from the old-stable revision 288 to the current-revision 324 is NOT supported!!! The upgrade functionality is new and supported for revision 324+ only!
  • Please check additionally the previously posted restrictions.
  • Ensure the charm requirements met
  • The minimum Juju version required to reliably operate all features in this release is v3.1.5.

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

Packaging

  • Charmed PostgreSQL ships the latest PostgreSQL “14.9-0ubuntu0.22.04.1”
  • PostgreSQL cluster manager Patroni updated to "3.0.2"
  • Backup tools pgBackRest updated to "2.47"
  • The Prometheus postgres-exporter is "0.12.1-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.

Contact us

Charmed PostgreSQL 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.
Loading

Revision 288

20 Apr 22:42
@github-actions github-actions
rev288
92d461e
This commit was created on GitHub.com and signed with GitHub’s verified signature. The key has expired.
GPG key ID: 4AEE18F83AFDEB23
Expired
Verified
Learn about vigilant mode.
Compare
Choose a tag to compare
Revision 288

The first stable revision of Charmed PostgreSQL operator for machines has been published in the 14/stable channel.

See also: Releases overview page

Highlights

  • Deploying on VM (tested with LXD, MAAS)
  • Scaling up/down in one simple juju command
  • HA using Patroni
  • Full backups and restores are supported when using any S3-compatible storage
  • TLS support (using “tls-certificates” operator)
  • DB access outside of Juju using “data-integrator”
  • Data import using standard tools e.g. “psql”.

Full Changelog: https://github.com/canonical/postgresql-operator/commits/rev288

Inside the charms

  • Charmed PostgreSQL charm ships the latest PostgreSQL “14.7-0ubuntu0.22.04.1”
  • VM charms based on our SNAP (Ubuntu LTS “22.04” - core22-based)
  • Principal charms supports the latest LTS series “22.04” only.
  • Subordinate charms support LTS “22.04” and “20.04” only.

Technical notes

  • The new PostgreSQL charm is also a juju interface-compatible replacement for legacy PostgreSQL charms (using legacy interface pgsql, via endpoints db and db-admin).
    However, it is highly recommended to migrate to the modern interface postgresql_client (endpoint database).
    • Please contact us if you are considering migrating from other “legacy” charms not mentioned above.
  • Charmed PostgreSQL follows SNAP track “14”.
  • No “latest” track in use (no surprises in tracking “latest/stable”)!
    • PostgreSQL charm provide legacy charm through “latest/stable”.
  • You can find charm lifecycle flowchart diagrams here.
  • Modern interfaces are well described in the Interfaces catalogue and implemented by data-platform-libs.
  • Known limitation: PostgreSQL extensions are not yet supported.

Contact us

Charmed PostgreSQL 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!

Requirements

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

Loading