142 lines
2.9 KiB
YAML
142 lines
2.9 KiB
YAML
# Here we use https://github.com/prometheus-community/helm-charts/charts/kube-prometheus-stack
|
|
# Please keep the ServiceMonitor's label same as the Helm release name of kube-prometheus-stack
|
|
|
|
apiVersion: v1
|
|
kind: Namespace
|
|
metadata:
|
|
name: test-pg
|
|
---
|
|
apiVersion: "acid.zalan.do/v1"
|
|
kind: postgresql
|
|
metadata:
|
|
name: acid-minimal-cluster
|
|
namespace: test-pg
|
|
labels:
|
|
app: test-pg
|
|
spec:
|
|
teamId: "acid"
|
|
volume:
|
|
size: 1Gi
|
|
numberOfInstances: 2
|
|
users:
|
|
zalando: # database owner
|
|
- superuser
|
|
- createdb
|
|
foo_user: [] # role for application foo
|
|
databases:
|
|
foo: zalando # dbname: owner
|
|
preparedDatabases:
|
|
bar: {}
|
|
postgresql:
|
|
version: "13"
|
|
sidecars:
|
|
- name: "exporter"
|
|
image: "quay.io/prometheuscommunity/postgres-exporter:v0.15.0"
|
|
ports:
|
|
- name: exporter
|
|
containerPort: 9187
|
|
protocol: TCP
|
|
env:
|
|
- name: DATA_SOURCE_URI
|
|
value: ":5432/?sslmode=disable"
|
|
- name: DATA_SOURCE_USER
|
|
value: "postgres"
|
|
- name: DATA_SOURCE_PASS
|
|
valueFrom:
|
|
secretKeyRef:
|
|
name: postgres.test-pg.credentials.postgresql.acid.zalan.do
|
|
key: password
|
|
resources:
|
|
limits:
|
|
cpu: 500m
|
|
memory: 256M
|
|
requests:
|
|
cpu: 100m
|
|
memory: 200M
|
|
---
|
|
apiVersion: v1
|
|
kind: Service
|
|
metadata:
|
|
name: acid-minimal-cluster-svc-metrics-master
|
|
namespace: test-pg
|
|
labels:
|
|
app: test-pg
|
|
spilo-role: master
|
|
annotations:
|
|
prometheus.io/scrape: "true"
|
|
prometheus.io/port: "9187"
|
|
spec:
|
|
type: ClusterIP
|
|
ports:
|
|
- name: exporter
|
|
port: 9187
|
|
targetPort: exporter
|
|
selector:
|
|
application: spilo
|
|
cluster-name: acid-minimal-cluster
|
|
spilo-role: master
|
|
---
|
|
apiVersion: v1
|
|
kind: Service
|
|
metadata:
|
|
name: acid-minimal-cluster-svc-metrics-replica
|
|
namespace: test-pg
|
|
labels:
|
|
app: test-pg
|
|
spilo-role: replica
|
|
annotations:
|
|
prometheus.io/scrape: "true"
|
|
prometheus.io/port: "9187"
|
|
spec:
|
|
type: ClusterIP
|
|
ports:
|
|
- name: exporter
|
|
port: 9187
|
|
targetPort: exporter
|
|
selector:
|
|
application: spilo
|
|
cluster-name: acid-minimal-cluster
|
|
spilo-role: replica
|
|
---
|
|
apiVersion: monitoring.coreos.com/v1
|
|
kind: ServiceMonitor
|
|
metadata:
|
|
name: acid-minimal-cluster-svcm-master
|
|
namespace: test-pg
|
|
labels:
|
|
app: test-pg
|
|
spilo-role: master
|
|
spec:
|
|
endpoints:
|
|
- port: exporter
|
|
interval: 15s
|
|
scrapeTimeout: 10s
|
|
namespaceSelector:
|
|
matchNames:
|
|
- test-pg
|
|
selector:
|
|
matchLabels:
|
|
app: test-pg
|
|
spilo-role: master
|
|
---
|
|
apiVersion: monitoring.coreos.com/v1
|
|
kind: ServiceMonitor
|
|
metadata:
|
|
name: acid-minimal-cluster-svcm-replica
|
|
namespace: test-pg
|
|
labels:
|
|
app: test-pg
|
|
spilo-role: replica
|
|
spec:
|
|
endpoints:
|
|
- port: exporter
|
|
interval: 15s
|
|
scrapeTimeout: 10s
|
|
namespaceSelector:
|
|
matchNames:
|
|
- test-pg
|
|
selector:
|
|
matchLabels:
|
|
app: test-pg
|
|
spilo-role: replica
|