Project: Support Local volume for PostgreSQL WAL archiving

[david-ecc]

WAL-archiving to PVC seems to be supported in the CRD, but i always get this error message:

admission webhook "postgres.validators.kubedb.com" denied the request: no storage provider is configured

This is my configuration:

apiVersion: kubedb.com/v1alpha1
kind: Postgres
metadata:
  name: testpg
spec:
  version: "11.1-v1"
  storageType: Durable
  storage:
    storageClassName: "thin"
    accessModes:
    - ReadWriteOnce
    resources:
      requests:
        storage: 10Gi
  terminationPolicy: Delete
  archiver:
    storage:
      local:
        persistentVolumeClaim:
          claimName: pgbackup-cifs

I'm using version 0.11.0

[tamalsaha]

Wal-g archiving is not supported for Local PVC. Current you can use s3, gcs, azure or swift storage. Please see here: https://kubedb.com/docs/0.11.0/guides/postgres/snapshot/continuous_archiving/

[david-ecc]

Is there a reason why this is not supported in kubedb? Wal-g supports writing local files.

[tamalsaha]

We can add support for it. No one has asked for it so far.

[tamalsaha]

apiVersion: kubedb.com/v1alpha1
kind: Postgres
metadata:
  name: testpg
spec:
  version: "11.1-v1"
  storageType: Durable
  storage:
    storageClassName: "thin"
    accessModes:
    - ReadWriteOnce
    resources:
      requests:
        storage: 10Gi
  terminationPolicy: Delete
  archiver:
    storage:
      local:
        persistentVolumeClaim:
          claimName: pgbackup-cifs
        mountPath: /data/pgbackup-cifs

• https://github.com/kubedb/postgres/blob/master/pkg/controller/statefulset.go#L218

-

  elif [[ ${ARCHIVE_FILE_PREFIX} != "" ]]; then
    export WALG_FILE_PREFIX="${ARCHIVE_FILE_PREFIX}/$(hostname)"
    mkdir =p $WALG_FILE_PREFIX

[iamrz1]

• [x] Code : https://github.com/kubedb/postgres/pull/270

• [x] Docs : https://github.com/kubedb/cli/pull/429