postgresql-k8s-operator/metadata.yaml at 5c36df8ad365563df8973e9646c687a6722ce054 · canonical/postgresql-k8s-operator · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
# Copyright 2023 Canonical Ltd.
# See LICENSE file for licensing details.

name: postgresql-k8s
display-name: Charmed PostgreSQL K8s
summary: Charmed PostgreSQL 16 for Kubernetes
description: |
   PostgreSQL is an open-source relational database management system
   built to handle a wide range of workloads. This charmed operator deploys
   and operates PostgreSQL on Kubernetes.

   For deployment on virtual machines, see [Charmed PostgreSQL VM](https://charmhub.io/postgresql).

   To learn more about how to deploy and manage this charm, see the
   [official documentation](https://canonical-charmed-postgresql-k8s.readthedocs-hosted.com/16/).
docs: https://canonical-charmed-postgresql-k8s.readthedocs-hosted.com/16/
source: https://github.com/canonical/postgresql-k8s-operator
issues: https://github.com/canonical/postgresql-k8s-operator/issues
website:
  - https://ubuntu.com/data/postgresql
  - https://charmhub.io/postgresql-k8s
  - https://github.com/canonical/postgresql-k8s-operator
  - https://chat.charmhub.io/charmhub/channels/data-platform
maintainers:
  - Canonical Data Platform <data-platform@lists.launchpad.net>

containers:
  postgresql:
    resource: postgresql-image
    mounts:
      - storage: archive
        location: /var/lib/pg/archive
      - storage: data
        location: /var/lib/pg/data
      - storage: logs
        location: /var/lib/pg/logs
      - storage: temp
        location: /var/lib/pg/temp

resources:
  postgresql-image:
    type: oci-image
    description: OCI image for PostgreSQL
    upstream-source: ghcr.io/canonical/charmed-postgresql@sha256:840100acce8597fe94f1ba5a4d8599a50d4acc9b351d9ec146d9ebb6099e5aa9  # renovate: oci-image tag: 16.11-24.04_edge

peers:
  database-peers:
    interface: postgresql_peers
  refresh-v-three:
    interface: refresh
  restart:
    interface: rolling_op

provides:
  replication-offer:
    interface: postgresql_async
    limit: 1
    optional: true
#   logical-replication-offer:
#     interface: postgresql_logical_replication
#     optional: true
  database:
    interface: postgresql_client
  metrics-endpoint:
    interface: prometheus_scrape
    optional: true
  grafana-dashboard:
    interface: grafana_dashboard
    optional: true

requires:
  replication:
    interface: postgresql_async
    limit: 1
    optional: true
#   logical-replication:
#     interface: postgresql_logical_replication
#     limit: 1
#     optional: true
  peer-certificates:
    interface: tls-certificates
    limit: 1
    optional: true
  client-certificates:
    interface: tls-certificates
    limit: 1
    optional: true
  receive-ca-cert:
    interface: certificate_transfer
    optional: true
  s3-parameters:
    interface: s3
    limit: 1
    optional: true
  ldap:
    interface: ldap
    limit: 1
    optional: true
  logging:
    interface: loki_push_api
    limit: 1
    optional: true
  tracing:
    interface: tracing
    limit: 1
    optional: true

storage:
  archive:
    type: filesystem
    description: Storage mount used for holding local backups (before typically sending them to remote object storage) when relevant/needed.
    location: /var/lib/pg/archive
  data:
    type: filesystem
    description: Storage mount used for storing all tables, indexes, and so on (except those from temporary tablespaces).
    location: /var/lib/pg/data
  logs:
    type: filesystem
    description: Storage mount used for storing all the logs that are part of the transactional commit path (WAL files).
    location: /var/lib/pg/logs
  temp:
    type: filesystem
    description: Storage mount used for storing temporary tablespaces (where typically sort operations happen).
    location: /var/lib/pg/temp

assumes:
  - k8s-api
  - any-of:
      - all-of:
          - juju >= 3.4.3
          - juju < 3.5
      - all-of:
          - juju >= 3.5.1
          - juju < 4