openSUSE: 2023:4454-1: important: postgresql12 Security Advisory Update
Description
This update for postgresql12 fixes the following issues: 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 superu...
Read the Full Advisory
Patch
## 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.4 zypper in -t patch openSUSE-SLE-15.4-2023-4454=1 * openSUSE Leap 15.5 zypper in -t patch openSUSE-SLE-15.5-2023-4454=1 * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 zypper in -t patch SUSE-SLE-Product-HPC-15-SP2-LTSS-2023-4454=1 * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-ESPOS-2023-4454=1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 zypper in -t patch SUSE-SLE-Product-HPC-15-SP3-LTSS-2023-4454=1 * SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 zypper in -t patch SUSE-SLE-Product-SLES-15-SP2-LTSS-2023-4454=1 * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 zypper in -t patch SUSE-SLE-Product-SLES-15-SP3-LTSS-2023-4454=1 * SUSE Linux Enterprise Server for SAP Applications 15 SP2 zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP2-2023-4454=1 * SUSE Linux Enterprise Server for SAP Applications 15 SP3 zypper in -t patch SUSE-SLE-Product-SLES_SAP-15-SP3-2023-4454=1 * SUSE Enterprise Storage 7.1 zypper in -t patch SUSE-Storage-7.1-2023-4454=1
Package List
* openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-llvmjit-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-llvmjit-devel-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-llvmjit-debuginfo-12.17-150200.8.54.1 * postgresql12-test-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * openSUSE Leap 15.4 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-llvmjit-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-llvmjit-devel-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-llvmjit-debuginfo-12.17-150200.8.54.1 * postgresql12-test-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * openSUSE Leap 15.5 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (aarch64 x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * SUSE Linux Enterprise High Performance Computing 15 SP2 LTSS 15-SP2 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (aarch64 x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * SUSE Linux Enterprise High Performance Computing ESPOS 15 SP3 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (aarch64 x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * SUSE Linux Enterprise High Performance Computing LTSS 15 SP3 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (aarch64 ppc64le s390x x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * SUSE Linux Enterprise Server 15 SP2 LTSS 15-SP2 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (aarch64 ppc64le s390x x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * SUSE Linux Enterprise Server 15 SP3 LTSS 15-SP3 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * SUSE Linux Enterprise Server for SAP Applications 15 SP2 (ppc64le x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * SUSE Linux Enterprise Server for SAP Applications 15 SP2 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (ppc64le x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * SUSE Linux Enterprise Server for SAP Applications 15 SP3 (noarch) * postgresql12-docs-12.17-150200.8.54.1 * SUSE Enterprise Storage 7.1 (aarch64 x86_64) * postgresql12-debuginfo-12.17-150200.8.54.1 * postgresql12-server-debuginfo-12.17-150200.8.54.1 * postgresql12-contrib-12.17-150200.8.54.1 * postgresql12-12.17-150200.8.54.1 * postgresql12-plperl-12.17-150200.8.54.1 * postgresql12-pltcl-12.17-150200.8.54.1 * postgresql12-contrib-debuginfo-12.17-150200.8.54.1 * postgresql12-pltcl-debuginfo-12.17-150200.8.54.1 * postgresql12-server-12.17-150200.8.54.1 * postgresql12-debugsource-12.17-150200.8.54.1 * postgresql12-server-devel-12.17-150200.8.54.1 * postgresql12-server-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-debuginfo-12.17-150200.8.54.1 * postgresql12-plperl-debuginfo-12.17-150200.8.54.1 * postgresql12-devel-12.17-150200.8.54.1 * postgresql12-plpython-12.17-150200.8.54.1 * postgresql12-plpython-debuginfo-12.17-150200.8.54.1 * SUSE Enterprise Storage 7.1 (noarch) * postgresql12-docs-12.17-150200.8.54.1
References
* bsc#1216022 * bsc#1216734 * bsc#1216960 * bsc#1216961 * bsc#1216962 ## 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=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