apiVersion: velero.io/v1
kind: Restore
metadata:
  name: restore-pgstats
  namespace: velero
spec:
  scheduleName: daily-backup
  backupName: ""
  includedNamespaces:
  - prod-central
  namespaceMapping:
    prod-central: qualif-central
  labelSelector:
    matchLabels:
      app: "postgres-13"
  hooks:
    resources:
    # PROD-CENTRAL-PGSTATS
    - labelSelector:
        matchLabels:
          app: "postgres-13"
      includedNamespaces:
        - 'qualif-central'
      name: qualif-central-pgstats
      postHooks:
        - exec:
            command: 
            - sh
            - -c
            - |
              sleep 20
              createdb -U ${POSTGRES_USER} ${POSTGRES_DB}
              chown -R postgres. /var/lib/postgresql/data/pgdata
              gunzip -c /backups/pgstats.sql.gz | psql -U ${POSTGRES_USER} ${POSTGRES_DB}
            execTimeout: 1200s