Docs how to upgrade an external database PG 11 to 12 in preparation for GitLab 14

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

• Close this issue

In Upgrade the bundled PostgreSQL to version 12 (optional) we documented the required steps for the bundled database chart but lack guidance on steps if using an external database (Omnibus, or service)

A couple of suggested scenarios are

1. restore PG internally

• scale Gitlab services to 0
• dump DB on PG11
• restore DB on PG12
• adapt PG12 host entry in helm chart, upgrade helm chart (including the previous replica count)

2. Restore via the task runner

• scale down the replicas which are using the DB
• from Prepare the existing database do a backup of the database using the task runner
• point the task runner to the new DB (editing the task runner configmap)
• Restore using the task runner
• adapt PG12 host entry in helm chart, upgrade helm chart (including the previous replica count)

Is there a preferred method?

InUpgrade a non-packaged PostgreSQL database we take care to specify the major version of PostgreSQL in gitlab.rb - how does this translate to Chart configuration?