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

Expose a additional PG config options via juju config Open

canonical/postgresql-operator#1170 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
TLS Documentation for PostgreSQL 16 mentions old certificates interface Open

documentation

canonical/postgresql-operator#1209 · 2 comments · 0 reactions · 1 assignee · Indexed Sep 14, 2026
doc: no explanation about peer-certificates relation Open

bug

canonical/postgresql-operator#1226 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 14, 2026
Update CONTRIBUTING.md with documentation details Open

documentation

canonical/postgresql-operator#1228 · 1 comment · 0 reactions · 1 assignee · Indexed Sep 14, 2026
Update mentions of deprecated TLS certificates (14 & 16) Open

documentation

canonical/postgresql-operator#1229 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Update documentation relevant to the single kernel library Open

documentation

canonical/postgresql-operator#1230 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
`/var/log/rotate_logs.log` not logrotated and is unbounded Open

bug

canonical/postgresql-operator#1259 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Charm does not handle certificates / CSRs without IP identifier support (ACME) Open

enhancement

canonical/postgresql-operator#1261 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Add ability to configure `common_name` and `sans_dns` Open

canonical/postgresql-operator#1276 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
pg_exporter_last_scrape_error returns 1 on replica unit of the standby cluster when async-replication is enabled Open

bug

canonical/postgresql-operator#1290 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 14, 2026
`database-peers` relation missing `tls=enabled` on one unit causes HTTP health checks against HTTPS Patroni API Open

bug

canonical/postgresql-operator#1305 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Update Juju storage documentation for PostgreSQL 16 Open

documentation

canonical/postgresql-operator#1311 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
S3 backups fail on the non-primary site if cross-site replication is enabled with the error message `Stanza was not initialised` Open

bug

canonical/postgresql-operator#1329 · 3 comments · 1 reaction · 0 assignees · Indexed Sep 14, 2026
docs: Improve link to LXD storage pools Open

documentation

canonical/postgresql-operator#1345 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Port pgBackRest archive timeout error check Open

bug

canonical/postgresql-operator#1346 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Add instructions on how to access PostgreSQL 16 with secrets Open

documentation

canonical/postgresql-operator#1349 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Move `--log-level-stderr=warn` to pgBackRest's configuration file Open

bug good first issue

canonical/postgresql-operator#1353 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Patroni DCS issues on leader when a secondary becomes unreachable Open

bug

canonical/postgresql-operator#1358 · 5 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Raise http errors on requests calls where appropriate Open

canonical/postgresql-operator#1418 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Boolean type mismatch causes unnecessary Patroni config reloads during topology changes Open

bug

canonical/postgresql-operator#1419 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Move existing data to a safe place before erasing data directories Open

bug

canonical/postgresql-operator#1445 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 14, 2026
pg_wal filling the filesystem Open

bug

canonical/postgresql-operator#1448 · 9 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
BlockedStatus object compared to string list in S3 block message check Open

canonical/postgresql-operator#1483 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Replica units stuck in permanent bootstrap loop on MicroCloud (EBUSY on Juju storage mount) Open

bug

canonical/postgresql-operator#1510 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
PostgreSQL cluster enters a weird state when a unit changes its IP Open

bug

canonical/postgresql-operator#1528 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
PG16/edge not fully compatible with juju terraform provider v1 specification Open

bug

canonical/postgresql-operator#1539 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Airgapped documentation is outdated on PostgreSQL 16 Open

documentation

canonical/postgresql-operator#1540 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
PgBouncer Exporter dead alerts Open

bug

canonical/postgresql-operator#1565 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Patroni Exporter broken dashboard panels Open

bug

canonical/postgresql-operator#1566 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
PostgreSQL Exporter dead metrics Open

bug

canonical/postgresql-operator#1567 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
docs: document a way to look at the logs Open

canonical/postgresql-operator#1568 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Deployment guide using Terraform is not working - for 14 and 16 Open

bug

canonical/postgresql-operator#1606 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Confusing Async-replication behavior when Primary cluster and Strandby cluster names (juju app names) are the same Open

bug

canonical/postgresql-operator#1665 · 8 comments · 1 reaction · 0 assignees · Indexed Sep 14, 2026
Patroni and health checks proxy handling Open

bug

canonical/postgresql-operator#1714 · 2 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Please document the list of functions added by the operator in the PostgreSQL DB. Open

bug documentation

canonical/postgresql-operator#1722 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 14, 2026
Charm stays blocked: failed to initialize stanza permanently after S3 recovers - no self-healing Open

canonical/postgresql-operator#1724 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Charm does not expose remove_data_directory_on_diverged_timelines - diverged replicas loop forever Open

canonical/postgresql-operator#1728 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Unable to run TimescaleDB retention and aggregation policies, when the timescaleDB extension is enabled. Open

bug

canonical/postgresql-operator#1737 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 14, 2026
Charm relation hooks fail permanently if a user executes DROP SCHEMA public CASCADE Open

bug

canonical/postgresql-operator#1749 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Excessive logging pattern when relating to otel-collector causing very high CPU utilization. Open

bug

canonical/postgresql-operator#1758 · 6 comments · 1 reaction · 0 assignees · Indexed Sep 14, 2026
feat: enhance PostgreSQL Grafana Dashboard Open

canonical/postgresql-operator#1789 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Monitor cross-dc-relation (Feature?) Open

enhancement

canonical/postgresql-operator#1808 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
enhance UX message when trying to deploy data-integrator on non-primary cluster Open

bug

canonical/postgresql-operator#1812 · 1 comment · 1 reaction · 0 assignees · Indexed Sep 14, 2026
`NoneType: None` in juju debug-log Open

bug

canonical/postgresql-operator#1817 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Improve monitoring of Cross-Site-Replication Open

canonical/postgresql-operator#1824 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
`connectivity: "off"` put the charm in a strange state where pg_hba was broken Open

bug

canonical/postgresql-operator#1839 · 2 comments · 1 reaction · 1 assignee · Indexed Sep 14, 2026
Potential unnecessary databag/config file updates Open

canonical/postgresql-operator#1843 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Unexpected exception in Patroni: BlockingIOError: [Errno 11] Resource temporarily unavailable Open

bug

canonical/postgresql-operator#1859 · 3 comments · 0 reactions · 0 assignees · Indexed Sep 14, 2026
Backup and restore between revisions on the transition to the storage refactoring Open

bug

canonical/postgresql-operator#1873 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026
MAAS region DB is read-only because Patroni snap comes up disabled after host reboot, leaving no primary Open

bug

canonical/postgresql-operator#1907 · 1 comment · 0 reactions · 0 assignees · Indexed Sep 14, 2026

A short digest of beginner-friendly GitHub issues.