[SOLVED] pg_restore immich backup into new CNPG instance
- gunzip immich-db-backup-1735542000019.sql.gz
- sed "s/SELECT pg_catalog.set_config('search_path', '', false);/SELECT pg_catalog.set_config('search_path', 'public, pg_catalog', true);/g" immich-db-backup-1735542000019.sql > immich-db-backup.sql
- kubectl -n databases cp ./immich-db-backup.sql postgres-16-1:/var/lib/postgresql/data/
- kubectl -n databases exec -it postgres-16-1 -- bash
- pg_restore -S postgres -U immich -Cev -f /var/lib/postgresql/data/immich-db-backup.sql
