Default to PostgreSQL 17 for fresh installs
What does this MR do?
Default to PostgreSQL 17 for fresh installs
- Fresh installs now default to PostrgreSQL 17.
- The default can be overridden by setting
postgresql['version']=16. - Existing installations do not upgrade automatically.
- Updating PG upgrade test to skip upgrade testing when version is already equal to new PG
Related issues
Related to Default to PostgreSQL 17 for fresh installs (#9724 - closed) and similar example from last year Default to PostgreSQL 16 for fresh installs (!8198 - merged)
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 workflowready 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-packagejobs have a green pipeline running against latest commit. - If
config/softwareorconfig/patchesdirectories are changed, make sure thebuild-package-on-all-osjob within theTrigger:ee-packagedownstream pipeline succeeded. - If you are changing anything SSL related, then the
Trigger:package:fipsmanual job within theTrigger:ee-packagedownstream pipeline must succeed. - If CI configuration is changed, the branch must be pushed to
dev.gitlab.orgto 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.
- Tests added - not applicable, existing tests cover this.
- Integration tests added to GitLab QA. - N/A
- Equivalent MR/issue for the GitLab Chart opened. - N/A as Charts don't have PG anymore
- Validate potential values for new configuration settings. Formats such as integer
10, duration10s, URIscheme://user:passwd@host:portmay require quotation or other special handling when rendered in a template and written to a configuration file.
Edited by Dmytro Makovey