openSUSE: 2023:3347-1: moderate: postgresql15 Security Advisory Update
Description
This update for postgresql15 fixes the following issues: * Update to 15.4 * CVE-2023-39417: Fixed potential SQL injection for trusted extensions. (bsc#1214059) * CVE-2023-39418: Fix MERGE to enforce row security. (bsc#1214061)
Patch
## Patch Instructions: To install this SUSE Moderate 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-3347=1 * openSUSE Leap 15.5 zypper in -t patch openSUSE-SLE-15.5-2023-3347=1 * Basesystem Module 15-SP4 zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP4-2023-3347=1 * Basesystem Module 15-SP5 zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP5-2023-3347=1 * SUSE Package Hub 15 15-SP4 zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP4-2023-3347=1 * Server Applications Module 15-SP4 zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP4-2023-3347=1 * Server Applications Module 15-SP5 zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP5-2023-3347=1 * SUSE Manager Proxy 4.2 zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Proxy-4.2-2023-3347=1 * SUSE Manager Retail Branch Server 4.2 zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Retail-Branch- Server-4.2-2023-3347=1 * SUSE Manager Server 4.2 zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Server-4.2-2023-3347=1
Package List
* openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64) * postgresql15-plpython-15.4-150200.5.12.1 * libecpg6-15.4-150200.5.12.1 * postgresql15-devel-debuginfo-15.4-150200.5.12.1 * libpq5-15.4-150200.5.12.1 * postgresql15-devel-15.4-150200.5.12.1 * postgresql15-server-devel-15.4-150200.5.12.1 * postgresql15-llvmjit-15.4-150200.5.12.1 * postgresql15-contrib-15.4-150200.5.12.1 * postgresql15-15.4-150200.5.12.1 * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-15.4-150200.5.12.1 * postgresql15-llvmjit-devel-15.4-150200.5.12.1 * postgresql15-server-15.4-150200.5.12.1 * postgresql15-plpython-debuginfo-15.4-150200.5.12.1 * libpq5-debuginfo-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * postgresql15-test-15.4-150200.5.12.1 * postgresql15-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1 * libecpg6-debuginfo-15.4-150200.5.12.1 * postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1 * postgresql15-plperl-15.4-150200.5.12.1 * postgresql15-plperl-debuginfo-15.4-150200.5.12.1 * postgresql15-server-debuginfo-15.4-150200.5.12.1 * postgresql15-contrib-debuginfo-15.4-150200.5.12.1 * openSUSE Leap 15.4 (x86_64) * libecpg6-32bit-debuginfo-15.4-150200.5.12.1 * libpq5-32bit-debuginfo-15.4-150200.5.12.1 * libpq5-32bit-15.4-150200.5.12.1 * libecpg6-32bit-15.4-150200.5.12.1 * openSUSE Leap 15.4 (noarch) * postgresql15-docs-15.4-150200.5.12.1 * openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64) * postgresql15-plpython-15.4-150200.5.12.1 * libecpg6-15.4-150200.5.12.1 * postgresql15-devel-debuginfo-15.4-150200.5.12.1 * libpq5-15.4-150200.5.12.1 * postgresql15-devel-15.4-150200.5.12.1 * postgresql15-server-devel-15.4-150200.5.12.1 * postgresql15-llvmjit-15.4-150200.5.12.1 * postgresql15-contrib-15.4-150200.5.12.1 * postgresql15-15.4-150200.5.12.1 * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-15.4-150200.5.12.1 * postgresql15-llvmjit-devel-15.4-150200.5.12.1 * postgresql15-server-15.4-150200.5.12.1 * postgresql15-plpython-debuginfo-15.4-150200.5.12.1 * libpq5-debuginfo-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * postgresql15-test-15.4-150200.5.12.1 * postgresql15-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1 * libecpg6-debuginfo-15.4-150200.5.12.1 * postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1 * postgresql15-plperl-15.4-150200.5.12.1 * postgresql15-plperl-debuginfo-15.4-150200.5.12.1 * postgresql15-server-debuginfo-15.4-150200.5.12.1 * postgresql15-contrib-debuginfo-15.4-150200.5.12.1 * openSUSE Leap 15.5 (x86_64) * libecpg6-32bit-debuginfo-15.4-150200.5.12.1 * libpq5-32bit-debuginfo-15.4-150200.5.12.1 * libpq5-32bit-15.4-150200.5.12.1 * libecpg6-32bit-15.4-150200.5.12.1 * openSUSE Leap 15.5 (noarch) * postgresql15-docs-15.4-150200.5.12.1 * Basesystem Module 15-SP4 (aarch64 ppc64le s390x x86_64) * postgresql15-debuginfo-15.4-150200.5.12.1 * libpq5-15.4-150200.5.12.1 * libpq5-debuginfo-15.4-150200.5.12.1 * postgresql15-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * Basesystem Module 15-SP5 (aarch64 ppc64le s390x x86_64) * postgresql15-debuginfo-15.4-150200.5.12.1 * libpq5-15.4-150200.5.12.1 * libpq5-debuginfo-15.4-150200.5.12.1 * postgresql15-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * SUSE Package Hub 15 15-SP4 (aarch64 ppc64le s390x x86_64) * postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1 * postgresql15-test-15.4-150200.5.12.1 * postgresql15-llvmjit-15.4-150200.5.12.1 * postgresql15-llvmjit-devel-15.4-150200.5.12.1 * Server Applications Module 15-SP4 (aarch64 ppc64le s390x x86_64) * postgresql15-plpython-15.4-150200.5.12.1 * postgresql15-server-debuginfo-15.4-150200.5.12.1 * postgresql15-debuginfo-15.4-150200.5.12.1 * libecpg6-15.4-150200.5.12.1 * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1 * postgresql15-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-server-15.4-150200.5.12.1 * libecpg6-debuginfo-15.4-150200.5.12.1 * postgresql15-plpython-debuginfo-15.4-150200.5.12.1 * postgresql15-devel-15.4-150200.5.12.1 * postgresql15-plperl-15.4-150200.5.12.1 * postgresql15-server-devel-15.4-150200.5.12.1 * postgresql15-contrib-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-plperl-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-15.4-150200.5.12.1 * postgresql15-contrib-debuginfo-15.4-150200.5.12.1 * Server Applications Module 15-SP4 (noarch) * postgresql15-docs-15.4-150200.5.12.1 * Server Applications Module 15-SP4 (ppc64le) * postgresql15-15.4-150200.5.12.1 * Server Applications Module 15-SP5 (aarch64 ppc64le s390x x86_64) * postgresql15-plpython-15.4-150200.5.12.1 * postgresql15-server-debuginfo-15.4-150200.5.12.1 * postgresql15-debuginfo-15.4-150200.5.12.1 * libecpg6-15.4-150200.5.12.1 * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1 * postgresql15-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-server-15.4-150200.5.12.1 * libecpg6-debuginfo-15.4-150200.5.12.1 * postgresql15-plpython-debuginfo-15.4-150200.5.12.1 * postgresql15-devel-15.4-150200.5.12.1 * postgresql15-plperl-15.4-150200.5.12.1 * postgresql15-server-devel-15.4-150200.5.12.1 * postgresql15-contrib-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-plperl-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-15.4-150200.5.12.1 * postgresql15-contrib-debuginfo-15.4-150200.5.12.1 * Server Applications Module 15-SP5 (noarch) * postgresql15-docs-15.4-150200.5.12.1 * SUSE Manager Proxy 4.2 (x86_64) * postgresql15-plpython-15.4-150200.5.12.1 * libecpg6-15.4-150200.5.12.1 * postgresql15-devel-debuginfo-15.4-150200.5.12.1 * libpq5-15.4-150200.5.12.1 * postgresql15-devel-15.4-150200.5.12.1 * postgresql15-server-devel-15.4-150200.5.12.1 * postgresql15-contrib-15.4-150200.5.12.1 * postgresql15-15.4-150200.5.12.1 * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-15.4-150200.5.12.1 * postgresql15-server-15.4-150200.5.12.1 * postgresql15-plpython-debuginfo-15.4-150200.5.12.1 * libpq5-debuginfo-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * postgresql15-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1 * libecpg6-debuginfo-15.4-150200.5.12.1 * postgresql15-plperl-15.4-150200.5.12.1 * postgresql15-plperl-debuginfo-15.4-150200.5.12.1 * postgresql15-server-debuginfo-15.4-150200.5.12.1 * postgresql15-contrib-debuginfo-15.4-150200.5.12.1 * SUSE Manager Proxy 4.2 (noarch) * postgresql15-docs-15.4-150200.5.12.1 * SUSE Manager Retail Branch Server 4.2 (x86_64) * postgresql15-plpython-15.4-150200.5.12.1 * libecpg6-15.4-150200.5.12.1 * postgresql15-devel-debuginfo-15.4-150200.5.12.1 * libpq5-15.4-150200.5.12.1 * postgresql15-devel-15.4-150200.5.12.1 * postgresql15-server-devel-15.4-150200.5.12.1 * postgresql15-contrib-15.4-150200.5.12.1 * postgresql15-15.4-150200.5.12.1 * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-15.4-150200.5.12.1 * postgresql15-server-15.4-150200.5.12.1 * postgresql15-plpython-debuginfo-15.4-150200.5.12.1 * libpq5-debuginfo-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * postgresql15-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1 * libecpg6-debuginfo-15.4-150200.5.12.1 * postgresql15-plperl-15.4-150200.5.12.1 * postgresql15-plperl-debuginfo-15.4-150200.5.12.1 * postgresql15-server-debuginfo-15.4-150200.5.12.1 * postgresql15-contrib-debuginfo-15.4-150200.5.12.1 * SUSE Manager Retail Branch Server 4.2 (noarch) * postgresql15-docs-15.4-150200.5.12.1 * SUSE Manager Server 4.2 (ppc64le s390x x86_64) * postgresql15-plpython-15.4-150200.5.12.1 * libecpg6-15.4-150200.5.12.1 * postgresql15-devel-debuginfo-15.4-150200.5.12.1 * libpq5-15.4-150200.5.12.1 * postgresql15-devel-15.4-150200.5.12.1 * postgresql15-server-devel-15.4-150200.5.12.1 * postgresql15-contrib-15.4-150200.5.12.1 * postgresql15-15.4-150200.5.12.1 * postgresql15-server-devel-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-15.4-150200.5.12.1 * postgresql15-server-15.4-150200.5.12.1 * postgresql15-plpython-debuginfo-15.4-150200.5.12.1 * libpq5-debuginfo-15.4-150200.5.12.1 * postgresql15-debugsource-15.4-150200.5.12.1 * postgresql15-debuginfo-15.4-150200.5.12.1 * postgresql15-pltcl-debuginfo-15.4-150200.5.12.1 * libecpg6-debuginfo-15.4-150200.5.12.1 * postgresql15-plperl-15.4-150200.5.12.1 * postgresql15-plperl-debuginfo-15.4-150200.5.12.1 * postgresql15-server-debuginfo-15.4-150200.5.12.1 * postgresql15-contrib-debuginfo-15.4-150200.5.12.1 * SUSE Manager Server 4.2 (noarch) * postgresql15-docs-15.4-150200.5.12.1
References
* #1214059 * #1214061 ## References: * https://www.suse.com/security/cve/CVE-2023-39417.html * https://www.suse.com/security/cve/CVE-2023-39418.html * https://bugzilla.suse.com/show_bug.cgi?id=1214059 * https://bugzilla.suse.com/show_bug.cgi?id=1214061