<div class="container">
<h1>Security update for postgresql14</h1>
<table class="table table-striped table-bordered">
<tbody>
<tr>
<th>Announcement ID:</th>
<td>SUSE-SU-2024:1768-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=1224038">bsc#1224038</a>
</li>
<li style="display: inline;">
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1224051">bsc#1224051</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-2024-4317.html">CVE-2024-4317</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-2024-4317</span>
<span class="cvss-source">
(
SUSE
):
</span>
<span class="cvss-score">6.2</span>
<span class="cvss-vector">CVSS:3.1/AV:L/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N</span>
</li>
</ul>
</td>
</tr>
<tr>
<th>Affected Products:</th>
<td>
<ul class="list-group">
<li class="list-group-item">Legacy Module 15-SP5</li>
<li class="list-group-item">openSUSE Leap 15.5</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 SP5</li>
<li class="list-group-item">SUSE Linux Enterprise Micro 5.5</li>
<li class="list-group-item">SUSE Linux Enterprise Real Time 15 SP5</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 SP5</li>
<li class="list-group-item">SUSE Package Hub 15 15-SP5</li>
</ul>
</td>
</tr>
</tbody>
</table>
<p>An update that solves one vulnerability and has one security fix can now be installed.</p>
<h2>Description:</h2>
<p>This update for postgresql14 fixes the following issues:</p>
<p>PostgreSQL upgrade to version 14.12 (bsc#1224051):</p>
<ul>
<li>CVE-2024-4317: Fixed visibility restriction of pg_stats_ext and pg_stats_ext_exprs entries to the table owner (bsc#1224038).</li>
</ul>
<p>Bug fixes:</p>
<ul>
<li>Fix incompatibility with LLVM 18.</li>
<li>Prepare for PostgreSQL 17.</li>
<li>Make sure all compilation and doc generation happens in %build.</li>
<li>Require LLVM <= 17 for now, because LLVM 18 doesn't seem to work.</li>
<li>Remove constraints file because improved memory usage for s390x</li>
<li>Use %patch -P N instead of deprecated %patchN.</li>
</ul>
<p>Release notes:</p>
<ul>
<li>https://www.postgresql.org/docs/release/14.12/</li>
</ul>
<h2>Patch Instructions:</h2>
<p>
To install this SUSE 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.5
<br/>
<code>zypper in -t patch openSUSE-SLE-15.5-2024-1768=1</code>
</li>
<li class="list-group-item">
Legacy Module 15-SP5
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Legacy-15-SP5-2024-1768=1</code>
</li>
<li class="list-group-item">
SUSE Package Hub 15 15-SP5
<br/>
<code>zypper in -t patch SUSE-SLE-Module-Packagehub-Subpackages-15-SP5-2024-1768=1</code>
</li>
</ul>
<h2>Package List:</h2>
<ul>
<li>
openSUSE Leap 15.5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql14-plperl-14.12-150200.5.44.1</li>
<li>postgresql14-plpython-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-plpython-14.12-150200.5.44.1</li>
<li>postgresql14-contrib-14.12-150200.5.44.1</li>
<li>postgresql14-debugsource-14.12-150200.5.44.1</li>
<li>postgresql14-test-14.12-150200.5.44.1</li>
<li>postgresql14-llvmjit-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-server-14.12-150200.5.44.1</li>
<li>postgresql14-contrib-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-pltcl-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-llvmjit-14.12-150200.5.44.1</li>
<li>postgresql14-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-llvmjit-devel-14.12-150200.5.44.1</li>
<li>postgresql14-devel-14.12-150200.5.44.1</li>
<li>postgresql14-pltcl-14.12-150200.5.44.1</li>
<li>postgresql14-14.12-150200.5.44.1</li>
<li>postgresql14-server-devel-14.12-150200.5.44.1</li>
<li>postgresql14-devel-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-server-devel-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-server-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-plperl-debuginfo-14.12-150200.5.44.1</li>
</ul>
</li>
<li>
openSUSE Leap 15.5 (noarch)
<ul>
<li>postgresql14-docs-14.12-150200.5.44.1</li>
</ul>
</li>
<li>
Legacy Module 15-SP5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql14-plperl-14.12-150200.5.44.1</li>
<li>postgresql14-devel-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-plperl-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-plpython-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-pltcl-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-llvmjit-14.12-150200.5.44.1</li>
<li>postgresql14-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-contrib-14.12-150200.5.44.1</li>
<li>postgresql14-14.12-150200.5.44.1</li>
<li>postgresql14-plpython-14.12-150200.5.44.1</li>
<li>postgresql14-server-14.12-150200.5.44.1</li>
<li>postgresql14-debugsource-14.12-150200.5.44.1</li>
<li>postgresql14-llvmjit-devel-14.12-150200.5.44.1</li>
<li>postgresql14-server-devel-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-server-devel-14.12-150200.5.44.1</li>
<li>postgresql14-server-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-devel-14.12-150200.5.44.1</li>
<li>postgresql14-llvmjit-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-contrib-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-pltcl-14.12-150200.5.44.1</li>
</ul>
</li>
<li>
Legacy Module 15-SP5 (noarch)
<ul>
<li>postgresql14-docs-14.12-150200.5.44.1</li>
</ul>
</li>
<li>
SUSE Package Hub 15 15-SP5 (aarch64 ppc64le s390x x86_64)
<ul>
<li>postgresql14-llvmjit-14.12-150200.5.44.1</li>
<li>postgresql14-debuginfo-14.12-150200.5.44.1</li>
<li>postgresql14-debugsource-14.12-150200.5.44.1</li>
<li>postgresql14-test-14.12-150200.5.44.1</li>
<li>postgresql14-llvmjit-debuginfo-14.12-150200.5.44.1</li>
</ul>
</li>
</ul>
<h2>References:</h2>
<ul>
<li>
<a href="https://www.suse.com/security/cve/CVE-2024-4317.html">https://www.suse.com/security/cve/CVE-2024-4317.html</a>
</li>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1224038">https://bugzilla.suse.com/show_bug.cgi?id=1224038</a>
</li>
<li>
<a href="https://bugzilla.suse.com/show_bug.cgi?id=1224051">https://bugzilla.suse.com/show_bug.cgi?id=1224051</a>
</li>
</ul>
</div>