Fedora 32 Self-Contained Change proposal: PostgreSQL 12
https://fedoraproject.org/wiki/Changes/PostgreSQL_12
== Summary ==
Update of PostgreSQL (`postgresql` and `libpq` components) in Fedora
from 11 to 12 version in the non-modular (main) builds.
== Owner ==
* Name: [[User:panovotn| Patrik Novotny]]
* Email: panovotn(a)redhat.com
== Detailed Description ==
Update of PostgreSQL (`postgresql` and `libpq` components) in Fedora
from 11 to 12 version in the non-modular (main) builds.
This also involves updating and rebuilding the PostgreSQL plugins that
depend on postgresql server.
== Benefit to Fedora ==
Latest stable software is used by Fedora users.
Version v12 of PostgreSQL introduces several enahncements and
performance improvementes:
https://www.postgresql.org/about/news/1976/
== Scope ==
* Proposal owners:
**Prepare PostgreSQL 12 as a module for Rawhide and at least one
stable Fedora release (done)
**Prepare PostgreSQL 11 as a module for Rawhide, so there would be a
failover in case of problems
**Build PostgreSQL 12 to Rawhide
**Check software that requires or depends on `postgresql-server` or
`libpq` packages for incompatibilities
**Gather user input on the changes between PostgreSQL 11 and PostgreSQL 12
* Other developers: N/A (not a System Wide Change)
* Policies and guidelines: N/A
* 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, but rebuild of the depended components
is better to be sure.
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 12.
== User Experience ==
The users will have to upgrade their databases the same way as between
major PostgreSQL versions, aka `postgresql-setup --upgrade`.
If users want to stick with PostgreSQL 11 for a little longer, there
should be PostgreSQL 11 module.
If users want to test it before it reaches Fedora 32, there is
PostgreSQL 12 module already.
== 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 both
the cases, rebuild should be done to make sure all potential binary
incompatibilities are handled.
== Contingency Plan ==
Modules will provide the functional version of PostgreSQL 11,
available to all users.
* Contingency mechanism: Fedora Modules available
* Contingency deadline: beta freeze
* Blocks release? N/A (not a System Wide Change)
* Blocks product? N/A (not a System Wide Change)
== Documentation ==
Upgrade startegy: https://www.postgresql.org/docs/12/upgrading.html
== Release Notes ==
Release notes for PostgreSQL 12 release:
https://www.postgresql.org/docs/12/index.html
Overall overview of the changes and improvements:
https://www.postgresql.org/about/news/1976/
--
Ben Cotton
He / Him / His
Fedora Program Manager
Red Hat
TZ=America/Indiana/Indianapolis