Hassio/manifests/database.yaml

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: homeassistant-db
  namespace: home-automation

spec:
  instances: 1

  storage: 
    size: 1Gi
    storageClass: flat-storage-class

  bootstrap:
    initdb:
      database: homeassistant
      owner: homeassistant
      secret:
        name: homeassistant-db

  postgresql:
    pg_hba:
      - host all all all md5

  resources:
    requests:
      cpu: 100m
      memory: 100Mi
    limits:
      cpu: 500m
      memory: 500Mi