You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
113 lines
2.5 KiB
113 lines
2.5 KiB
# Source: postgrescluster/templates/postgres.yaml
|
|
apiVersion: postgres-operator.crunchydata.com/v1beta1
|
|
kind: PostgresCluster
|
|
metadata:
|
|
name: pg-pitr
|
|
spec:
|
|
dataSource:
|
|
postgresCluster:
|
|
clusterName: pg
|
|
repoName: repo1
|
|
options:
|
|
- --type=time
|
|
- --target="2023-05-26 12:59:13-05"
|
|
postgresVersion: 14
|
|
instances:
|
|
- name: "instance1"
|
|
replicas: 1
|
|
dataVolumeClaimSpec:
|
|
storageClassName: longhorn-ssdnodes-seattle
|
|
accessModes:
|
|
- "ReadWriteOnce"
|
|
resources:
|
|
requests:
|
|
storage: "240Gi"
|
|
resources:
|
|
limits:
|
|
cpu: "1000m"
|
|
memory: "2Gi"
|
|
affinity:
|
|
nodeAffinity:
|
|
requiredDuringSchedulingIgnoredDuringExecution:
|
|
nodeSelectorTerms:
|
|
- matchExpressions:
|
|
- key: sapian-k3s-role
|
|
operator: In
|
|
values:
|
|
- agent
|
|
- key: sapian-agent-dc
|
|
operator: In
|
|
values:
|
|
- ssdnodes-seattle
|
|
backups:
|
|
pgbackrest:
|
|
configuration:
|
|
- secret:
|
|
name: pg-pgbackrest-secret
|
|
global:
|
|
repo2-path: /pgbackrest/dbs/pg/repo2
|
|
repos:
|
|
- name: repo1
|
|
volume:
|
|
volumeClaimSpec:
|
|
storageClassName: longhorn-ssdnodes-seattle
|
|
accessModes:
|
|
- "ReadWriteOnce"
|
|
resources:
|
|
requests:
|
|
storage: "200Gi"
|
|
- name: repo2
|
|
s3:
|
|
bucket: "postgres-k3s-sapian-cloud"
|
|
endpoint: "s3.us-east-1.amazonaws.com"
|
|
region: "us-east-1"
|
|
monitoring:
|
|
pgmonitor:
|
|
exporter:
|
|
image: registry.developers.crunchydata.com/crunchydata/crunchy-postgres-exporter:ubi8-5.2.0-0
|
|
users:
|
|
- databases:
|
|
- arpagon
|
|
name: arpagon
|
|
options: SUPERUSER
|
|
- databases:
|
|
- sapian
|
|
name: sapian
|
|
options: SUPERUSER
|
|
- databases:
|
|
- foreman
|
|
name: foreman
|
|
- databases:
|
|
- keycloak
|
|
name: keycloak
|
|
- databases:
|
|
- gitea
|
|
name: gitea
|
|
- databases:
|
|
- hedgedoc
|
|
name: hedgedoc
|
|
- databases:
|
|
- matrix
|
|
name: matrix
|
|
- databases:
|
|
- matrix-slack
|
|
name: matrix-slack
|
|
- databases:
|
|
- ncdroe
|
|
name: ncdroe
|
|
- databases:
|
|
- pg
|
|
name: pg
|
|
- databases:
|
|
- postgres
|
|
name: postgres
|
|
- databases:
|
|
- gogs
|
|
name: gogs
|
|
openshift: false
|
|
patroni:
|
|
dynamicConfiguration:
|
|
postgresql:
|
|
pg_hba:
|
|
- "hostnossl all all all md5"
|