Our PostgreSQL clusters should be upgraded to PostgreSQL 11. This ticket tracks the progress of this operation.
Documentation for pg_upgrade : https://www.postgresql.org/docs/11/pgupgrade.html
Clusters to upgrade:
Primary
[ ] `prado/main` (softwareheritage)
[ ] `prado/secondary` (scheduler, etc.)
[x] `prado/hdd`
[ ] `somerset/indexer`
[x] `somerset/testdedup`
Physical replica (follow step 10 of the pgupgrade docs)
[ ] `dbreplica1.euwest.azure/indexer` (replica of `somerset/indexer`)
Ignored until upgrade of `prado/main` (T1534)
[ ] `somerset/replica`
[ ] `dbreplica0.euwest.azure/replica`