<div class="container">
<h1>Security update for postgresql15</h1>
<table class="table table-striped table-bordered">
<tbody>
<tr>
<th>Announcement ID:</th>
<td>SUSE-SU-2023:3347-1</td>
</tr>
<tr>
<th>Rating:</th>
<td>moderate</td>
</tr>
<tr>
<th>References:</th>
<td>
<ul>
<li style="display: inline;">
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1214059">#1214059</a>
</li>
<li style="display: inline;">
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1214061">#1214061</a>
</li>
</ul>
</td>
</tr>
<tr>
<th>
Cross-References:
</th>
<td>
<ul>
<li style="display: inline;">
<a href="https://www.suse.com/security/cve/CVE-2023-39417.html">CVE-2023-39417</a>
</li>
<li style="display: inline;">
<a href="https://www.suse.com/security/cve/CVE-2023-39418.html">CVE-2023-39418</a>
</li>
</ul>
</td>
</tr>
<tr>
<th>CVSS scores:</th>
<td>
<ul class="list-group">
<li class="list-group-item">
<span class="cvss-reference">CVE-2023-39417</span>
<span class="cvss-source">
(
SUSE
):
</span>
<span class="cvss-score">6.3</span>
<span class="cvss-vector">CVSS:3.1/AV:L/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:N</span>
</li>
<li class="list-group-item">
<span class="cvss-reference">CVE-2023-39417</span>
<span class="cvss-source">
(
NVD
):
</span>
<span class="cvss-score">7.5</span>
<span class="cvss-vector">CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H</span>
</li>
<li class="list-group-item">
<span class="cvss-reference">CVE-2023-39418</span>
<span class="cvss-source">
(
SUSE
):
</span>
<span class="cvss-score">4.7</span>
<span class="cvss-vector">CVSS:3.1/AV:L/AC:H/PR:L/UI:N/S:U/C:N/I:H/A:N</span>
</li>
<li class="list-group-item">
<span class="cvss-reference">CVE-2023-39418</span>
<span class="cvss-source">
(
NVD
):
</span>
<span class="cvss-score">3.1</span>
<span class="cvss-vector">CVSS:3.1/AV:N/AC:H/PR:L/UI:N/S:U/C:N/I:L/A:N</span>
</li>
</ul>
</td>
</tr>
<tr>
<th>Affected Products:</th>
<td>
<ul class="list-group">
<li class="list-group-item">Basesystem Module 15-SP4</li>
<li class="list-group-item">Basesystem Module 15-SP5</li>
<li class="list-group-item">openSUSE Leap 15.4</li>
<li class="list-group-item">openSUSE Leap 15.5</li>
<li class="list-group-item">Server Applications Module 15-SP4</li>
<li class="list-group-item">Server Applications Module 15-SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Desktop 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Desktop 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise High Performance Computing 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Micro 5.3</li>
<li class="list-group-item">SUSE Linux Enterprise Micro 5.4</li>
<li class="list-group-item">SUSE Linux Enterprise Real Time 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Real Time 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Server 15 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP4</li>
<li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 15 SP5</li>
<li class="list-group-item">SUSE Manager Proxy 4.2</li>
<li class="list-group-item">SUSE Manager Proxy 4.3</li>
<li class="list-group-item">SUSE Manager Retail Branch Server 4.2</li>
<li class="list-group-item">SUSE Manager Retail Branch Server 4.3</li>
<li class="list-group-item">SUSE Manager Server 4.2</li>
<li class="list-group-item">SUSE Manager Server 4.3</li>
<li class="list-group-item">SUSE Package Hub 15 15-SP4</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>An update that solves two vulnerabilities can now be installed.</p>
<h2>Description:</h2>
<p>This update for postgresql15 fixes the following issues:</p>
<ul>
<li>Update to 15.4</li>
<li>CVE-2023-39417: Fixed potential SQL injection for trusted extensions. (bsc#1214059)</li>
<li>CVE-2023-39418: Fix MERGE to enforce row security. (bsc#1214061)</li>
</ul>
<h2>Patch Instructions:</h2>
<p>
To install this SUSE Moderate update use the SUSE recommended
installation methods like YaST online_update or "zypper patch".<br/>
Alternatively you can run the command listed for your product:
</p>
<ul class="list-group">
<li class="list-group-item">
openSUSE Leap 15.4
<br/>
<code>zypper in -t patch openSUSE-SLE-15.4-2023-3347=1</code>
</li>
<li class="list-group-item">
openSUSE Leap 15.5
<br/>
<code>zypper in -t patch openSUSE-SLE-15.5-2023-3347=1</code>
</li>
<li class="list-group-item">
Basesystem Module 15-SP4
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP4-2023-3347=1</code>
</li>
<li class="list-group-item">
Basesystem Module 15-SP5
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Basesystem-15-SP5-2023-3347=1</code>
</li>
<li class="list-group-item">
SUSE Package Hub 15 15-SP4
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP4-2023-3347=1</code>
</li>
<li class="list-group-item">
Server Applications Module 15-SP4
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP4-2023-3347=1</code>
</li>
<li class="list-group-item">
Server Applications Module 15-SP5
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Server-Applications-15-SP5-2023-3347=1</code>
</li>
<li class="list-group-item">
SUSE Manager Proxy 4.2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Proxy-4.2-2023-3347=1</code>
</li>
<li class="list-group-item">
SUSE Manager Retail Branch Server 4.2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Retail-Branch-Server-4.2-2023-3347=1</code>
</li>
<li class="list-group-item">
SUSE Manager Server 4.2
<br/>
<code>zypper in -t patch SUSE-SLE-Product-SUSE-Manager-Server-4.2-2023-3347=1</code>
</li>
</ul>
<h2>Package List:</h2>
<ul>
<li>
openSUSE Leap 15.4 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql15-plpython-15.4-150200.5.12.1</li>
<li>libecpg6-15.4-150200.5.12.1</li>
<li>postgresql15-devel-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-15.4-150200.5.12.1</li>
<li>postgresql15-devel-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-15.4-150200.5.12.1</li>
<li>postgresql15-llvmjit-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-15.4-150200.5.12.1</li>
<li>postgresql15-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-15.4-150200.5.12.1</li>
<li>postgresql15-llvmjit-devel-15.4-150200.5.12.1</li>
<li>postgresql15-server-15.4-150200.5.12.1</li>
<li>postgresql15-plpython-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
<li>postgresql15-test-15.4-150200.5.12.1</li>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-debuginfo-15.4-150200.5.12.1</li>
<li>libecpg6-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-server-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-debuginfo-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
openSUSE Leap 15.4 (x86_64)
<ul>
<li>libecpg6-32bit-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-32bit-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-32bit-15.4-150200.5.12.1</li>
<li>libecpg6-32bit-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
openSUSE Leap 15.4 (noarch)
<ul>
<li>postgresql15-docs-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql15-plpython-15.4-150200.5.12.1</li>
<li>libecpg6-15.4-150200.5.12.1</li>
<li>postgresql15-devel-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-15.4-150200.5.12.1</li>
<li>postgresql15-devel-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-15.4-150200.5.12.1</li>
<li>postgresql15-llvmjit-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-15.4-150200.5.12.1</li>
<li>postgresql15-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-15.4-150200.5.12.1</li>
<li>postgresql15-llvmjit-devel-15.4-150200.5.12.1</li>
<li>postgresql15-server-15.4-150200.5.12.1</li>
<li>postgresql15-plpython-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
<li>postgresql15-test-15.4-150200.5.12.1</li>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-debuginfo-15.4-150200.5.12.1</li>
<li>libecpg6-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-server-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-debuginfo-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
openSUSE Leap 15.5 (x86_64)
<ul>
<li>libecpg6-32bit-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-32bit-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-32bit-15.4-150200.5.12.1</li>
<li>libecpg6-32bit-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
openSUSE Leap 15.5 (noarch)
<ul>
<li>postgresql15-docs-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
Basesystem Module 15-SP4 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-15.4-150200.5.12.1</li>
<li>libpq5-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
Basesystem Module 15-SP5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-15.4-150200.5.12.1</li>
<li>libpq5-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
SUSE Package Hub 15 15-SP4 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql15-llvmjit-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-test-15.4-150200.5.12.1</li>
<li>postgresql15-llvmjit-15.4-150200.5.12.1</li>
<li>postgresql15-llvmjit-devel-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
Server Applications Module 15-SP4 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql15-plpython-15.4-150200.5.12.1</li>
<li>postgresql15-server-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>libecpg6-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-server-15.4-150200.5.12.1</li>
<li>libecpg6-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plpython-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-devel-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-debuginfo-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
Server Applications Module 15-SP4 (noarch)
<ul>
<li>postgresql15-docs-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
Server Applications Module 15-SP4 (ppc64le)
<ul>
<li>postgresql15-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
Server Applications Module 15-SP5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql15-plpython-15.4-150200.5.12.1</li>
<li>postgresql15-server-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>libecpg6-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-server-15.4-150200.5.12.1</li>
<li>libecpg6-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plpython-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-devel-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-debuginfo-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
Server Applications Module 15-SP5 (noarch)
<ul>
<li>postgresql15-docs-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
SUSE Manager Proxy 4.2 (x86_64)
<ul>
<li>postgresql15-plpython-15.4-150200.5.12.1</li>
<li>libecpg6-15.4-150200.5.12.1</li>
<li>postgresql15-devel-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-15.4-150200.5.12.1</li>
<li>postgresql15-devel-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-15.4-150200.5.12.1</li>
<li>postgresql15-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-15.4-150200.5.12.1</li>
<li>postgresql15-server-15.4-150200.5.12.1</li>
<li>postgresql15-plpython-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-debuginfo-15.4-150200.5.12.1</li>
<li>libecpg6-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-server-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-debuginfo-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
SUSE Manager Proxy 4.2 (noarch)
<ul>
<li>postgresql15-docs-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
SUSE Manager Retail Branch Server 4.2 (x86_64)
<ul>
<li>postgresql15-plpython-15.4-150200.5.12.1</li>
<li>libecpg6-15.4-150200.5.12.1</li>
<li>postgresql15-devel-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-15.4-150200.5.12.1</li>
<li>postgresql15-devel-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-15.4-150200.5.12.1</li>
<li>postgresql15-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-15.4-150200.5.12.1</li>
<li>postgresql15-server-15.4-150200.5.12.1</li>
<li>postgresql15-plpython-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-debuginfo-15.4-150200.5.12.1</li>
<li>libecpg6-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-server-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-debuginfo-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
SUSE Manager Retail Branch Server 4.2 (noarch)
<ul>
<li>postgresql15-docs-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
SUSE Manager Server 4.2 (ppc64le s390x x86_64)
<ul>
<li>postgresql15-plpython-15.4-150200.5.12.1</li>
<li>libecpg6-15.4-150200.5.12.1</li>
<li>postgresql15-devel-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-15.4-150200.5.12.1</li>
<li>postgresql15-devel-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-15.4-150200.5.12.1</li>
<li>postgresql15-15.4-150200.5.12.1</li>
<li>postgresql15-server-devel-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-15.4-150200.5.12.1</li>
<li>postgresql15-server-15.4-150200.5.12.1</li>
<li>postgresql15-plpython-debuginfo-15.4-150200.5.12.1</li>
<li>libpq5-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-debugsource-15.4-150200.5.12.1</li>
<li>postgresql15-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-pltcl-debuginfo-15.4-150200.5.12.1</li>
<li>libecpg6-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-15.4-150200.5.12.1</li>
<li>postgresql15-plperl-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-server-debuginfo-15.4-150200.5.12.1</li>
<li>postgresql15-contrib-debuginfo-15.4-150200.5.12.1</li>
</ul>
</li>
<li>
SUSE Manager Server 4.2 (noarch)
<ul>
<li>postgresql15-docs-15.4-150200.5.12.1</li>
</ul>
</li>
</ul>
<h2>References:</h2>
<ul>
<li>
<a href="https://www.suse.com/security/cve/CVE-2023-39417.html">https://www.suse.com/security/cve/CVE-2023-39417.html</a>
</li>
<li>
<a href="https://www.suse.com/security/cve/CVE-2023-39418.html">https://www.suse.com/security/cve/CVE-2023-39418.html</a>
</li>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1214059">https://bugzilla.suse.com/show_bug.cgi?id=1214059</a>
</li>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1214061">https://bugzilla.suse.com/show_bug.cgi?id=1214061</a>
</li>
</ul>
</div>