PostgreSQL

alias pgk='kubectl -n database exec deployment/postgresql --'

pgk pg_dumpall -U postgres > postgresql-full-$(date +%Y%m%d).sql

pgk pg_dump -U postgres <dbname> > <dbname>-$(date +%Y%m%d).sql

pgk sh -c 'pg_dumpall -U postgres > /bitnami/postgresql/backup-$(date +%Y%m%d).sql'

# 全量恢复
cat postgresql-full-20260512.sql | pgk psql -U postgres

# 单库恢复（先创建空库）
pgk psql -U postgres -c "CREATE DATABASE <dbname>;"
cat <dbname>-20260512.sql | pgk psql -U postgres -d <dbname>

apiVersion: batch/v1
kind: CronJob
metadata:
  name: postgresql-backup
  namespace: database
spec:
  schedule: "0 3 * * *"
  jobTemplate:
    spec:
      template:
        spec:
          containers:
          - name: backup
            image: m.daocloud.io/docker.io/bitnami/postgresql:latest
            command:
            - sh
            - -c
            - |
              pg_dumpall -U postgres -h postgresql \
                > /backup/postgresql-$(date +%Y%m%d%H%M).sql
              find /backup -name "*.sql" -mtime +7 -delete
            volumeMounts:
            - name: backup
              mountPath: /backup
          restartPolicy: Never
          volumes:
          - name: backup
            hostPath:
              path: /data/backups/postgresql