+++ /dev/null
-apiVersion: {{ template "postgresql.statefulset.apiVersion" . }}
-kind: StatefulSet
-metadata:
- name: {{ template "postgresql.master.fullname" . }}
- labels:
- app: {{ template "postgresql.name" . }}
- chart: {{ template "postgresql.chart" . }}
- release: {{ .Release.Name | quote }}
- heritage: {{ .Release.Service | quote }}
-{{- with .Values.master.labels }}
-{{ toYaml . | indent 4 }}
-{{- end }}
-{{- with .Values.master.annotations }}
- annotations:
-{{ toYaml . | indent 4 }}
-{{- end }}
-spec:
- serviceName: {{ template "postgresql.fullname" . }}-headless
- replicas: 1
- updateStrategy:
- type: {{ .Values.updateStrategy.type }}
- {{- if (eq "Recreate" .Values.updateStrategy.type) }}
- rollingUpdate: null
- {{- end }}
- selector:
- matchLabels:
- app: {{ template "postgresql.name" . }}
- release: {{ .Release.Name | quote }}
- role: master
- template:
- metadata:
- name: {{ template "postgresql.fullname" . }}
- labels:
- app: {{ template "postgresql.name" . }}
- chart: {{ template "postgresql.chart" . }}
- release: {{ .Release.Name | quote }}
- heritage: {{ .Release.Service | quote }}
- role: master
-{{- with .Values.master.podLabels }}
-{{ toYaml . | indent 8 }}
-{{- end }}
-{{- with .Values.master.podAnnotations }}
- annotations:
-{{ toYaml . | indent 8 }}
-{{- end }}
- spec:
- {{- if .Values.schedulerName }}
- schedulerName: "{{ .Values.schedulerName }}"
- {{- end }}
-{{- include "postgresql.imagePullSecrets" . | indent 6 }}
- {{- if .Values.master.nodeSelector }}
- nodeSelector:
-{{ toYaml .Values.master.nodeSelector | indent 8 }}
- {{- end }}
- {{- if .Values.master.affinity }}
- affinity:
-{{ toYaml .Values.master.affinity | indent 8 }}
- {{- end }}
- {{- if .Values.master.tolerations }}
- tolerations:
-{{ toYaml .Values.master.tolerations | indent 8 }}
- {{- end }}
- {{- if .Values.terminationGracePeriodSeconds }}
- terminationGracePeriodSeconds: {{ .Values.terminationGracePeriodSeconds }}
- {{- end }}
- {{- if .Values.securityContext.enabled }}
- securityContext:
- fsGroup: {{ .Values.securityContext.fsGroup }}
- {{- end }}
- {{- if .Values.serviceAccount.enabled }}
- serviceAccountName: {{ default (include "postgresql.fullname" . ) .Values.serviceAccount.name }}
- {{- end }}
- {{- if or .Values.master.extraInitContainers (and .Values.volumePermissions.enabled .Values.persistence.enabled) .Values.shmVolume.enabled }}
- initContainers:
- {{- if or (and .Values.volumePermissions.enabled .Values.persistence.enabled) .Values.shmVolume.enabled }}
- - name: init-chmod-data
- image: {{ template "postgresql.volumePermissions.image" . }}
- imagePullPolicy: "{{ .Values.volumePermissions.image.pullPolicy }}"
- {{- if .Values.resources }}
- resources: {{- toYaml .Values.resources | nindent 12 }}
- {{- end }}
- command:
- - /bin/sh
- - -c
- - |
- mkdir -p {{ .Values.persistence.mountPath }}/data
- chmod 700 {{ .Values.persistence.mountPath }}/data
- find {{ .Values.persistence.mountPath }} -mindepth 0 -maxdepth 1 -not -name ".snapshot" -not -name "lost+found" | \
- xargs chown -R {{ .Values.securityContext.runAsUser }}:{{ .Values.securityContext.fsGroup }}
- {{- if .Values.shmVolume.enabled }}
- chmod -R 777 /dev/shm
- {{- end }}
- securityContext:
- runAsUser: {{ .Values.volumePermissions.securityContext.runAsUser }}
- volumeMounts:
- - name: data
- mountPath: {{ .Values.persistence.mountPath }}
- subPath: {{ .Values.persistence.subPath }}
- {{- if .Values.shmVolume.enabled }}
- - name: dshm
- mountPath: /dev/shm
- {{- end }}
- {{- end }}
- {{- if .Values.master.extraInitContainers }}
-{{ tpl .Values.master.extraInitContainers . | indent 8 }}
- {{- end }}
- {{- end }}
- {{- if .Values.master.priorityClassName }}
- priorityClassName: {{ .Values.master.priorityClassName }}
- {{- end }}
- containers:
- - name: {{ template "postgresql.fullname" . }}
- image: {{ template "postgresql.image" . }}
- imagePullPolicy: "{{ .Values.image.pullPolicy }}"
- {{- if .Values.resources }}
- resources: {{- toYaml .Values.resources | nindent 12 }}
- {{- end }}
- {{- if .Values.securityContext.enabled }}
- securityContext:
- runAsUser: {{ .Values.securityContext.runAsUser }}
- {{- end }}
- env:
- - name: BITNAMI_DEBUG
- value: {{ ternary "true" "false" .Values.image.debug | quote }}
- - name: POSTGRESQL_PORT_NUMBER
- value: "{{ template "postgresql.port" . }}"
- - name: POSTGRESQL_VOLUME_DIR
- value: "{{ .Values.persistence.mountPath }}"
- {{- if .Values.postgresqlInitdbArgs }}
- - name: POSTGRES_INITDB_ARGS
- value: {{ .Values.postgresqlInitdbArgs | quote }}
- {{- end }}
- {{- if .Values.postgresqlInitdbWalDir }}
- - name: POSTGRES_INITDB_WALDIR
- value: {{ .Values.postgresqlInitdbWalDir | quote }}
- {{- end }}
- {{- if .Values.initdbUser }}
- - name: POSTGRESQL_INITSCRIPTS_USERNAME
- value: {{ .Values.initdbUser }}
- {{- end }}
- {{- if .Values.initdbPassword }}
- - name: POSTGRESQL_INITSCRIPTS_PASSWORD
- value: .Values.initdbPassword
- {{- end }}
- {{- if .Values.persistence.mountPath }}
- - name: PGDATA
- value: {{ .Values.postgresqlDataDir | quote }}
- {{- end }}
- {{- if .Values.replication.enabled }}
- - name: POSTGRES_REPLICATION_MODE
- value: "master"
- - name: POSTGRES_REPLICATION_USER
- value: {{ include "postgresql.replication.username" . | quote }}
- {{- if .Values.usePasswordFile }}
- - name: POSTGRES_REPLICATION_PASSWORD_FILE
- value: "/opt/bitnami/postgresql/secrets/postgresql-replication-password"
- {{- else }}
- - name: POSTGRES_REPLICATION_PASSWORD
- valueFrom:
- secretKeyRef:
- name: {{ template "postgresql.secretName" . }}
- key: postgresql-replication-password
- {{- end }}
- {{- if not (eq .Values.replication.synchronousCommit "off")}}
- - name: POSTGRES_SYNCHRONOUS_COMMIT_MODE
- value: {{ .Values.replication.synchronousCommit | quote }}
- - name: POSTGRES_NUM_SYNCHRONOUS_REPLICAS
- value: {{ .Values.replication.numSynchronousReplicas | quote }}
- {{- end }}
- - name: POSTGRES_CLUSTER_APP_NAME
- value: {{ .Values.replication.applicationName }}
- {{- end }}
- {{- if and .Values.postgresqlPostgresPassword (not (eq .Values.postgresqlUsername "postgres")) }}
- {{- if .Values.usePasswordFile }}
- - name: POSTGRES_POSTGRES_PASSWORD_FILE
- value: "/opt/bitnami/postgresql/secrets/postgresql-postgres-password"
- {{- else }}
- - name: POSTGRES_POSTGRES_PASSWORD
- valueFrom:
- secretKeyRef:
- name: {{ template "postgresql.secretName" . }}
- key: postgresql-postgres-password
- {{- end }}
- {{- end }}
- - name: POSTGRES_USER
- value: {{ include "postgresql.username" . | quote }}
- {{- if .Values.usePasswordFile }}
- - name: POSTGRES_PASSWORD_FILE
- value: "/opt/bitnami/postgresql/secrets/postgresql-password"
- {{- else }}
- - name: POSTGRES_PASSWORD
- valueFrom:
- secretKeyRef:
- name: {{ template "postgresql.secretName" . }}
- key: postgresql-password
- {{- end }}
- {{- if (include "postgresql.database" .) }}
- - name: POSTGRES_DB
- value: {{ (include "postgresql.database" .) | quote }}
- {{- end }}
- {{- if .Values.extraEnv }}
- {{- include "postgresql.tplValue" (dict "value" .Values.extraEnv "context" $) | nindent 12 }}
- {{- end }}
- - name: POSTGRESQL_ENABLE_LDAP
- value: {{ ternary "yes" "no" .Values.ldap.enabled | quote }}
- {{- if .Values.ldap.enabled }}
- - name: POSTGRESQL_LDAP_SERVER
- value: {{ .Values.ldap.server }}
- - name: POSTGRESQL_LDAP_PORT
- value: {{ .Values.ldap.port | quote }}
- - name: POSTGRESQL_LDAP_SCHEME
- value: {{ .Values.ldap.scheme }}
- {{- if .Values.ldap.tls }}
- - name: POSTGRESQL_LDAP_TLS
- value: "1"
- {{- end}}
- - name: POSTGRESQL_LDAP_PREFIX
- value: {{ .Values.ldap.prefix | quote }}
- - name: POSTGRESQL_LDAP_SUFFIX
- value: {{ .Values.ldap.suffix | quote}}
- - name: POSTGRESQL_LDAP_BASE_DN
- value: {{ .Values.ldap.baseDN }}
- - name: POSTGRESQL_LDAP_BIND_DN
- value: {{ .Values.ldap.bindDN }}
- {{- if (not (empty .Values.ldap.bind_password)) }}
- - name: POSTGRESQL_LDAP_BIND_PASSWORD
- valueFrom:
- secretKeyRef:
- name: {{ template "postgresql.secretName" . }}
- key: postgresql-ldap-password
- {{- end}}
- - name: POSTGRESQL_LDAP_SEARCH_ATTR
- value: {{ .Values.ldap.search_attr }}
- - name: POSTGRESQL_LDAP_SEARCH_FILTER
- value: {{ .Values.ldap.search_filter }}
- - name: POSTGRESQL_LDAP_URL
- value: {{ .Values.ldap.url }}
- {{- end}}
- ports:
- - name: tcp-postgresql
- containerPort: {{ template "postgresql.port" . }}
- {{- if .Values.livenessProbe.enabled }}
- livenessProbe:
- exec:
- command:
- - /bin/sh
- - -c
- {{- if (include "postgresql.database" .) }}
- - exec pg_isready -U {{ include "postgresql.username" . | quote }} -d {{ (include "postgresql.database" .) | quote }} -h 127.0.0.1 -p {{ template "postgresql.port" . }}
- {{- else }}
- - exec pg_isready -U {{ include "postgresql.username" . | quote }} -h 127.0.0.1 -p {{ template "postgresql.port" . }}
- {{- end }}
- initialDelaySeconds: {{ .Values.livenessProbe.initialDelaySeconds }}
- periodSeconds: {{ .Values.livenessProbe.periodSeconds }}
- timeoutSeconds: {{ .Values.livenessProbe.timeoutSeconds }}
- successThreshold: {{ .Values.livenessProbe.successThreshold }}
- failureThreshold: {{ .Values.livenessProbe.failureThreshold }}
- {{- end }}
- {{- if .Values.readinessProbe.enabled }}
- readinessProbe:
- exec:
- command:
- - /bin/sh
- - -c
- - -e
- {{- include "postgresql.readinessProbeCommand" . | nindent 16 }}
- initialDelaySeconds: {{ .Values.readinessProbe.initialDelaySeconds }}
- periodSeconds: {{ .Values.readinessProbe.periodSeconds }}
- timeoutSeconds: {{ .Values.readinessProbe.timeoutSeconds }}
- successThreshold: {{ .Values.readinessProbe.successThreshold }}
- failureThreshold: {{ .Values.readinessProbe.failureThreshold }}
- {{- end }}
- volumeMounts:
- {{- if or (.Files.Glob "files/docker-entrypoint-initdb.d/*.{sh,sql,sql.gz}") .Values.initdbScriptsConfigMap .Values.initdbScripts }}
- - name: custom-init-scripts
- mountPath: /docker-entrypoint-initdb.d/
- {{- end }}
- {{- if .Values.initdbScriptsSecret }}
- - name: custom-init-scripts-secret
- mountPath: /docker-entrypoint-initdb.d/secret
- {{- end }}
- {{- if or (.Files.Glob "files/conf.d/*.conf") .Values.postgresqlExtendedConf .Values.extendedConfConfigMap }}
- - name: postgresql-extended-config
- mountPath: /bitnami/postgresql/conf/conf.d/
- {{- end }}
- {{- if .Values.usePasswordFile }}
- - name: postgresql-password
- mountPath: /opt/bitnami/postgresql/secrets/
- {{- end }}
- {{- if .Values.shmVolume.enabled }}
- - name: dshm
- mountPath: /dev/shm
- {{- end }}
- {{- if .Values.persistence.enabled }}
- - name: data
- mountPath: {{ .Values.persistence.mountPath }}
- subPath: {{ .Values.persistence.subPath }}
- {{- end }}
- {{- if or (.Files.Glob "files/postgresql.conf") (.Files.Glob "files/pg_hba.conf") .Values.postgresqlConfiguration .Values.pgHbaConfiguration .Values.configurationConfigMap }}
- - name: postgresql-config
- mountPath: /bitnami/postgresql/conf
- {{- end }}
- {{- if .Values.master.extraVolumeMounts }}
- {{- toYaml .Values.master.extraVolumeMounts | nindent 12 }}
- {{- end }}
-{{- if .Values.metrics.enabled }}
- - name: metrics
- image: {{ template "postgresql.metrics.image" . }}
- imagePullPolicy: {{ .Values.metrics.image.pullPolicy | quote }}
- {{- if .Values.metrics.securityContext.enabled }}
- securityContext:
- runAsUser: {{ .Values.metrics.securityContext.runAsUser }}
- {{- end }}
- env:
- {{- $database := required "In order to enable metrics you need to specify a database (.Values.postgresqlDatabase or .Values.global.postgresql.postgresqlDatabase)" (include "postgresql.database" .) }}
- - name: DATA_SOURCE_URI
- value: {{ printf "127.0.0.1:%d/%s?sslmode=disable" (int (include "postgresql.port" .)) $database | quote }}
- {{- if .Values.usePasswordFile }}
- - name: DATA_SOURCE_PASS_FILE
- value: "/opt/bitnami/postgresql/secrets/postgresql-password"
- {{- else }}
- - name: DATA_SOURCE_PASS
- valueFrom:
- secretKeyRef:
- name: {{ template "postgresql.secretName" . }}
- key: postgresql-password
- {{- end }}
- - name: DATA_SOURCE_USER
- value: {{ template "postgresql.username" . }}
- {{- if .Values.livenessProbe.enabled }}
- livenessProbe:
- httpGet:
- path: /
- port: http-metrics
- initialDelaySeconds: {{ .Values.metrics.livenessProbe.initialDelaySeconds }}
- periodSeconds: {{ .Values.metrics.livenessProbe.periodSeconds }}
- timeoutSeconds: {{ .Values.metrics.livenessProbe.timeoutSeconds }}
- successThreshold: {{ .Values.metrics.livenessProbe.successThreshold }}
- failureThreshold: {{ .Values.metrics.livenessProbe.failureThreshold }}
- {{- end }}
- {{- if .Values.readinessProbe.enabled }}
- readinessProbe:
- httpGet:
- path: /
- port: http-metrics
- initialDelaySeconds: {{ .Values.metrics.readinessProbe.initialDelaySeconds }}
- periodSeconds: {{ .Values.metrics.readinessProbe.periodSeconds }}
- timeoutSeconds: {{ .Values.metrics.readinessProbe.timeoutSeconds }}
- successThreshold: {{ .Values.metrics.readinessProbe.successThreshold }}
- failureThreshold: {{ .Values.metrics.readinessProbe.failureThreshold }}
- {{- end }}
- volumeMounts:
- {{- if .Values.usePasswordFile }}
- - name: postgresql-password
- mountPath: /opt/bitnami/postgresql/secrets/
- {{- end }}
- {{- if .Values.metrics.customMetrics }}
- - name: custom-metrics
- mountPath: /conf
- readOnly: true
- args: ["--extend.query-path", "/conf/custom-metrics.yaml"]
- {{- end }}
- ports:
- - name: http-metrics
- containerPort: 9187
- {{- if .Values.metrics.resources }}
- resources: {{- toYaml .Values.metrics.resources | nindent 12 }}
- {{- end }}
-{{- end }}
- volumes:
- {{- if or (.Files.Glob "files/postgresql.conf") (.Files.Glob "files/pg_hba.conf") .Values.postgresqlConfiguration .Values.pgHbaConfiguration .Values.configurationConfigMap}}
- - name: postgresql-config
- configMap:
- name: {{ template "postgresql.configurationCM" . }}
- {{- end }}
- {{- if or (.Files.Glob "files/conf.d/*.conf") .Values.postgresqlExtendedConf .Values.extendedConfConfigMap }}
- - name: postgresql-extended-config
- configMap:
- name: {{ template "postgresql.extendedConfigurationCM" . }}
- {{- end }}
- {{- if .Values.usePasswordFile }}
- - name: postgresql-password
- secret:
- secretName: {{ template "postgresql.secretName" . }}
- {{- end }}
- {{- if or (.Files.Glob "files/docker-entrypoint-initdb.d/*.{sh,sql,sql.gz}") .Values.initdbScriptsConfigMap .Values.initdbScripts }}
- - name: custom-init-scripts
- configMap:
- name: {{ template "postgresql.initdbScriptsCM" . }}
- {{- end }}
- {{- if .Values.initdbScriptsSecret }}
- - name: custom-init-scripts-secret
- secret:
- secretName: {{ template "postgresql.initdbScriptsSecret" . }}
- {{- end }}
- {{- if .Values.master.extraVolumes }}
- {{- toYaml .Values.master.extraVolumes | nindent 8 }}
- {{- end }}
- {{- if and .Values.metrics.enabled .Values.metrics.customMetrics }}
- - name: custom-metrics
- configMap:
- name: {{ template "postgresql.metricsCM" . }}
- {{- end }}
- {{- if .Values.shmVolume.enabled }}
- - name: dshm
- emptyDir:
- medium: Memory
- sizeLimit: 1Gi
- {{- end }}
-{{- if and .Values.persistence.enabled .Values.persistence.existingClaim }}
- - name: data
- persistentVolumeClaim:
-{{- with .Values.persistence.existingClaim }}
- claimName: {{ tpl . $ }}
-{{- end }}
-{{- else if not .Values.persistence.enabled }}
- - name: data
- emptyDir: {}
-{{- else if and .Values.persistence.enabled (not .Values.persistence.existingClaim) }}
- volumeClaimTemplates:
- - metadata:
- name: data
- {{- with .Values.persistence.annotations }}
- annotations:
- {{- range $key, $value := . }}
- {{ $key }}: {{ $value }}
- {{- end }}
- {{- end }}
- spec:
- accessModes:
- {{- range .Values.persistence.accessModes }}
- - {{ . | quote }}
- {{- end }}
- resources:
- requests:
- storage: {{ .Values.persistence.size | quote }}
- {{ include "postgresql.storageClass" . }}
-{{- end }}