PostgreSQL Backup (Policy)

Performs regular backups of your PostgreSQL database based on a predefined schedule, ensuring your data is securely archived without manual intervention.

Key features include:

• Scheduled Backups: Configure the system to execute backups at specific times, reducing the risk of data loss while aligning with your maintenance windows.
• Multi-Cloud Support: Seamlessly store your backup files in cloud buckets from leading providers such as Azure, GCP, or AWS, offering you flexibility and enhanced resilience.
• Secure Data Transfer: Employ industry-standard encryption to ensure that your data remains confidential and tamper-proof during both transmission and storage.

Prerequisites

• PostgreSQL database asset
• PostgreSQL credentials
• Storage bucket asset
• Storage bucket asset credentials

Procedure from web console

• Navigate to the policy's page: Operations > Policies (or go directly to /home/operations/policies)
• Click on Create Policy button
• Select PostgreSQL backup
• Fill out the PostgreSQL backup policy form with the following information:
  • Policy name: Enter a descriptive name for your backup policy
  • The PostgreSQL asset to backup: Select the PostgreSQL instance from the dropdown
  • The credential name to access PostgreSQL: Select the credential bound to the PostgreSQL asset from the dropdown
  • The database name to backup: Specify the name of the database you want to backup
  • The Bucket asset where backups will be saved: Choose the storage bucket from the dropdown
  • The opts for PostgreSQL backup: Configure additional backup options (optional)
  • The version for PostgreSQL client version: Specify the PostgreSQL client version to use (optional)
  • The credential name to access Bucket: Select the credential bound to the Bucket from the dropdown
  • The path inside the bucket where backup is saved: Define the storage path within the bucket
  • The backup schedule in Cron format: Set the backup frequency using cron syntax (e.g., 0 2 * * * for daily at 2 AM)
  • Enable GZIP compression: Check this option to compress backups
  • Click Next to continue with the policy configuration
• Select the target cluster where you want to deploy the policy (optional - if not specified, the policy will be deployed to the default cluster)
• Review the policy configuration summary
• Click Create Policy to deploy the PostgreSQL backup policy

Procedure from CLI

Create a YAML file with the policy configuration:

apiVersion: operations.resiliency.io/v1alpha1
kind: Policy
metadata:
 name: <policy-name>
 namespace: resiliency-system
spec:
 templateName: postgresql-backup
 params:
 - name: postgresql-asset
   value: <postgresql-asset-id>
 - name: postgresql-database
   value: <database-name>
 - name: bucket-asset
   value: <bucket-asset-id>
 - name: postgresql-opts
   value: "<backup-options>"
 - name: postgresql-version
   value: "<client-version>"
 - name: bucket-path
   value: "<path-in-bucket>"
 - name: schedule
   value: "<cron-schedule>"
 - name: use-gzip
   value: <true|false>
 - name: bucket-credential
   value: <bucket-credential-name>
 - name: postgresql-credential
   value: <postgresql-credential-name>
 placement:
   clusterName: <target-cluster-id>
   createNamespace: true
   credentialName: <cluster-credential-name>
 suspended: false

Apply the policy to the cluster:

kubectl apply -f postgresql-backup-policy.yaml