Charmed PostgreSQL VM

Channel Revision Published Runs on
latest/stable 345 09 Nov 2023
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable 239 09 Feb 2022
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
latest/stable 226 01 Apr 2021
Ubuntu 22.04 Ubuntu 20.04 Ubuntu 18.04 Ubuntu 16.04 Ubuntu 14.04
14/stable 430 28 Jun 2024
Ubuntu 22.04
14/stable 429 28 Jun 2024
Ubuntu 22.04
14/candidate 429 26 Jun 2024
Ubuntu 22.04
14/candidate 430 26 Jun 2024
Ubuntu 22.04
14/beta 430 26 Jun 2024
Ubuntu 22.04
14/beta 429 26 Jun 2024
Ubuntu 22.04
14/edge 436 10 Jul 2024
Ubuntu 22.04
14/edge 435 10 Jul 2024
Ubuntu 22.04
juju deploy postgresql --channel 14/stable
Show information

Platform:

Ubuntu
22.04 20.04 18.04 16.04 14.04

Charm Statuses Explanations

WARNING : it is an work-in-progress article. Do NOT use it in production! Contact Canonical Data Platform team if you are interested in the topic.

The charm follows standard Juju applications statuses. Here you can find the expected end-users reaction on different statuses:

Juju Status Message Expectations Actions
active any Normal charm operations No actions required
waiting any Charm is waiting for relations to be finished No actions required
maintenance any Charm is performing the internal maintenance (e.g. cluster re-configuration, upgrade, …) No actions required
blocked failed to update cluster members on member TODO: error/retry?
blocked failed to install snap packages There are issues with the network connection and/or the Snap Store Check your internet connection and https://status.snapcraft.io/. Remove the application and when everything is ok, deploy the charm again
blocked failed to patch snap seccomp profile The charm failed to patch one issue that happens when pgBackRest restores a backup (this blocked status should be removed when https://github.com/pgbackrest/pgbackrest/releases/tag/release%2F2.46 is added to the snap) Remove the unit and add it back again
blocked failed to set up postgresql_exporter options The charm failed to set up the metrics exporter Remove the unit and add it back again
blocked failed to start Patroni TODO: error/retry?
blocked Failed to create postgres user The charm couldn’t create the default postgres database user due to connection problems Connect to the database using the operator user and the password from the get-password action, then run CREATE ROLE postgres WITH LOGIN SUPERUSER;
blocked Failed to restore backup The database couldn’t start after the restore The charm needs fix in the code to recover from this status and enable a new restore to be requested
error any An unhanded internal error happened Read the message hint. Execute juju resolve <error_unit/0> after addressing the root of the error state
terminated any The unit is gone and will be cleaned by Juju soon No actions possible
unknown any Juju doesn’t know the charm app/unit status. Possible reason: K8s charm termination in progress. Manual investigation required if status is permanent

Help improve this document in the forum (guidelines). Last updated 9 months ago.