Skip to content

WIP: Upgrade to PostgreSQL 9.6.0

yorickpeterse-staging requested to merge postgresql-95 into master

This MR is based on the changes from https://gitlab.com/gitlab-org/omnibus-gitlab/merge_requests/1009.

This updates Omnibus to ship PostgreSQL 9.6.0 instead of 9.2.

@marin: In newer versions of PostgreSQL some configuration variables have changed. Ideally we can build a PostgreSQL 9.2 and 9.6 package in parallel for every release so we can use the 9.6 package for GitLab.com. While we can use environment variables to alter the version in config/projects/gitlab.rb I'm not sure what we can use to dynamically adjust the various Chef parameters based on the PostgreSQL version. Basically the plan I envision is to:

  • Set up a separate CI build that builds a Ubuntu 16.04 package with PostgreSQL 9.6
  • Make sure this package is build for every release
  • Deploy this package to GitLab.com instead of the usual gitlab-ee package

If all of this happens in the same branch we need to start adding conditionals for some of the changed variables. Using a separate branch would remove the need for that but may make releasing versions harder. Also, will we provide something to customers to automatically move over configuration variables?

Note that this doesn't contain any tools yet to semi automatically upgrade a database, this will be taken care of in a separate merge request.

Merge request reports