From Fedora Project Wiki
No edit summary
No edit summary
Line 74: Line 74:
**Build PostgreSQL 16 (postgresql and libpq) for Rawhide
**Build PostgreSQL 16 (postgresql and libpq) for Rawhide
**Build PostgreSQL 15 for Rawhide
**Build PostgreSQL 15 for Rawhide
**Rebuild dependent packages against PostgreSQL 14
**Rebuild dependent packages against PostgreSQL 16




Line 135: Line 135:
  - Green has been scientifically proven to be the most relaxing color. The move to a default background color of green with green text will result in Fedora users being the most relaxed users of any operating system.
  - Green has been scientifically proven to be the most relaxing color. The move to a default background color of green with green text will result in Fedora users being the most relaxed users of any operating system.
-->
-->
The users will have to upgrade their databases the same way as between major PostgreSQL versions, aka `postgresql-setup --upgrade` after installing PostgreSQL 16 server packages.
If users want to stick with PostgreSQL 15 for a little longer, there will be PostgreSQL 15 as nondefault PostgreSQL stream


== Dependencies ==
== Dependencies ==
Line 141: Line 146:
<!-- REQUIRED FOR SYSTEM WIDE CHANGES -->
<!-- REQUIRED FOR SYSTEM WIDE CHANGES -->


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 the case of Postgresql-server, a rebuild should be done to ensure 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 ==
== Contingency Plan ==
Line 150: Line 182:
<!-- Does finishing this feature block the release, or can we ship with the feature in incomplete state? -->
<!-- Does finishing this feature block the release, or can we ship with the feature in incomplete state? -->
* Blocks release? N/A (not a System Wide Change), Yes/No <!-- REQUIRED FOR SYSTEM WIDE CHANGES -->
* Blocks release? N/A (not a System Wide Change), Yes/No <!-- REQUIRED FOR SYSTEM WIDE CHANGES -->
 
Revert the changes and provide PostgreSQL 15 only.


== Documentation ==
== Documentation ==
<!-- Is there upstream documentation on this change, or notes you have written yourself?  Link to that material here so other interested developers can get involved. -->
<!-- Is there upstream documentation on this change, or notes you have written yourself?  Link to that material here so other interested developers can get involved. -->
Upgrade strategy: https://www.postgresql.org/docs/16/upgrading.html


<!-- REQUIRED FOR SYSTEM WIDE CHANGES -->
<!-- REQUIRED FOR SYSTEM WIDE CHANGES -->
Line 164: Line 198:
Release Notes are not required for initial draft of the Change Proposal but has to be completed by the Change Freeze.  
Release Notes are not required for initial draft of the Change Proposal but has to be completed by the Change Freeze.  
-->
-->
Release notes for PostgreSQL 16 release: https://www.postgresql.org/docs/16/index.html
Overall overview of the changes and improvements: https://www.postgresql.org/docs/16/release-16.html

Revision as of 09:30, 2 October 2023

Comments and Explanations
The page source contains comments providing guidance to fill out each section. They are invisible when viewing this page. To read it, choose the "view source" link.
Copy the source to a new page before making changes! DO NOT EDIT THIS TEMPLATE FOR YOUR CHANGE PROPOSAL.
Guidance
For details on how to fill out this form, see the documentation.
Report issues
To report an issue with this template, file an issue in the pgm_docs repo.


PostgreSQL 16

This is a proposed Change for Fedora Linux.
This document represents a proposed Change. As part of the Changes process, proposals are publicly announced in order to receive community feedback. This proposal will only be implemented if approved by the Fedora Engineering Steering Committee.

Summary

Update of default PostgreSQL stream (postgresql and libpq components) in Fedora from version 15 to version 16. Since no more modules are supported, there will also be a change in the packaging concept.

Owner


Current status

  • Targeted release: Fedora Linux 40
  • Last updated: 2023-10-02
  • [<will be assigned by the Wrangler> devel thread]
  • 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

The original package PostgreSQL will be retired. From Fedora 40 there will be a separate component in the rpms namespace for each shipped PostgreSQL. So postgresql15 for PG15 and postgresql16 for PG16. Each PG stream will provide postgresql symbol and conflict with each other. The choice of default stream will be made by building sub-packages with appropriate names. (using -n in the files section)

This also involves updating and rebuilding the PostgreSQL plugins that depend on postgresql server.

Feedback

Benefit to Fedora

The latest stable software is provided for Fedora users. Modules are no longer needed.

Scope

  • Proposal owners:
    • Prepare PostgreSQL 16 as the default stream
    • Prepare PostgreSQL 15 as a non-default stream
    • Check software that requires or depends on postgresql-server or libpq packages for incompatibilities
    • Build PostgreSQL 16 (postgresql and libpq) for Rawhide
    • Build PostgreSQL 15 for Rawhide
    • Rebuild dependent packages against PostgreSQL 16


  • Other developers:
  • Policies and guidelines: N/A (not needed for this Change)
  • Trademark approval: N/A (not needed for this Change)
  • Alignment with Community Initiatives:

Upgrade/compatibility impact

The PostgreSQL client library (libpq component) is compatible. So, there shouldn't be any compatibility issues, but rebuild of the dependent components is recommended.

Server plugins might require a newer version update because they sometimes have explicit server requirements.


How To Test

All PG server plugins should be installable. postgresql-setup --upgrade command should succeed.

Test that all other software runs well with PostgreSQL 16.

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 16 server packages.

If users want to stick with PostgreSQL 15 for a little longer, there will be PostgreSQL 15 as nondefault PostgreSQL stream

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 the case of Postgresql-server, a rebuild should be done to ensure 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

  • Contingency mechanism: (What to do? Who will do it?) N/A (not a System Wide Change)
  • Contingency deadline: N/A (not a System Wide Change)
  • Blocks release? N/A (not a System Wide Change), Yes/No

Revert the changes and provide PostgreSQL 15 only.

Documentation

Upgrade strategy: https://www.postgresql.org/docs/16/upgrading.html

N/A (not a System Wide Change)

Release Notes

Release notes for PostgreSQL 16 release: https://www.postgresql.org/docs/16/index.html

Overall overview of the changes and improvements: https://www.postgresql.org/docs/16/release-16.html