postgres-deployment.yml

apiVersion: v1
kind: Service
metadata:
  namespace: ngcovid
  name: ngcovid-db
spec:
  ports: 
    - port: 5432
  selector:
    app: postgres-db

---
kind: PersistentVolume
apiVersion: v1
metadata:
  name: postgres-pv-volume
  labels:
    type: local
spec:
  storageClassName: manual
  capacity:
    storage: 3Gi
  accessModes:
    - ReadWriteOnce
  hostPath:
    path: "/home/vagrant/dbdata"

---
kind: PersistentVolumeClaim
apiVersion: v1
metadata:
  name: postgres-pv-claim
  namespace: ngcovid
spec:
  storageClassName: manual
  accessModes:
    - ReadWriteOnce
  resources:
    requests:
      storage: 1Gi


---
apiVersion: apps/v1
kind: Deployment
metadata:
  name: ngcovid-db
  namespace: ngcovid
spec:
  selector:
    matchLabels:
      app: postgres-db
  strategy:
    type: Recreate
  template:
    metadata:
      labels:
        app: postgres-db
    spec:
      containers:
        - image: postgres
          name: postgres-db
          env:
            - name: POSTGRES_PASSWORD
              valueFrom:
                secretKeyRef:
                  name: postgres-secrets
                  key: password
            - name: POSTGRES_USER
              valueFrom:
                configMapKeyRef:
                  name: postgresconfig
                  key: postgresuser
            - name: POSTGRES_DB
              valueFrom:
                configMapKeyRef:
                  name: postgresconfig
                  key: postgresdb
            - name: PGDATA
              value: /var/lib/postgresql/data/pgdata
          ports:
            - containerPort: 5432
          volumeMounts:
            - name: postgres-persistent-storage
              mountPath: /var/lib/postgresql/data
              subPath: datadir
            - name: postgres-persistent-storage
              mountPath: /docker-entrypoint-initdb.d
              subPath: initdir
      initContainers:
        - name: initializedir
          image: busybox
          command: ["/bin/sh", "-c"] 
          args: ["wget -O /docker-entrypoint-initdb.d/db-restore.sql https://raw.githubusercontent.com/seyio91/scraper-app-dev/master/db-ncdc-restore.sql; /bin/chmod -R 777 /docker-entrypoint-initdb.d/"]
          volumeMounts:
            - name: postgres-persistent-storage
              mountPath: /docker-entrypoint-initdb.d
              subPath: initdir
      volumes:
        - name: postgres-persistent-storage
          persistentVolumeClaim:
            claimName: postgres-pv-claim