E.3. Postgres Pro Standard 13.13.1

Release Date: 2023-11-16

E.3.1. Overview

This release is based on PostgreSQL 13.13 and Postgres Pro Standard 13.12.2. All improvements inherited from PostgreSQL 13.13 are listed in PostgreSQL 13.13 Release Notes. Other major changes and enhancements are as follows:

  • Added new configuration parameters pgpro_build, pgpro_edition, and pgpro_version, which report the Postgres Pro source code commit ID, edition, and server version respectively.

  • Added support for ALT SP Release 10.

  • Added support for Ubuntu 23.10.

  • Fixed an internal issue that could arise when an index relation was moved to a different namespace similarly to a plain relation.

  • Upgraded oracle_fdw to version 2.6.0.

  • Upgraded orafce to version 4.6.1.

  • Upgraded pg_filedump to version 16.0.

  • Upgraded pgbouncer to version 1.20.1.

  • Upgraded pg_probackup to version 2.6.6, which in particular improved stability of the catchup command.

  • Upgraded pgpro_controldata to version 16.1.0.

  • Upgraded pgpro_stats to version 1.6.3, which in particular fixed a code issue that prevented data generation for the pgpro_stats_vacuum_tables view. Accordingly the Database vacuum statistics table was not included in the pgpro_pwr report.

  • Upgraded PTRACK to version 2.5.1 Enterprise.

E.3.2. Migration to Version 13.13.1

If you are upgrading from Postgres Pro Standard based on the same PostgreSQL major version, it is enough to install the new version into your current installation directory.

When upgrading from Postgres Pro versions 13.2.1 or lower, rebuild indexes containing at least one included column of type for which the collation was defined in the table.

If you are upgrading from Postgres Pro versions 13.2.2 or lower and take PTRACK backups using pg_probackup, retake a full backup after upgrade.

When upgrading to Postgres Pro versions starting with 13.11.1, make sure to upgrade pg_probackup to version 2.6.3 or higher since lower versions are incompatible with these Postgres Pro versions.

To migrate from PostgreSQL or a Postgres Pro Standard release based on a previous PostgreSQL major version, see the instructions in Postgres Pro Standard 13.1.1 Release Notes.