Uploaded image for project: 'RHEL'
  1. RHEL
  2. RHEL-62694

Review upgrade path RHEL9->RHEL10 (Postgresql)

Linking RHIVOS CVEs to...Migration: Automation ...SWIFT: POC ConversionSync from "Extern...XMLWordPrintable

    • Icon: Story Story
    • Resolution: Done
    • Icon: Major Major
    • rhel-10.0
    • None
    • postgresql16
    • None
    • None
    • rhel-databases
    • 8
    • False
    • False
    • Hide

      None

      Show
      None
    • Yes
    • None
    • None
    • None
    • Enhancement
    • Hide
      .RHEL 10 introduces PostgreSQL 16

      RHEL 10 is distributed with PostgreSQL version 16.

      Notable enhancements include:

      * The enhanced bulk loading improves the performance.

      * The new `load_balance_hosts` option in the `libpq` library supports more efficient load balancing.

      * Configuration files in the `/var/lib/pgsql/data/` directory support including custom `pg_hba.conf` and `pg_ident.conf` files.

      * The `/var/lib/pgsql/data/pg_hba.conf` file supports regular expression matching on database and role entries.

      Other changes include:

      * Absence of the `postmaster` binary. Use the `postgres` binary instead. This change affects only user who use `postmaster` to start the service.

      * Absence of the PDF documentation within the package. Use the link:https://www.postgresql.org/files/documentation/pdf/16/postgresql-16-US.pdf[upstream documentation] instead.

      For more information, see link: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 PostgreSQL 16, enter:

      [literal]
      ----
      # dnf install postgresql16
      ----
      Show
      .RHEL 10 introduces PostgreSQL 16 RHEL 10 is distributed with PostgreSQL version 16. Notable enhancements include: * The enhanced bulk loading improves the performance. * The new `load_balance_hosts` option in the `libpq` library supports more efficient load balancing. * Configuration files in the `/var/lib/pgsql/data/` directory support including custom `pg_hba.conf` and `pg_ident.conf` files. * The `/var/lib/pgsql/data/pg_hba.conf` file supports regular expression matching on database and role entries. Other changes include: * Absence of the `postmaster` binary. Use the `postgres` binary instead. This change affects only user who use `postmaster` to start the service. * Absence of the PDF documentation within the package. Use the link: https://www.postgresql.org/files/documentation/pdf/16/postgresql-16-US.pdf [upstream documentation] instead. For more information, see link: 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 PostgreSQL 16, enter: [literal] ---- # dnf install postgresql16 ----
    • Done
    • None

      • Review possible configuration breaking changes
      • Review and test in-place upgrade (RHEL9->RHEL10)
      • Prepare leap actor if necessary, at least with a warning about backup before the upgrade and link the documentation
      • Sync with doc team

       2024-12-17 (ITM 16) start QA folks Components Upgradability Test (CUT), so let's handle it before ITM16

      More info in https://issues.redhat.com/browse/RHELMISC-4053

              fjanus@redhat.com Filip Janus
              fjanus@redhat.com Filip Janus
              Filip Janus Filip Janus
              Vaclav Danek Vaclav Danek
              Marc Muehlfeld Marc Muehlfeld
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: