Recommended update for postgresql14, postgresql15

Announcement ID: SUSE-RU-2023:0038-1
Rating: moderate
References:
Affected Products:
  • SUSE Linux Enterprise High Performance Computing 12 SP2
  • SUSE Linux Enterprise High Performance Computing 12 SP4
  • SUSE Linux Enterprise High Performance Computing 12 SP5
  • SUSE Linux Enterprise Server 12 SP2
  • SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2
  • SUSE Linux Enterprise Server 12 SP4
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4
  • SUSE Linux Enterprise Server 12 SP5
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5
  • SUSE Linux Enterprise Software Development Kit 12 SP5
  • SUSE OpenStack Cloud 9
  • SUSE OpenStack Cloud Crowbar 9

An update that has one fix can now be installed.

Description:

This update for postgresql14, postgresql15 fixes the following issues:

postgresql15 is shipped:

Update to 15.1:

  • https://www.postgresql.org/about/news/2543/
  • https://www.postgresql.org/docs/15/release-15-1.html

Update to 15.0:

  • https://www.postgresql.org/about/news/p-2526/
  • https://www.postgresql.org/docs/15/release-15.html

Changes in postgresql14:

Update to 14.6: (bsc#1205300)

  • https://www.postgresql.org/about/news/2543/
  • https://www.postgresql.org/docs/14/release-14-6.html

Patch Instructions:

To install this SUSE update use the SUSE recommended installation methods like YaST online_update or "zypper patch".
Alternatively you can run the command listed for your product:

  • SUSE OpenStack Cloud 9
    zypper in -t patch SUSE-OpenStack-Cloud-9-2023-38=1
  • SUSE OpenStack Cloud Crowbar 9
    zypper in -t patch SUSE-OpenStack-Cloud-Crowbar-9-2023-38=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4
    zypper in -t patch SUSE-SLE-SAP-12-SP4-2023-38=1
  • SUSE Linux Enterprise Software Development Kit 12 SP5
    zypper in -t patch SUSE-SLE-SDK-12-SP5-2023-38=1
  • SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2
    zypper in -t patch SUSE-SLE-SERVER-12-SP2-BCL-2023-38=1
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4
    zypper in -t patch SUSE-SLE-SERVER-12-SP4-ESPOS-2023-38=1
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4
    zypper in -t patch SUSE-SLE-SERVER-12-SP4-LTSS-2023-38=1
  • SUSE Linux Enterprise High Performance Computing 12 SP5
    zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-38=1
  • SUSE Linux Enterprise Server 12 SP5
    zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-38=1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5
    zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-38=1

Package List:

  • SUSE OpenStack Cloud 9 (x86_64)
    • libecpg6-15.1-3.3.6
    • libecpg6-debuginfo-15.1-3.3.6
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • libpq5-debuginfo-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
  • SUSE OpenStack Cloud 9 (noarch)
    • postgresql-15-4.20.1
    • postgresql-server-15-4.20.1
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE OpenStack Cloud Crowbar 9 (x86_64)
    • libecpg6-15.1-3.3.6
    • libecpg6-debuginfo-15.1-3.3.6
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • libpq5-debuginfo-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
  • SUSE OpenStack Cloud Crowbar 9 (noarch)
    • postgresql-15-4.20.1
    • postgresql-server-15-4.20.1
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4 (ppc64le x86_64)
    • libpq5-debuginfo-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • libecpg6-15.1-3.3.6
    • libecpg6-debuginfo-15.1-3.3.6
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4 (noarch)
    • postgresql-15-4.20.1
    • postgresql-server-15-4.20.1
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP4 (x86_64)
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
  • SUSE Linux Enterprise Software Development Kit 12 SP5 (noarch)
    • postgresql-devel-15-4.20.1
    • postgresql-server-devel-15-4.20.1
  • SUSE Linux Enterprise Software Development Kit 12 SP5 (aarch64 ppc64le s390x x86_64)
    • postgresql14-debugsource-14.6-3.17.6
    • postgresql15-server-devel-15.1-3.3.6
    • postgresql14-devel-debuginfo-14.6-3.17.6
    • postgresql14-devel-14.6-3.17.6
    • postgresql15-devel-15.1-3.3.6
    • postgresql15-server-devel-debuginfo-15.1-3.3.6
    • postgresql15-devel-debuginfo-15.1-3.3.6
  • SUSE Linux Enterprise Software Development Kit 12 SP5 (ppc64le s390x x86_64)
    • postgresql14-server-devel-debuginfo-14.6-3.17.6
    • postgresql14-server-devel-14.6-3.17.6
  • SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2 (x86_64)
    • libecpg6-15.1-3.3.6
    • libecpg6-debuginfo-15.1-3.3.6
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • libpq5-debuginfo-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
  • SUSE Linux Enterprise Server 12 SP2 BCL 12-SP2 (noarch)
    • postgresql-15-4.20.1
    • postgresql-server-15-4.20.1
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (aarch64 x86_64)
    • libpq5-debuginfo-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • libecpg6-15.1-3.3.6
    • libecpg6-debuginfo-15.1-3.3.6
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (noarch)
    • postgresql-15-4.20.1
    • postgresql-server-15-4.20.1
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE Linux Enterprise Server 12 SP4 ESPOS 12-SP4 (x86_64)
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (aarch64 ppc64le s390x x86_64)
    • libpq5-debuginfo-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • libecpg6-15.1-3.3.6
    • libecpg6-debuginfo-15.1-3.3.6
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (noarch)
    • postgresql-15-4.20.1
    • postgresql-server-15-4.20.1
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE Linux Enterprise Server 12 SP4 LTSS 12-SP4 (s390x x86_64)
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
  • SUSE Linux Enterprise High Performance Computing 12 SP5 (aarch64 x86_64)
    • postgresql15-pltcl-debuginfo-15.1-3.3.6
    • libecpg6-15.1-3.3.6
    • postgresql14-plperl-14.6-3.17.6
    • postgresql14-pltcl-14.6-3.17.6
    • postgresql14-plpython-debuginfo-14.6-3.17.6
    • postgresql15-plperl-15.1-3.3.6
    • postgresql15-server-debuginfo-15.1-3.3.6
    • postgresql15-contrib-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • postgresql15-contrib-debuginfo-15.1-3.3.6
    • postgresql14-plpython-14.6-3.17.6
    • postgresql15-server-15.1-3.3.6
    • postgresql15-debugsource-15.1-3.3.6
    • postgresql14-14.6-3.17.6
    • libecpg6-debuginfo-15.1-3.3.6
    • postgresql15-plpython-debuginfo-15.1-3.3.6
    • postgresql14-contrib-debuginfo-14.6-3.17.6
    • postgresql15-debuginfo-15.1-3.3.6
    • postgresql14-debuginfo-14.6-3.17.6
    • postgresql14-plperl-debuginfo-14.6-3.17.6
    • postgresql14-server-14.6-3.17.6
    • postgresql15-plpython-15.1-3.3.6
    • postgresql14-debugsource-14.6-3.17.6
    • postgresql14-pltcl-debuginfo-14.6-3.17.6
    • postgresql15-15.1-3.3.6
    • postgresql14-server-debuginfo-14.6-3.17.6
    • postgresql14-contrib-14.6-3.17.6
    • postgresql15-pltcl-15.1-3.3.6
    • libpq5-debuginfo-15.1-3.3.6
    • postgresql15-plperl-debuginfo-15.1-3.3.6
  • SUSE Linux Enterprise High Performance Computing 12 SP5 (noarch)
    • postgresql-15-4.20.1
    • postgresql14-docs-14.6-3.17.6
    • postgresql-server-15-4.20.1
    • postgresql15-docs-15.1-3.3.6
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE Linux Enterprise High Performance Computing 12 SP5 (x86_64)
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
    • libecpg6-debuginfo-32bit-15.1-3.3.6
    • libecpg6-32bit-15.1-3.3.6
  • SUSE Linux Enterprise Server 12 SP5 (aarch64 ppc64le s390x x86_64)
    • postgresql15-pltcl-debuginfo-15.1-3.3.6
    • libecpg6-15.1-3.3.6
    • postgresql14-plperl-14.6-3.17.6
    • postgresql14-pltcl-14.6-3.17.6
    • postgresql14-plpython-debuginfo-14.6-3.17.6
    • postgresql15-plperl-15.1-3.3.6
    • postgresql15-server-debuginfo-15.1-3.3.6
    • postgresql15-contrib-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • postgresql15-contrib-debuginfo-15.1-3.3.6
    • postgresql14-plpython-14.6-3.17.6
    • postgresql15-server-15.1-3.3.6
    • postgresql15-debugsource-15.1-3.3.6
    • postgresql14-14.6-3.17.6
    • libecpg6-debuginfo-15.1-3.3.6
    • postgresql15-plpython-debuginfo-15.1-3.3.6
    • postgresql14-contrib-debuginfo-14.6-3.17.6
    • postgresql15-debuginfo-15.1-3.3.6
    • postgresql14-debuginfo-14.6-3.17.6
    • postgresql14-plperl-debuginfo-14.6-3.17.6
    • postgresql14-server-14.6-3.17.6
    • postgresql15-plpython-15.1-3.3.6
    • postgresql14-debugsource-14.6-3.17.6
    • postgresql14-pltcl-debuginfo-14.6-3.17.6
    • postgresql15-15.1-3.3.6
    • postgresql14-server-debuginfo-14.6-3.17.6
    • postgresql14-contrib-14.6-3.17.6
    • postgresql15-pltcl-15.1-3.3.6
    • libpq5-debuginfo-15.1-3.3.6
    • postgresql15-plperl-debuginfo-15.1-3.3.6
  • SUSE Linux Enterprise Server 12 SP5 (noarch)
    • postgresql-15-4.20.1
    • postgresql14-docs-14.6-3.17.6
    • postgresql-server-15-4.20.1
    • postgresql15-docs-15.1-3.3.6
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE Linux Enterprise Server 12 SP5 (s390x x86_64)
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
    • libecpg6-debuginfo-32bit-15.1-3.3.6
    • libecpg6-32bit-15.1-3.3.6
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5 (ppc64le x86_64)
    • postgresql15-pltcl-debuginfo-15.1-3.3.6
    • libecpg6-15.1-3.3.6
    • postgresql14-plperl-14.6-3.17.6
    • postgresql14-pltcl-14.6-3.17.6
    • postgresql14-plpython-debuginfo-14.6-3.17.6
    • postgresql15-plperl-15.1-3.3.6
    • postgresql15-server-debuginfo-15.1-3.3.6
    • postgresql15-contrib-15.1-3.3.6
    • libpq5-15.1-3.3.6
    • postgresql15-contrib-debuginfo-15.1-3.3.6
    • postgresql14-plpython-14.6-3.17.6
    • postgresql15-server-15.1-3.3.6
    • postgresql15-debugsource-15.1-3.3.6
    • postgresql14-14.6-3.17.6
    • libecpg6-debuginfo-15.1-3.3.6
    • postgresql15-plpython-debuginfo-15.1-3.3.6
    • postgresql14-contrib-debuginfo-14.6-3.17.6
    • postgresql15-debuginfo-15.1-3.3.6
    • postgresql14-debuginfo-14.6-3.17.6
    • postgresql14-plperl-debuginfo-14.6-3.17.6
    • postgresql14-server-14.6-3.17.6
    • postgresql15-plpython-15.1-3.3.6
    • postgresql14-debugsource-14.6-3.17.6
    • postgresql14-pltcl-debuginfo-14.6-3.17.6
    • postgresql15-15.1-3.3.6
    • postgresql14-server-debuginfo-14.6-3.17.6
    • postgresql14-contrib-14.6-3.17.6
    • postgresql15-pltcl-15.1-3.3.6
    • libpq5-debuginfo-15.1-3.3.6
    • postgresql15-plperl-debuginfo-15.1-3.3.6
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5 (noarch)
    • postgresql-15-4.20.1
    • postgresql14-docs-14.6-3.17.6
    • postgresql-server-15-4.20.1
    • postgresql15-docs-15.1-3.3.6
    • postgresql-plpython-15-4.20.1
    • postgresql-pltcl-15-4.20.1
    • postgresql-docs-15-4.20.1
    • postgresql-contrib-15-4.20.1
    • postgresql-plperl-15-4.20.1
  • SUSE Linux Enterprise Server for SAP Applications 12 SP5 (x86_64)
    • libpq5-debuginfo-32bit-15.1-3.3.6
    • libpq5-32bit-15.1-3.3.6
    • libecpg6-debuginfo-32bit-15.1-3.3.6
    • libecpg6-32bit-15.1-3.3.6

References: