From 75c68a57ecd5ed27217544e87a4dde351a437e18 Mon Sep 17 00:00:00 2001 From: Stan Hu Date: Thu, 18 Nov 2021 20:40:31 -0800 Subject: Add CI tests for PostgreSQL v11 We added a `MATERIALIZED` view to optimize the metrics query, but this keyword is only available in PostgreSQL v12. This caused an severity 3 incident: https://gitlab.com/gitlab-com/gl-infra/production/-/issues/5945 The Praefect database in Cloud SQL is running v11, and we have customers also using v11. Relates to https://gitlab.com/gitlab-org/gitaly/-/issues/3930 --- .gitlab-ci.yml | 1 + 1 file changed, 1 insertion(+) diff --git a/.gitlab-ci.yml b/.gitlab-ci.yml index cfe49d78c..9196a00eb 100644 --- a/.gitlab-ci.yml +++ b/.gitlab-ci.yml @@ -188,6 +188,7 @@ test: - GO_VERSION: [ "1.16", "1.17" ] TARGET: test - GO_VERSION: "1.17" + POSTGRES_VERSION: [ "12.6-alpine", "11.14-alpine" ] TARGET: [ test-with-proxies, test-with-praefect, race-go ] nightly:git: -- cgit v1.2.3