Database Deletion Protection

The backup deletion protection is deprecated and has been replaced by the instance deletion protection. If you delete your instance, all backups will be deleted as well.

The Deletion Protection feature is enabled by default and ensures your instance is not deleted by accident.

Configuration

Deletion protection can be enabled or disabled using the following configuration:

Example of a PostgreSQL instance with deletion protection on. Update the namespace!

apiVersion: vshn.appcat.vshn.io/v1
kind: VSHNPostgreSQL
metadata:
  name: pgsql-app1
  namespace: <your-namespace>
spec:
  parameters:
    security:
      deletionProtection: true (1)
    backup:
      deletionProtection: true (2)
      deletionRetention: 10 (2)
      schedule: '0 22 * * *'
    service:
      majorVersion: "15"
      pgSettings:
        timezone: Europe/Zurich
    size:
      cpu: "600m"
      memory: "3500Mi"
      disk: "80Gi"
  writeConnectionSecretToRef:
    name: postgres-creds

1	Enable or disable instance deletion protection.
2	This is now deprecated and doesn’t have any effect. Upon deletion of the instance, the backups are deleted as well.