Upgrade postgresql cluster

Manual

https://scottlinux.com/2015/11/14/upgrade-postgresql-on-debian-jessie-with-pg_upgradecluster/

apt-get install postgresql-9.4
systemctl stop postgresql@9.4-main.service apache2 foreman
sudo -i -u postgres
  pg_dropcluster --stop 9.4 main
  pg_ctlcluster 9.4 main stop
  exit
systemctl start postgresql@9.4-main.service apache2 foreman

when everything is ok:

apt remove postgresql-9.1 postgresql-client-9.1  --purge

Docker upgrade

• docker-postgres-upgrade

Upgrading in Kubernetes

Bitnami chart

• Postgres upgrade to 13 or 14

Upgrade postgres deployed by Bitnami helm chart

• Still no official documentation on Bitnami chart: Postgres upgrade to 13 or 14
• Upgrade bitnami postgresql image k8s
• Stackspin: Upgrade postgres chart to v11

Steps:

Create new helm release of Postgres while the old one running Migrate:

 kubectl exec -it new-helm-db-postgresql-0 -- bash \
   -c 'export PGPASSWORD=${POSTGRES_PASSWORD}; \
       time pg_dump -h old-postgresql -U postgres | psql -U postgres'