Migration from Postgresql HA

The postgresql-ha subchart has been removed. It was frozen upstream at images that only exist in Bitnami's archived bitnamilegacy registry, and no replacement subchart offers real HA — every credible option is an operator, which cannot work as a plain Helm dependency.

Migrate to a Postgres operator via externalDB — see PostgreSQL Operators and External DB Integration. The bundled single-node PostgreSQL is a dev/test destination only.

The dump-and-restore steps below still apply; the destination has changed.

Plan:

1. Scale api, beat, worker -> 0

2. Backup — using backup job

3. group_vars/puhuri_core_prd - helm_pg_ha_enabled: no ===> CANCEL THE UPDATING PIPELINE!

4. Run dependency update ==> leads to a working single psql

5. Restore DB — using recovery job

6. Run a common update pipeline

7. Validate that login works

8. Drop old psql ha, drop pvc

# Backup

kubectl exec -it postgresql-ha-waldur-postgresql-0 -- env PGPASSWORD=waldur pg_dump -h 0.0.0.0 -U waldur waldur | gzip -9 > backup.sql.gz

# Backup restoration
# Locally

kubectl cp backup.sql.gz postgresql-waldur-0:/tmp/backup.sql.gz
kubectl exec -it postgresql-waldur-0 -- bash

# In pgpool pod

gzip -d /tmp/backup.sql.gz
export PGPASSWORD=waldur
psql -U waldur -h 0.0.0.0 -f /tmp/backup.sql