Default to PostgreSQL 14 for fresh installations

What does this MR do?

Default to PostgreSQL 14 for fresh installations instead of PostgreSQL 13. No automatic upgrades are performed.

To upgrade to PostgreSQL 14 see: https://docs.gitlab.com/omnibus/settings/database.html#upgrade-packaged-postgresql-server

Changelog: changed

Related issues

Closes #8288 (closed)

Checklist

See Definition of done.

For anything in this list which will not be completed, please provide a reason in the MR discussion.

Required

• MR title and description are up to date, accurate, and descriptive.
• MR targeting the appropriate branch.
• Latest Merge Result pipeline is green.
• When ready for review, MR is labeled "~workflow::ready for review" per the Distribution MR workflow.

For GitLab team members

If you don't have access to this, the reviewer should trigger these jobs for you during the review process.

• The manual Trigger:ee-package jobs have a green pipeline running against latest commit.
• If config/software or config/patches directories are changed, make sure the build-package-on-all-os job within the Trigger:ee-package downstream pipeline succeeded.
• If you are changing anything SSL related, then the Trigger:package:fips manual job within the Trigger:ee-package downstream pipeline must succeed.
• If CI configuration is changed, the branch must be pushed to dev.gitlab.org to confirm regular branch builds aren't broken.

Expected (please provide an explanation if not completing)

• Test plan indicating conditions for success has been posted and passes.
• Documentation created/updated.
  • gitlab!139104 (merged)
• Tests added.
• Integration tests added to GitLab QA.
• Equivalent MR/issue for the GitLab Chart opened.
• Validate potential values for new configuration settings. Formats such as integer 10, duration 10s, URI scheme://user:passwd@host:port may require quotation or other special handling when rendered in a template and written to a configuration file.

Test Plan

1. Fresh install
   • Setup a fresh install
   • Confirm the postgres version is 14 postgres --version
   • Setup another fresh install with postgres['version'] = 13
   • Confirm the postgres version is 13
2. Upgrades
   • Setup a fresh 16.6 install
   • Confirm the default postgres version is 13
   • Upgrade the node to this branch
   • Confirm the postgres version is not upgraded to 14
   • run gitlab-ctl pg-upgrade -V 14
   • Confirm the upgrade passes
   • Downgrade to pg 13 gitlab-ctl revert-pg-upgrade 13

changed milestone to %16.7

added Deliverable devopssystems groupdistribution group::distributionbuild priority2 quad-planningcomplete-no-action sectioncore platform typemaintenance + 1 deleted label

assigned to @clemensbeck

marked this merge request as draft

changed the description

added workflowin dev label

	2 Warnings
	You've made some changes to the software definitions. Any change in software definition requires: package rebuild to verify that builds across the supported platforms are successful. manual verification to confirm the package is installable uses an approved license If the change does not affect existing functionality, for example when resolving rubocop warnings, adding comments, or fixing typos, add one of the following labels: maintenancepipelines maintenanceworkflow
	You've made some changes in the cookbooks, but didn't add any tests. That's OK as long as you're refactoring existing code, but please consider adding the typemaintenance label in that case.

Reviewer roulette

Changes that require review have been detected! A merge request is normally reviewed by both a reviewer and a maintainer in its primary category and by a maintainer in all other categories.

To spread load more evenly across eligible reviewers, Danger has picked a candidate for each review slot. Feel free to override these selections if you think someone else would be better-suited or use the GitLab Review Workload Dashboard to find other available reviewers.

To read more on how to use the reviewer roulette, please take a look at the Engineering workflow and code review guidelines. Please consider assigning a reviewer or maintainer who is a domain expert in the area of the merge request.

Once you've decided who will review this merge request, mention them as you normally would! Danger does not automatically notify them for you.

Reviewer	Maintainer
@WarheadsSE (UTC-5, 6 hours behind @clemensbeck)	@apatterson2 (UTC-7, 8 hours behind @clemensbeck)

If needed, you can retry the danger-review job that generated this comment.

Generated by Danger

mentioned in commit gitlab@307ce746

mentioned in merge request gitlab!139104 (merged)

gitlab-org/gitlab doc MR: gitlab!139104 (merged)

added maintenancedependency label and removed typemaintenance label

added typemaintenance label

Allure report

allure-report-publisher generated test report!

qa-subset-test: test report for d1f391eb

expand test summary

+-----------------------------------------------------------------------+
|                            suites summary                             |
+------------------+--------+--------+---------+-------+-------+--------+
|                  | passed | failed | skipped | flaky | total | result |
+------------------+--------+--------+---------+-------+-------+--------+
| Create           | 207    | 1      | 30      | 0     | 238   | ❌     |
| Plan             | 173    | 0      | 1       | 0     | 174   | ✅     |
| Systems          | 8      | 0      | 0       | 0     | 8     | ✅     |
| Verify           | 93     | 0      | 0       | 0     | 93    | ✅     |
| Package          | 112    | 12     | 7       | 0     | 131   | ❌     |
| Monitor          | 32     | 0      | 1       | 0     | 33    | ✅     |
| Govern           | 140    | 0      | 1       | 0     | 141   | ✅     |
| Data Stores      | 71     | 0      | 0       | 0     | 71    | ✅     |
| GitLab Metrics   | 2      | 0      | 1       | 0     | 3     | ✅     |
| Manage           | 2      | 0      | 0       | 0     | 2     | ✅     |
| Configure        | 1      | 0      | 0       | 0     | 1     | ✅     |
| Framework sanity | 0      | 0      | 4       | 0     | 4     | ➖     |
+------------------+--------+--------+---------+-------+-------+--------+
| Total            | 841    | 13     | 45      | 0     | 899   | ❌     |
+------------------+--------+--------+---------+-------+-------+--------+

marked the checklist item Test plan indicating conditions for success has been posted and passes. as completed

changed the description

changed the description

marked the checklist item Latest Merge Result pipeline is green. as completed

marked the checklist item Setup a fresh install as completed

marked the checklist item Confirm the postgres version is 14 postgres --version as completed

marked the checklist item Setup another fresh install with postgres['version'] = 13 as completed