PostgreSQL 11 upgrade procedure for GEO installations
We need to support upgrading GEO installations from PostgreSQL 9.6.x or 10.X to PostgreSQL 11.X. Initially this will be an opt-in upgrade, but will become opt out in %12.10 and mandatory prior to GitLab 13.0. PostgreSQL 9.6 and 10 are scheduled to be removed in GitLab 13.0.
The current procedure should not need to be deviated from significantly.
We should verify the following GEO installation types
-
Single node primary and secondaries -
Separate database nodes on primary. Secondary with separate node running postgresql
andgeo-postgresql
.
The pg-upgrade
command does not currently support running on a secondary with separate nodes for postgresql
and geo-postgresql
. This is a major change that will be worked on separately in #4838 (closed)
Edited by Michael Kozono