postgres-deploy.yaml

kind: Deployment
apiVersion: apps/v1
metadata:
  name: psql-airflow
  namespace: airflow
  labels:
    app: psql-airflow
spec:
  replicas: 1
  selector:
    matchLabels:
      app: psql-airflow
  template:
    metadata:
      creationTimestamp: null
      labels:
        app: psql-airflow
    spec:
      restartPolicy: Always
      terminationGracePeriodSeconds: 30
      dnsPolicy: ClusterFirst
      securityContext:
        fsGroup: 1000
      containers:
        - name: psql-airflow
          image: postgres:13
          imagePullPolicy: IfNotPresent
          resources:
          # 35.08% from 2CPU scheduler demands
          # 86.98MiB / 2.931GiB
            requests:
              cpu: 100m
              memory: 256Mi
            limits:
              cpu: 500m
              memory: 512Mi
          ports:
            - containerPort: 5432
              protocol: TCP
          volumeMounts:
            # - name: postgresdb
            #   mountPath: /var/lib/postgresql/data
            #   subPath: psql-data
            - name: scripts
              mountPath: /docker-entrypoint-initdb.d
          env:
            - name: POSTGRES_USER
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: POSTGRES_USER
            - name: POSTGRES_PASSWORD
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: POSTGRES_PASSWORD
            - name: POSTGRES_DB
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: POSTGRES_DB
            - name: AIRFLOW_PSQL_USER
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: AIRFLOW_PSQL_USER
            - name: AIRFLOW_PSQL_PASSWORD
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: AIRFLOW_PSQL_PASSWORD
            - name: AIRFLOW_PSQL_DB
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: AIRFLOW_PSQL_DB
            - name: CUSTOM_USER
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: CUSTOM_USER
            - name: CUSTOM_PASSWORD
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: CUSTOM_PASSWORD
            - name: CUSTOM_DB
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: CUSTOM_DB
            - name: GRAFANA_USER
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: GRAFANA_USER
            - name: GRAFANA_PASSWORD
              valueFrom:
                secretKeyRef:
                  name: airflow-secrets
                  key: GRAFANA_PASSWORD
      volumes:
        # - name: postgresdb
        #   persistentVolumeClaim:
        #     claimName: psql-airflow-pvc
        - name: scripts
          configMap:
            name: psql-scripts
            items:
            - key: 00-create-custom-user.sh
              path: 00-create-custom-user.sh
            - key: 01-create-custom-db.sh
              path: 01-create-custom-db.sh
            - key: 02-create-airflow-user.sh
              path: 02-create-airflow-user.sh
            - key: 03-create-airflow-db.sh
              path: 03-create-airflow-db.sh
            - key: 04-create-grafana-user.sh
              path: 04-create-grafana-user.sh