cnpg - Migrating From External Postgres

Can be done with the bootstrap and externalClusters properties in spec.

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: cluster-postgres
  annotations:
    backup.velero.io/backup-volumes: pgdata
spec:
  instances: 1
 
  imageName: ghcr.io/cloudnative-pg/postgresql:18.1
  
  storage:
    size: 10Gi
 
  bootstrap:
    initdb:
      import:
        type: microservice
        databases:
          - n8n
        source:
          externalCluster: old-cluster
  externalClusters:
    - name: old-cluster
      connectionParameters:
        host: postgres
        user: n8n
        dbname: n8n
      password:
        name: db
        key: POSTGRES_PASSWORD

Support for importing from older versions.

With the help of pg_dump, older postgres versions are supported. For example you can import from Postgres 16 to 18.