• Icon: Epic Epic
    • Resolution: Done
    • Icon: Undefined Undefined
    • rhel-9.4
    • None
    • postgresql
    • None
    • PostgreSQL 16 in RHEL-9
    • Hide

      The following needs to be verified in order for this epic to be considered complete:

      • postgresql-server, postgresql and other common packages of PostgreSQL 16 available in the repository
      • plugins that were part of PostgreSQL 15 stream also available
      • Container image exists in the Container catalot
      Show
      The following needs to be verified in order for this epic to be considered complete: postgresql-server, postgresql and other common packages of PostgreSQL 16 available in the repository plugins that were part of PostgreSQL 15 stream also available Container image exists in the Container catalot
    • rhel-sst-cs-databases
    • 22
    • 24
    • 8
    • False
    • Hide

      None

      Show
      None
    • Yes
    • Enhancement
    • Hide
      .A new module stream: `postgresql:16`

      RHEL 9.4 introduces PostgreSQL 16 as the `postgresql:16` module stream. PostgreSQL 16 provides a number of new features and enhancements over version 15.

      Notable enhancements include:

      * Enhanced bulk loading improves performance.

      * The `libpq` library now supports connection-level load balancing. You can use the new `load_balance_hosts` option for more efficient load balancing.

      * You can now create custom configuration files and include them in the `pg_hba.conf` and `pg_ident.conf` files.

      * PostgreSQL now supports regular expression matching on database and role entries in the `pg_hba.conf` file.

      Other changes include:

      * PostgreSQL is no longer distributed with the `postmaster` binary. Users who start the `postgresql` server by using the provided `systemd` unit file (the `systemctl start postgres` command) are not affected by this change. If you previously started the `postgresql` server directly through the `postmaster` binary, you must now use the `postgres` binary instead.

      * PostgreSQL no longer provides documentation in PDF format within the package. Use the link:https://www.postgresql.org/files/documentation/pdf/16/postgresql-16-US.pdf[online documentation] instead.

      See also https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/configuring_and_using_database_servers/index#using-postgresql_configuring-and-using-database-servers[Using PostgreSQL].

      To install the `postgresql:16` stream, use the following command:

      [literal]
      ----
      # dnf module install postgresql:16
      ----

      If you want to upgrade from an earlier `postgresql` stream within RHEL 9, follow the procedure described in link:https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html/managing_software_with_the_dnf_tool/assembly_managing-versions-of-application-stream-content_managing-software-with-the-dnf-tool#proc_switching-to-a-later-stream_assembly_managing-versions-of-application-stream-content[Switching to a later stream] and then migrate your PostgreSQL data as described in https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/configuring_and_using_database_servers/index#migrating-to-a-rhel-9-version-of-postgresql_using-postgresql[Migrating to a RHEL 9 version of PostgreSQL].

      For information about the length of support for the `postgresql` module streams, see the link:https://access.redhat.com/support/policy/updates/rhel-app-streams-life-cycle[Red Hat Enterprise Linux Application Streams Life Cycle].
      Show
      .A new module stream: `postgresql:16` RHEL 9.4 introduces PostgreSQL 16 as the `postgresql:16` module stream. PostgreSQL 16 provides a number of new features and enhancements over version 15. Notable enhancements include: * Enhanced bulk loading improves performance. * The `libpq` library now supports connection-level load balancing. You can use the new `load_balance_hosts` option for more efficient load balancing. * You can now create custom configuration files and include them in the `pg_hba.conf` and `pg_ident.conf` files. * PostgreSQL now supports regular expression matching on database and role entries in the `pg_hba.conf` file. Other changes include: * PostgreSQL is no longer distributed with the `postmaster` binary. Users who start the `postgresql` server by using the provided `systemd` unit file (the `systemctl start postgres` command) are not affected by this change. If you previously started the `postgresql` server directly through the `postmaster` binary, you must now use the `postgres` binary instead. * PostgreSQL no longer provides documentation in PDF format within the package. Use the link: https://www.postgresql.org/files/documentation/pdf/16/postgresql-16-US.pdf [online documentation] instead. See also https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/configuring_and_using_database_servers/index#using-postgresql_configuring-and-using-database-servers [Using PostgreSQL]. To install the `postgresql:16` stream, use the following command: [literal] ---- # dnf module install postgresql:16 ---- If you want to upgrade from an earlier `postgresql` stream within RHEL 9, follow the procedure described in link: https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html/managing_software_with_the_dnf_tool/assembly_managing-versions-of-application-stream-content_managing-software-with-the-dnf-tool#proc_switching-to-a-later-stream_assembly_managing-versions-of-application-stream-content [Switching to a later stream] and then migrate your PostgreSQL data as described in https://access.redhat.com/documentation/en-us/red_hat_enterprise_linux/9/html-single/configuring_and_using_database_servers/index#migrating-to-a-rhel-9-version-of-postgresql_using-postgresql [Migrating to a RHEL 9 version of PostgreSQL]. For information about the length of support for the `postgresql` module streams, see the link: https://access.redhat.com/support/policy/updates/rhel-app-streams-life-cycle [Red Hat Enterprise Linux Application Streams Life Cycle].
    • Done

      Description

      Based on BU feedback, there is already enough demand for a new PostgreSQL 16 version.

      This is a request to include a new stream (module) into RHEL-9, that will deliver:

      • PostgreSQL server 16 and client
      • plugins we've had in PostgreSQL 15 (postgresql, pgaudit, postgres-decoderbufs, pg_repack)
      • Container image for OpenShift, meant to be used for development mostly (single server, basic features)

              fjanus@redhat.com Filip Janus
              hhorak@redhat.com Honza Horak
              Filip Janus Filip Janus
              Vaclav Danek Vaclav Danek
              Lenka Špačková Lenka Špačková
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

                Created:
                Updated:
                Resolved: