SUSE-SU-2023:4495-1: important: Security update for postgresql, postgresql15, postgresql16

21 Nov 2023

      # Security update for postgresql, postgresql15, postgresql16

Announcement ID: SUSE-SU-2023:4495-1  
Rating: important  
References:

  * bsc#1122892
  * bsc#1179231
  * bsc#1206796
  * bsc#1209208
  * bsc#1216022
  * bsc#1216734
  * bsc#1216960
  * bsc#1216961
  * bsc#1216962
  * jsc#PED-5586

Cross-References:

  * CVE-2023-5868
  * CVE-2023-5869
  * CVE-2023-5870

CVSS scores:

  * CVE-2023-5868 ( SUSE ):  7.5 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N
  * CVE-2023-5869 ( SUSE ):  9.8 CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H
  * CVE-2023-5870 ( SUSE ):  6.2 CVSS:3.1/AV:L/AC:L/PR:N/UI:N/S:U/C:N/I:N/A:H

Affected Products:

  * Basesystem Module 15-SP4
  * Basesystem Module 15-SP5
  * Legacy Module 15-SP4
  * Legacy Module 15-SP5
  * openSUSE Leap 15.3
  * openSUSE Leap 15.4
  * openSUSE Leap 15.5
  * Server Applications Module 15-SP4
  * Server Applications Module 15-SP5
  * SUSE Enterprise Storage 7.1
  * SUSE Linux Enterprise Desktop 15 SP4
  * SUSE Linux Enterprise Desktop 15 SP5
  * SUSE Linux Enterprise High Performance Computing 15 SP2
  * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2
  * SUSE Linux Enterprise High Performance Computing 15 SP3
  * SUSE Linux Enterprise High Performance Computing 15 SP4
  * SUSE Linux Enterprise High Performance Computing 15 SP5
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3
  * SUSE Linux Enterprise Micro 5.3
  * SUSE Linux Enterprise Micro 5.4
  * SUSE Linux Enterprise Micro 5.5
  * SUSE Linux Enterprise Micro 6.0
  * SUSE Linux Enterprise Real Time 15 SP4
  * SUSE Linux Enterprise Real Time 15 SP5
  * SUSE Linux Enterprise Server 15 SP2
  * SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2
  * SUSE Linux Enterprise Server 15 SP3
  * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3
  * SUSE Linux Enterprise Server 15 SP4
  * SUSE Linux Enterprise Server 15 SP5
  * SUSE Linux Enterprise Server for SAP Applications 15 SP2
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3
  * SUSE Linux Enterprise Server for SAP Applications 15 SP4
  * SUSE Linux Enterprise Server for SAP Applications 15 SP5
  * SUSE Manager Proxy 4.3
  * SUSE Manager Retail Branch Server 4.3
  * SUSE Manager Server 4.3
  * SUSE Package Hub 15 15-SP4
  * SUSE Package Hub 15 15-SP5

An update that solves three vulnerabilities, contains one feature and has six
security fixes can now be installed.

## Description:

This update for postgresql, postgresql15, postgresql16 fixes the following
issues:

This update ships postgresql 16.

Security issues fixed:

  * CVE-2023-5868: Fix handling of unknown-type arguments in DISTINCT "any"
    aggregate functions. This error led to a text-type value being interpreted
    as an unknown-type value (that is, a zero-terminated string) at runtime.
    This could result in disclosure of server memory following the text value.
    (bsc#1216962)
  * CVE-2023-5869: Detect integer overflow while computing new array dimensions.
    When assigning new elements to array subscripts that are outside the current
    array bounds, an undetected integer overflow could occur in edge cases.
    Memory stomps that are potentially exploitable for arbitrary code execution
    are possible, and so is disclosure of server memory. (bsc#1216961)
  * CVE-2023-5870: Prevent the pg_signal_backend role from signalling background
    workers and autovacuum processes. The documentation says that
    pg_signal_backend cannot issue signals to superuser-owned processes. It was
    able to signal these background processes, though, because they advertise a
    role OID of zero. Treat that as indicating superuser ownership. The security
    implications of cancelling one of these process types are fairly small so
    far as the core code goes (we'll just start another one), but extensions
    might add background workers that are more vulnerable. Also ensure that the
    is_superuser parameter is set correctly in such processes. No specific
    security consequences are known for that oversight, but it might be
    significant for some extensions. (bsc#1216960)

Changes in postgresql16:

  * Upgrade to 16.1:

  * https://www.postgresql.org/about/news/2715

  * https://www.postgresql.org/docs/16/release-16.html
  * https://www.postgresql.org/docs/16/release-16-1.html

  * Overhaul postgresql-README.SUSE and move it from the binary package to the
    noarch wrapper package.

  * Change the unix domain socket location from /var/run to /run.

Changes in postgresql15:

  * Update to 15.5 https://www.postgresql.org/docs/15/release-15-5.html

  * The libs and mini package are now provided by postgresql16.

  * Overhaul postgresql-README.SUSE and move it from the binary package to the
    noarch wrapper package.

  * Change the unix domain socket location from /var/run to /run.

Changes in postgresql:

  * Interlock version and release of all noarch packages except for the
    postgresql-docs.
  * bsc#1122892: Add a sysconfig variable for initdb.
  * Overhaul postgresql-README.SUSE and move it from the binary package to the
    noarch wrapper package.
  * bsc#1179231: Add an explanation for the /tmp -> /run/postgresql move and
    permission change.
  * Add postgresql-README as a separate source file.
  * bsc#1209208: Drop hard dependency on systemd
  * bsc#1206796: Refine the distinction of where to use sysusers and use bcond
    to have the expression only in one place.

## 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:

  * openSUSE Leap 15.3  
    zypper in -t patch SUSE-2023-4495=1

  * openSUSE Leap 15.4  
    zypper in -t patch SUSE-2023-4495=1 openSUSE-SLE-15.4-2023-4495=1

  * openSUSE Leap 15.5  
    zypper in -t patch SUSE-2023-4495=1 openSUSE-SLE-15.5-2023-4495=1

  * Basesystem Module 15-SP4  
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP4-2023-4495=1

  * Basesystem Module 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP5-2023-4495=1

  * Legacy Module 15-SP4  
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP4-2023-4495=1

  * Legacy Module 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Legacy-15-SP5-2023-4495=1

  * SUSE Package Hub 15 15-SP4  
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP4-2023-4495=1

  * SUSE Package Hub 15 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP5-2023-4495=1

  * Server Applications Module 15-SP4  
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP4-2023-4495=1

  * Server Applications Module 15-SP5  
    zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP5-2023-4495=1

  * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP2-LTSS-2023-4495=1

  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-ESPOS-2023-4495=1

  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3  
    zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2023-4495=1

  * SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2  
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP2-LTSS-2023-4495=1

  * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3  
    zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2023-4495=1

  * SUSE Linux Enterprise Server for SAP Applications 15 SP2  
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP2-2023-4495=1

  * SUSE Linux Enterprise Server for SAP Applications 15 SP3  
    zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2023-4495=1

  * SUSE Enterprise Storage 7.1  
    zypper in -t patch SUSE-Storage-7.1-2023-4495=1

## Package List:

  * openSUSE Leap 15.3 (noarch)
    * postgresql-test-16-150300.10.18.3
    * postgresql-16-150300.10.18.3
    * postgresql-llvmjit-devel-16-150300.10.18.3
    * postgresql-plperl-16-150300.10.18.3
    * postgresql-contrib-16-150300.10.18.3
    * postgresql-server-16-150300.10.18.3
    * postgresql-server-devel-16-150300.10.18.3
    * postgresql-llvmjit-16-150300.10.18.3
    * postgresql-plpython-16-150300.10.18.3
    * postgresql-docs-16-150300.10.18.3
    * postgresql-pltcl-16-150300.10.18.3
    * postgresql-devel-16-150300.10.18.3
  * openSUSE Leap 15.4 (noarch)
    * postgresql-plperl-16-150400.4.9.2
    * postgresql-server-16-150400.4.9.2
    * postgresql-docs-16-150400.4.9.2
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql-llvmjit-16-150400.4.9.2
    * postgresql-llvmjit-devel-16-150300.10.18.3
    * postgresql-devel-16-150400.4.9.2
    * postgresql-llvmjit-devel-16-150400.4.9.2
    * postgresql-server-devel-16-150400.4.9.2
    * postgresql-contrib-16-150400.4.9.2
    * postgresql-pltcl-16-150400.4.9.2
    * postgresql-plpython-16-150400.4.9.2
    * postgresql-16-150400.4.9.2
    * postgresql-test-16-150400.4.9.2
    * postgresql16-docs-16.1-150200.5.7.1
  * openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql16-devel-debuginfo-16.1-150200.5.7.1
    * postgresql16-devel-16.1-150200.5.7.1
    * postgresql15-test-15.5-150200.5.19.1
    * postgresql16-pltcl-debuginfo-16.1-150200.5.7.1
    * postgresql16-test-16.1-150200.5.7.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql16-16.1-150200.5.7.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * postgresql16-devel-mini-debuginfo-16.1-150200.5.7.1
    * postgresql16-plperl-16.1-150200.5.7.1
    * postgresql16-server-debuginfo-16.1-150200.5.7.1
    * postgresql15-llvmjit-devel-15.5-150200.5.19.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql16-server-devel-16.1-150200.5.7.1
    * postgresql16-contrib-16.1-150200.5.7.1
    * postgresql16-pltcl-16.1-150200.5.7.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql15-llvmjit-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql16-plpython-debuginfo-16.1-150200.5.7.1
    * postgresql16-llvmjit-16.1-150200.5.7.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * libpq5-16.1-150200.5.7.1
    * postgresql16-server-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-llvmjit-debuginfo-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql16-llvmjit-debuginfo-16.1-150200.5.7.1
    * postgresql16-plperl-debuginfo-16.1-150200.5.7.1
    * postgresql16-contrib-debuginfo-16.1-150200.5.7.1
    * postgresql16-server-devel-debuginfo-16.1-150200.5.7.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql16-plpython-16.1-150200.5.7.1
    * postgresql16-mini-debugsource-16.1-150200.5.7.1
    * postgresql16-devel-mini-16.1-150200.5.7.1
    * postgresql16-llvmjit-devel-16.1-150200.5.7.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * openSUSE Leap 15.4 (x86_64)
    * libecpg6-32bit-debuginfo-16.1-150200.5.7.1
    * libpq5-32bit-16.1-150200.5.7.1
    * libecpg6-32bit-16.1-150200.5.7.1
    * libpq5-32bit-debuginfo-16.1-150200.5.7.1
  * openSUSE Leap 15.5 (noarch)
    * postgresql-server-devel-16-150500.10.3.2
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql-llvmjit-16-150500.10.3.2
    * postgresql-test-16-150500.10.3.2
    * postgresql16-docs-16.1-150200.5.7.1
    * postgresql-plperl-16-150500.10.3.2
    * postgresql-docs-16-150500.10.3.2
    * postgresql-server-16-150500.10.3.2
    * postgresql-plpython-16-150500.10.3.2
    * postgresql-pltcl-16-150500.10.3.2
    * postgresql-devel-16-150500.10.3.2
    * postgresql-llvmjit-devel-16-150500.10.3.2
    * postgresql-16-150500.10.3.2
    * postgresql-contrib-16-150500.10.3.2
  * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql16-devel-debuginfo-16.1-150200.5.7.1
    * postgresql16-devel-16.1-150200.5.7.1
    * postgresql15-test-15.5-150200.5.19.1
    * postgresql16-pltcl-debuginfo-16.1-150200.5.7.1
    * postgresql16-test-16.1-150200.5.7.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql16-16.1-150200.5.7.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * postgresql16-devel-mini-debuginfo-16.1-150200.5.7.1
    * postgresql16-plperl-16.1-150200.5.7.1
    * postgresql16-server-debuginfo-16.1-150200.5.7.1
    * postgresql15-llvmjit-devel-15.5-150200.5.19.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql16-server-devel-16.1-150200.5.7.1
    * postgresql16-contrib-16.1-150200.5.7.1
    * postgresql16-pltcl-16.1-150200.5.7.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql15-llvmjit-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql16-plpython-debuginfo-16.1-150200.5.7.1
    * postgresql16-llvmjit-16.1-150200.5.7.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * libpq5-16.1-150200.5.7.1
    * postgresql16-server-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-llvmjit-debuginfo-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql16-llvmjit-debuginfo-16.1-150200.5.7.1
    * postgresql16-plperl-debuginfo-16.1-150200.5.7.1
    * postgresql16-contrib-debuginfo-16.1-150200.5.7.1
    * postgresql16-server-devel-debuginfo-16.1-150200.5.7.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql16-plpython-16.1-150200.5.7.1
    * postgresql16-mini-debugsource-16.1-150200.5.7.1
    * postgresql16-devel-mini-16.1-150200.5.7.1
    * postgresql16-llvmjit-devel-16.1-150200.5.7.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * openSUSE Leap 15.5 (x86_64)
    * libecpg6-32bit-debuginfo-16.1-150200.5.7.1
    * libpq5-32bit-16.1-150200.5.7.1
    * libecpg6-32bit-16.1-150200.5.7.1
    * libpq5-32bit-debuginfo-16.1-150200.5.7.1
  * Basesystem Module 15-SP4 (aarch64 ppc64le s390x x86_64)
    * libpq5-16.1-150200.5.7.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql16-16.1-150200.5.7.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
  * Basesystem Module 15-SP4 (noarch)
    * postgresql-16-150400.4.9.2
  * Basesystem Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    * libpq5-16.1-150200.5.7.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql16-16.1-150200.5.7.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
  * Basesystem Module 15-SP5 (noarch)
    * postgresql-16-150500.10.3.2
  * Legacy Module 15-SP4 (noarch)
    * postgresql-llvmjit-devel-16-150400.4.9.2
    * postgresql-llvmjit-16-150400.4.9.2
  * Legacy Module 15-SP5 (noarch)
    * postgresql-llvmjit-16-150500.10.3.2
    * postgresql-llvmjit-devel-16-150500.10.3.2
  * SUSE Package Hub 15 15-SP4 (noarch)
    * postgresql-plperl-16-150400.4.9.2
    * postgresql-server-16-150400.4.9.2
    * postgresql-docs-16-150400.4.9.2
    * postgresql-llvmjit-16-150400.4.9.2
    * postgresql-devel-16-150400.4.9.2
    * postgresql-llvmjit-devel-16-150400.4.9.2
    * postgresql-server-devel-16-150400.4.9.2
    * postgresql-contrib-16-150400.4.9.2
    * postgresql-pltcl-16-150400.4.9.2
    * postgresql-plpython-16-150400.4.9.2
    * postgresql-16-150400.4.9.2
    * postgresql-test-16-150400.4.9.2
  * SUSE Package Hub 15 15-SP4 (aarch64 ppc64le s390x x86_64)
    * postgresql15-llvmjit-15.5-150200.5.19.1
    * postgresql15-llvmjit-devel-15.5-150200.5.19.1
    * postgresql15-test-15.5-150200.5.19.1
    * postgresql15-llvmjit-debuginfo-15.5-150200.5.19.1
    * postgresql16-llvmjit-debuginfo-16.1-150200.5.7.1
    * postgresql16-test-16.1-150200.5.7.1
    * postgresql16-llvmjit-16.1-150200.5.7.1
    * postgresql16-llvmjit-devel-16.1-150200.5.7.1
  * SUSE Package Hub 15 15-SP5 (noarch)
    * postgresql-server-devel-16-150500.10.3.2
    * postgresql-llvmjit-16-150500.10.3.2
    * postgresql-test-16-150500.10.3.2
    * postgresql-plperl-16-150500.10.3.2
    * postgresql-docs-16-150500.10.3.2
    * postgresql-server-16-150500.10.3.2
    * postgresql-plpython-16-150500.10.3.2
    * postgresql-pltcl-16-150500.10.3.2
    * postgresql-devel-16-150500.10.3.2
    * postgresql-llvmjit-devel-16-150500.10.3.2
    * postgresql-16-150500.10.3.2
    * postgresql-contrib-16-150500.10.3.2
  * SUSE Package Hub 15 15-SP5 (aarch64 ppc64le s390x x86_64)
    * postgresql16-test-16.1-150200.5.7.1
    * postgresql16-llvmjit-16.1-150200.5.7.1
    * postgresql16-llvmjit-devel-16.1-150200.5.7.1
    * postgresql16-llvmjit-debuginfo-16.1-150200.5.7.1
  * Server Applications Module 15-SP4 (aarch64 ppc64le s390x x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql16-devel-debuginfo-16.1-150200.5.7.1
    * postgresql16-devel-16.1-150200.5.7.1
    * postgresql16-pltcl-debuginfo-16.1-150200.5.7.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * postgresql16-plperl-16.1-150200.5.7.1
    * postgresql16-server-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql16-server-devel-16.1-150200.5.7.1
    * postgresql16-contrib-16.1-150200.5.7.1
    * postgresql16-pltcl-16.1-150200.5.7.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql16-plpython-debuginfo-16.1-150200.5.7.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * postgresql16-server-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql16-plperl-debuginfo-16.1-150200.5.7.1
    * postgresql16-server-devel-debuginfo-16.1-150200.5.7.1
    * postgresql16-contrib-debuginfo-16.1-150200.5.7.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql16-plpython-16.1-150200.5.7.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * Server Applications Module 15-SP4 (noarch)
    * postgresql-plperl-16-150400.4.9.2
    * postgresql-server-16-150400.4.9.2
    * postgresql-docs-16-150400.4.9.2
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql-devel-16-150400.4.9.2
    * postgresql-server-devel-16-150400.4.9.2
    * postgresql-contrib-16-150400.4.9.2
    * postgresql-plpython-16-150400.4.9.2
    * postgresql-pltcl-16-150400.4.9.2
    * postgresql16-docs-16.1-150200.5.7.1
  * Server Applications Module 15-SP4 (ppc64le)
    * postgresql15-15.5-150200.5.19.1
  * Server Applications Module 15-SP5 (aarch64 ppc64le s390x x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql16-devel-debuginfo-16.1-150200.5.7.1
    * postgresql16-devel-16.1-150200.5.7.1
    * postgresql16-pltcl-debuginfo-16.1-150200.5.7.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * postgresql16-plperl-16.1-150200.5.7.1
    * postgresql16-server-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql16-server-devel-16.1-150200.5.7.1
    * postgresql16-contrib-16.1-150200.5.7.1
    * postgresql16-pltcl-16.1-150200.5.7.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql16-plpython-debuginfo-16.1-150200.5.7.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * postgresql16-server-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql16-plperl-debuginfo-16.1-150200.5.7.1
    * postgresql16-server-devel-debuginfo-16.1-150200.5.7.1
    * postgresql16-contrib-debuginfo-16.1-150200.5.7.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql16-plpython-16.1-150200.5.7.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * Server Applications Module 15-SP5 (noarch)
    * postgresql-server-devel-16-150500.10.3.2
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql16-docs-16.1-150200.5.7.1
    * postgresql-docs-16-150500.10.3.2
    * postgresql-server-16-150500.10.3.2
    * postgresql-plpython-16-150500.10.3.2
    * postgresql-pltcl-16-150500.10.3.2
    * postgresql-devel-16-150500.10.3.2
    * postgresql-plperl-16-150500.10.3.2
    * postgresql-contrib-16-150500.10.3.2
  * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (aarch64
    x86_64)
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libpq5-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
  * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (noarch)
    * postgresql-server-devel-16-150200.4.24.1
    * postgresql-docs-16-150200.4.24.1
    * postgresql-pltcl-16-150200.4.24.1
    * postgresql-devel-16-150200.4.24.1
    * postgresql-plpython-16-150200.4.24.1
    * postgresql-contrib-16-150200.4.24.1
    * postgresql-plperl-16-150200.4.24.1
    * postgresql-server-16-150200.4.24.1
    * postgresql-16-150200.4.24.1
  * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (x86_64)
    * libpq5-32bit-16.1-150200.5.7.1
    * libpq5-32bit-debuginfo-16.1-150200.5.7.1
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (aarch64
    x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * libpq5-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (noarch)
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql-16-150300.10.18.3
    * postgresql-plperl-16-150300.10.18.3
    * postgresql-contrib-16-150300.10.18.3
    * postgresql-server-16-150300.10.18.3
    * postgresql-server-devel-16-150300.10.18.3
    * postgresql-plpython-16-150300.10.18.3
    * postgresql-docs-16-150300.10.18.3
    * postgresql-pltcl-16-150300.10.18.3
    * postgresql-devel-16-150300.10.18.3
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64
    x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * libpq5-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (noarch)
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql-16-150300.10.18.3
    * postgresql-plperl-16-150300.10.18.3
    * postgresql-contrib-16-150300.10.18.3
    * postgresql-server-16-150300.10.18.3
    * postgresql-server-devel-16-150300.10.18.3
    * postgresql-plpython-16-150300.10.18.3
    * postgresql-docs-16-150300.10.18.3
    * postgresql-pltcl-16-150300.10.18.3
    * postgresql-devel-16-150300.10.18.3
  * SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (aarch64 ppc64le s390x
    x86_64)
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libpq5-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
  * SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (noarch)
    * postgresql-server-devel-16-150200.4.24.1
    * postgresql-docs-16-150200.4.24.1
    * postgresql-pltcl-16-150200.4.24.1
    * postgresql-devel-16-150200.4.24.1
    * postgresql-plpython-16-150200.4.24.1
    * postgresql-contrib-16-150200.4.24.1
    * postgresql-plperl-16-150200.4.24.1
    * postgresql-server-16-150200.4.24.1
    * postgresql-16-150200.4.24.1
  * SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (x86_64)
    * libpq5-32bit-16.1-150200.5.7.1
    * libpq5-32bit-debuginfo-16.1-150200.5.7.1
  * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (aarch64 ppc64le s390x
    x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * libpq5-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (noarch)
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql-16-150300.10.18.3
    * postgresql-plperl-16-150300.10.18.3
    * postgresql-contrib-16-150300.10.18.3
    * postgresql-server-16-150300.10.18.3
    * postgresql-server-devel-16-150300.10.18.3
    * postgresql-plpython-16-150300.10.18.3
    * postgresql-docs-16-150300.10.18.3
    * postgresql-pltcl-16-150300.10.18.3
    * postgresql-devel-16-150300.10.18.3
  * SUSE Linux Enterprise Server for SAP Applications 15 SP2 (ppc64le x86_64)
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libpq5-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP2 (noarch)
    * postgresql-server-devel-16-150200.4.24.1
    * postgresql-docs-16-150200.4.24.1
    * postgresql-pltcl-16-150200.4.24.1
    * postgresql-devel-16-150200.4.24.1
    * postgresql-plpython-16-150200.4.24.1
    * postgresql-contrib-16-150200.4.24.1
    * postgresql-plperl-16-150200.4.24.1
    * postgresql-server-16-150200.4.24.1
    * postgresql-16-150200.4.24.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP2 (x86_64)
    * libpq5-32bit-16.1-150200.5.7.1
    * libpq5-32bit-debuginfo-16.1-150200.5.7.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * libpq5-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (noarch)
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql-16-150300.10.18.3
    * postgresql-plperl-16-150300.10.18.3
    * postgresql-contrib-16-150300.10.18.3
    * postgresql-server-16-150300.10.18.3
    * postgresql-server-devel-16-150300.10.18.3
    * postgresql-plpython-16-150300.10.18.3
    * postgresql-docs-16-150300.10.18.3
    * postgresql-pltcl-16-150300.10.18.3
    * postgresql-devel-16-150300.10.18.3
  * SUSE Enterprise Storage 7.1 (aarch64 x86_64)
    * postgresql16-debuginfo-16.1-150200.5.7.1
    * postgresql15-debugsource-15.5-150200.5.19.1
    * postgresql15-15.5-150200.5.19.1
    * postgresql15-contrib-debuginfo-15.5-150200.5.19.1
    * libpq5-debuginfo-16.1-150200.5.7.1
    * libecpg6-16.1-150200.5.7.1
    * postgresql15-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-debuginfo-15.5-150200.5.19.1
    * postgresql15-pltcl-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-devel-debuginfo-15.5-150200.5.19.1
    * postgresql15-server-debuginfo-15.5-150200.5.19.1
    * postgresql15-contrib-15.5-150200.5.19.1
    * postgresql15-server-15.5-150200.5.19.1
    * postgresql16-debugsource-16.1-150200.5.7.1
    * libecpg6-debuginfo-16.1-150200.5.7.1
    * postgresql15-plpython-15.5-150200.5.19.1
    * postgresql15-debuginfo-15.5-150200.5.19.1
    * libpq5-16.1-150200.5.7.1
    * postgresql15-server-devel-15.5-150200.5.19.1
    * postgresql15-devel-15.5-150200.5.19.1
    * postgresql15-plpython-debuginfo-15.5-150200.5.19.1
    * postgresql15-plperl-15.5-150200.5.19.1
    * postgresql15-pltcl-15.5-150200.5.19.1
  * SUSE Enterprise Storage 7.1 (noarch)
    * postgresql15-docs-15.5-150200.5.19.1
    * postgresql-16-150300.10.18.3
    * postgresql-plperl-16-150300.10.18.3
    * postgresql-contrib-16-150300.10.18.3
    * postgresql-server-16-150300.10.18.3
    * postgresql-server-devel-16-150300.10.18.3
    * postgresql-plpython-16-150300.10.18.3
    * postgresql-docs-16-150300.10.18.3
    * postgresql-pltcl-16-150300.10.18.3
    * postgresql-devel-16-150300.10.18.3

## References:

  * https://www.suse.com/security/cve/CVE-2023-5868.html
  * https://www.suse.com/security/cve/CVE-2023-5869.html
  * https://www.suse.com/security/cve/CVE-2023-5870.html
  * https://bugzilla.suse.com/show_bug.cgi?id=1122892
  * https://bugzilla.suse.com/show_bug.cgi?id=1179231
  * https://bugzilla.suse.com/show_bug.cgi?id=1206796
  * https://bugzilla.suse.com/show_bug.cgi?id=1209208
  * https://bugzilla.suse.com/show_bug.cgi?id=1216022
  * https://bugzilla.suse.com/show_bug.cgi?id=1216734
  * https://bugzilla.suse.com/show_bug.cgi?id=1216960
  * https://bugzilla.suse.com/show_bug.cgi?id=1216961
  * https://bugzilla.suse.com/show_bug.cgi?id=1216962
  * https://jira.suse.com/browse/PED-5586

SUSE-SU-2023:4495-1: important: Security update for postgresql, postgresql15, postgresql16

security＠lists.opensuse.org