Skip to content

Migration from Postgresql HA

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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
# 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