#备份恢复

# 示例：为实例'my-pg-instance'配置备份存储
kubectl patch postgresql my-pg-instance -n my-namespace --type='merge' -p '
spec:
  backup:
    retainDay: 7
    storage:
      name: my-s3-config
      bucket: my-backup-bucket
      namespace: storage-namespace
'

# 示例：为集群'my-pg-cluster'创建名为'my-backup'的备份
cat <<EOF | kubectl create -f -
apiVersion: middleware.alauda.io/v1
kind: PostgresBackup
metadata:
  name: my-backup
  namespace: my-namespace
spec:
  cluster: my-pg-cluster
  executeNode: my-pg-cluster-0  # 可选：指定执行备份的pod
EOF

kubectl get postgresbackup <备份名称> -n <命名空间> -o yaml

cat <<EOF | kubectl create -f -
apiVersion: middleware.alauda.io/v1
kind: PostgresRestore
metadata:
  name: <恢复实例名称>
  namespace: <命名空间>
spec:
  backupCluster:
    name: <备份PG集群实例名>
    uid: <备份PG集群UID>
    storage:
      name: <存储名>
      namespace: <存储命名空间>
      bucket: <S3 bucket名>
  targetCluster: |
    apiVersion: acid.zalan.do/v1
    kind: postgresql
    metadata:
      name: <新群实例名称>
      namespace: <新集群实例名称>
    spec:
      enableExporter: true
      enablePgpool2: false
      numberOfInstances: 2
      postgresql:
        version: "14"
      resources:
        limits:
          cpu: "1"
          memory: 2Gi
        requests:
          cpu: "1"
          memory: 2Gi
      teamId: ACID
      volume:
        size: 20Gi
        storageClass: sc-topolvm
  timestamp: "2023-07-26T14:36:38+00:00"  # 恢复的时间点
EOF