No edit summary |
No edit summary |
||
Line 22: | Line 22: | ||
== Current status == | == Current status == | ||
[[Category:ChangeReadyForWrangler] | [[Category:ChangeReadyForWrangler]] | ||
<!-- When your change proposal page is completed and ready for review and announcement --> | <!-- When your change proposal page is completed and ready for review and announcement --> | ||
<!-- remove Category:ChangePageIncomplete and change it to Category:ChangeReadyForWrangler --> | <!-- remove Category:ChangePageIncomplete and change it to Category:ChangeReadyForWrangler --> |
Revision as of 17:52, 25 November 2021
PostgreSQL 14
Summary
Update of PostgreSQL (postgresql
and libpq
components) in Fedora from version 13 to version 14 in the non-modular (main) builds.
Owner
- Name: Filip Januš
- Email: fjanus@redhat.com
Current status
- Targeted release: Fedora Linux 36
- Last updated: 2021-11-25
- FESCo issue: <will be assigned by the Wrangler>
- Tracker bug: <will be assigned by the Wrangler>
- Release notes tracker: <will be assigned by the Wrangler>
Detailed Description
Update of PostgreSQL (postgresql
and libpq
components) in Fedora from version 13 to version 14 in the non-modular (main) builds.
This also involves updating and rebuilding the PostgreSQL plugins that depend on postgresql server.
Plan
- Prepare PostgreSQL 14 in Copr (By 2022-01-15)
- Rebuild important dependencies in Copr (By 2022-01-15)
- Debug and fix compatibility issues found in dependencies (a reasonable amount of non-critical in FTBFS state might be tolerable)
- Prepare Pull requests in Rawhide
- Merge and build PR into Rawhide
Feedback
Benefit to Fedora
The latest stable software is used by Fedora users.
Scope
- Proposal owners:
- Prepare PostgreSQL 14
- Prepare PostgreSQL 13 as a module for Rawhide
- Check software that requires or depends on
postgresql-server
orlibpq
packages for incompatibilities - Build PostgreSQL 14 (postgresql and libpq) to Rawhide
- Rebuild depended on packages against PostgreSQL 14
- Gather user input on the changes between PostgreSQL 13 and PostgreSQL 14
- Other developers: N/A (not a System Wide Change)
- Release engineering: #Releng issue number (a check of an impact with Release Engineering is needed)
- Policies and guidelines: N/A (not a System Wide Change)
- Trademark approval: N/A (not needed for this Change)
Upgrade/compatibility impact
The PostgreSQL client library (libpq component) is compatible. So, there shouldn't be any issues with compatibility, but rebuild of the depended components is recommanded.
Server plugins might require a newer version update, because they sometimes have explicit server requirements. PostgreSQL maintainer will help fixing/rebuilding any issues in the plugins.
How To Test
Usual testing as when upgrading between major PostgreSQL versions, running postgresql-setup --upgrade
is necessary between major versions.
Test that all other software runs well with PostgreSQL 14.
User Experience
The users will have to upgrade their databases the same way as between major PostgreSQL versions, aka postgresql-setup --upgrade
after installing PostgreSQL 14 server packages.
If users want to stick with PostgreSQL 13 for a little longer, there will be PostgreSQL 13 module
Dependencies
There are some packages (mostly server plugins), that build on top of PostgreSQL. Since the separation of PostgreSQL client library (libpq component), only packages that build server plugins should use postgresql package in BuildRequires, others should use libpq. In case of Postgresql-server, rebuild should be done to make sure all potential binary incompatibilities are handled.
- PostgreSQL server dependecies
- perl-DBD-Pg
- pgaudit
- qt
- qt3
- qt5-qtbase
- postgres-decoderbufs
- gambas3
- kdb
- kea
- libpqxx
- openvas-manager
- orafce
- pg-semver
- pgRouting
- pgadmin3
- pgsphere
- postgis
- postgresql-ip4r
- postgresql-pgpool-II
- qt3
- rdkit
- rhdb-utils
- timescaledb
- pg_repack
Contingency Plan
Revert changes in the non-modular packages and provide PostgreSQL 14 as a module stream only.
Documentation
Upgrade strategy: https://www.postgresql.org/docs/14/upgrading.html
Release Notes
Release notes for PostgreSQL 14 release: https://www.postgresql.org/docs/14/index.html
Overall overview of the changes and improvements: https://www.postgresql.org/docs/14/release-14.html