canonical/postgresql-operator

A Charmed Operator for running PostgreSQL on machines

Stars: 20
Forks: 36
Open beginner issues: 0
Indexed issues: 108
Avg merge: 4d 15h
Merged PRs (30d): 30

Dominant language: Python
License: Apache-2.0
Last GitHub push: Sep 13, 2026
Latest indexed: Sep 14, 2026
Contributing guide: Contributing guide
Code of conduct: No code of conduct
Beginner labels: good first issue

Open All

108 open issues indexed

Improve blocked status handling Open

canonical/postgresql-operator#9 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Move peer relation code to relations/peers.py Open

canonical/postgresql-operator#24 · 0 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Recover from backup maintaining existing cluster scale Open

enhancement

canonical/postgresql-operator#98 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Dependency Dashboard Open

canonical/postgresql-operator#108 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
hook failed: "certificates-relation-broken" error when removing relation to s3-integrator Open

bug

canonical/postgresql-operator#157 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Improve config options validation Open

bug good first issue

canonical/postgresql-operator#258 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
[RFE] Can we move `_create_bucket_if_not_exists` to the s3 interface? Open

enhancement

canonical/postgresql-operator#309 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Test: scale application to zero units Open

bug

canonical/postgresql-operator#445 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Provide flexible backup strategy. Charmed PostgreSQL 14 provides only manual AWS S3 and Ceph Rados GW backups. Open

enhancement

canonical/postgresql-operator#448 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Blocking the use of different versions of Postgres Open

bug

canonical/postgresql-operator#457 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Test charm recovery after instance restart. Open

bug

canonical/postgresql-operator#459 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Monitoring user Open

bug

canonical/postgresql-operator#499 · 6 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Patroni logs with grafana-agent causing a lot of unrelease file and huge syslog Open

bug

canonical/postgresql-operator#524 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Add Juju 2 to Juju 3 migration test Open

bug

canonical/postgresql-operator#532 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
The charm allows a 2-node cluster but it's not functional after a failover Open

bug

canonical/postgresql-operator#570 · 6 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
The charm cannot recover from a quorum loss event of 3-node cluster Open

bug

canonical/postgresql-operator#571 · 7 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
The cluster stops functioning after replacing a failed unit then another unit failed Open

bug

canonical/postgresql-operator#573 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Temporary error message: hook failed: "start" on VM recovery Open

bug

canonical/postgresql-operator#618 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
No logging or compaction enabled for logs in snap internal /var/log/ folders Open

enhancement

canonical/postgresql-operator#653 · 6 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
COS Integration / Patroni dashboard showing two leaders Open

bug

canonical/postgresql-operator#657 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
COS Integration / Alert PostgresqlConfigurationChanged in error state Open

bug

canonical/postgresql-operator#658 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Support for local backups Open

enhancement

canonical/postgresql-operator#665 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Add ability to configure external DCS Open

canonical/postgresql-operator#671 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
"database-peers-relation-broken" 'NoneType' object has no attribute 'data' Open

bug

canonical/postgresql-operator#691 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
The `admin` `extra-user-role` via `data-integrator` doesn't allow creating roles Open

enhancement

canonical/postgresql-operator#698 · 9 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Running list-backups actions shortly after relation with s3-integrator results in IndexError Open

bug good first issue

canonical/postgresql-operator#699 · 2 comments · 1 reaction · 0 assignees · Indexed Sep 14, 2026
PostgreSQL cluster split-brain when network in unstable Open

bug

canonical/postgresql-operator#712 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Allow create-backup on non-primary even when no TLS configured Open

bug

canonical/postgresql-operator#716 · 4 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
use tracing through cos-agent Open

bug

canonical/postgresql-operator#717 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
After postgresql restore, and deleting old backup from S3 container, postgresql/leader remains blocked with `Move restored cluster to another S3 bucket` Open

bug

canonical/postgresql-operator#733 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Adding a new unit in an existing cluster does not work - Postgres 14.11 rev 384 Open

bug

canonical/postgresql-operator#735 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Change default postgresql logs files naming Open

bug

canonical/postgresql-operator#736 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
logging scheme makes no sense Open

enhancement

canonical/postgresql-operator#779 · 10 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Cannot deploy more than 10 units (max_wal_senders limit) Open

bug

canonical/postgresql-operator#801 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
upgrade 14/stable from r429 to r553 fails with PostgreSQLEnableDisableExtensionError Open

bug

canonical/postgresql-operator#803 · 8 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Feature request: please add actions for standard operations for model-driven operations Open

canonical/postgresql-operator#848 · 3 comments · 1 reaction · 0 assignees · Indexed Sep 14, 2026
extra-user-roles=admin does not grant "CREATE USER" privileges Open

bug

canonical/postgresql-operator#864 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Support for exposing endpoints and simplified single-VM deployment in PostgreSQL Terraform module Open

bug

canonical/postgresql-operator#911 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Postgresql Cluster failed to start on Dual stack network if the IPv4 subnet is from a private address space (IPv6 is then prefered) Open

bug

canonical/postgresql-operator#922 · 6 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
operator user shouldn't be used by ldap component to connect to postgresql Open

canonical/postgresql-operator#966 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
archive volume usage Open

bug

canonical/postgresql-operator#967 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
[PostgreSQL][VM][16] patroni doesn't start on unit reboot IF charm was in blocked state Open

bug

canonical/postgresql-operator#986 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Investigate and remove workaround for single `pg_wal` in data directory when setting up async replication. Open

canonical/postgresql-operator#989 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 14, 2026
Apply Ops tutorial update to docs Open

documentation

canonical/postgresql-operator#1005 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Validate merge Terraform module improvement Open

bug

canonical/postgresql-operator#1039 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Cannot have backups when using s3-integrator 2/edge Open

bug

canonical/postgresql-operator#1043 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
invalid role(s) for extra user roles (admin) Open

bug

canonical/postgresql-operator#1059 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Failed to start Service for snap application charmed-postgresql.prometheus-postgres-exporter Open

bug

canonical/postgresql-operator#1081 · 10 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Logical replication creates infinite loop of inserts Open

bug

canonical/postgresql-operator#1085 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 14, 2026
Add ability to configure TTL, Retry threshold parameters for leader election in Patroni Open

bug

canonical/postgresql-operator#1164 · 7 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026

A short digest of beginner-friendly GitHub issues.