F36 Change: PostgreSQL 14 (Self-Contained Change proposal)

[Ben Cotton]

https://fedoraproject.org/wiki/Changes/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: [[User:fjanus| Filip Januš]]
* Email: fjanus(a)redhat.com


== 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 ==

<!-- Summarize the feedback from the community and address why you
chose not to accept proposed alternatives. This section is optional
for all change proposals but is strongly suggested. Incorporating
feedback here as it is raised gives FESCo a clearer view of your
proposal and leaves a good record for the future. If you get no
feedback, that is useful to note in this section as well. For
innovative or possibly controversial ideas, consider collecting
feedback before you file the change proposal. -->

== Benefit to Fedora ==

The latest stable software is used by Fedora users.

== Scope ==
* Proposal owners:
<!-- What work do the feature owners have to accomplish to complete
the feature in time for release?  Is it a large change affecting many
parts of the distribution or is it a very isolated change? What are
those changes?-->
**Prepare PostgreSQL 14
**Prepare PostgreSQL 13 as a module for Rawhide
**Check software that requires or depends on `postgresql-server` or
`libpq` 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: [https://pagure.io/releng/issues #Releng issue number]
* 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


-- 
Ben Cotton
He / Him / His
Fedora Program Manager
Red Hat
TZ=America/Indiana/Indianapolis

[Bruno Wolff III]

On Thu, Nov 25, 2021 at 16:52:59 -0500,
  Ben Cotton <bcotton(a)redhat.com&gt; wrote:
> https://fedoraproject.org/wiki/Changes/PostgreSQL_14
>
> == Summary ==
> Update of PostgreSQL (`postgresql` and `libpq` components) in Fedora
> from version 13 to version 14 in the non-modular (main) builds.
>
> == Feedback == 
I'm all for it. I have been running PGDG Red Hat binaries for 14 for 
about 2 months on a RHEL machine at work and have not seen any issues.

When it gets into Rawhide, I'll be testing it on a work desktop where 
I use Postgres to analyze data for some work tasks.

There isn't any feature in this release that I am personally really looking 
forward to, but there are some performance related ones that could 
provide some immediate benefit. I do like being on the latest release 
in case something new I want to do would benefit from it.

[Bruno Wolff III]

It looks like qt3, kdb and pgadmin3 still need to be rebuilt after the 
recent build of postgresql 14.1 in rawhide, because they depend on 
libpq.so.private13-5()(64bit).