<div class="container">
    <h1>Security update for postgresql, postgresql15, postgresql16</h1>

    <table class="table table-striped table-bordered">
        <tbody>
        <tr>
            <th>Announcement ID:</th>
            <td>SUSE-SU-2023:4425-1</td>
        </tr>
        
        <tr>
            <th>Rating:</th>
            <td>important</td>
        </tr>
        <tr>
            <th>References:</th>
            <td>
                <ul>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1122892">bsc#1122892</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1179231">bsc#1179231</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1206796">bsc#1206796</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1209208">bsc#1209208</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216022">bsc#1216022</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216734">bsc#1216734</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216960">bsc#1216960</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216961">bsc#1216961</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216962">bsc#1216962</a>
                        </li>
                    
                    
                        <li style="display: inline;">
                            <a href="https://jira.suse.com/browse/PED-5586">jsc#PED-5586</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-5868.html">CVE-2023-5868</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://www.suse.com/security/cve/CVE-2023-5869.html">CVE-2023-5869</a>
                        </li>
                    
                        <li style="display: inline;">
                            <a href="https://www.suse.com/security/cve/CVE-2023-5870.html">CVE-2023-5870</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-5868</span>
                                <span class="cvss-source">
                                    (
                                    
                                        SUSE
                                    
                                    ):
                                </span>
                                <span class="cvss-score">7.5</span>
                                <span class="cvss-vector">CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:N/A:N</span>
                            </li>
                        
                            <li class="list-group-item">
                                <span class="cvss-reference">CVE-2023-5869</span>
                                <span class="cvss-source">
                                    (
                                    
                                        SUSE
                                    
                                    ):
                                </span>
                                <span class="cvss-score">9.8</span>
                                <span class="cvss-vector">CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H</span>
                            </li>
                        
                            <li class="list-group-item">
                                <span class="cvss-reference">CVE-2023-5870</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:N/I:N/A:H</span>
                            </li>
                        
                    </ul>
                </td>
            </tr>
        
        <tr>
            <th>Affected Products:</th>
            <td>
                <ul class="list-group">
                    
                        <li class="list-group-item">SUSE Linux Enterprise High Performance Computing 12 SP5</li>
                    
                        <li class="list-group-item">SUSE Linux Enterprise Server 12 SP5</li>
                    
                        <li class="list-group-item">SUSE Linux Enterprise Server for SAP Applications 12 SP5</li>
                    
                        <li class="list-group-item">SUSE Linux Enterprise Software Development Kit 12 SP5</li>
                    
                </ul>
            </td>
        </tr>
        </tbody>
    </table>

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

    


    
        <h2>Description:</h2>
    
    <p>This update for postgresql, postgresql15, postgresql16 fixes the following issues:</p>
<p>This update ships postgresql 16 (jsc#PED-5586).</p>
<p>Security issues fixed:</p>
<ul>
<li>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)</li>
<li>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)</li>
<li>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&#x27;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)</li>
</ul>
<p>Changes in postgresql16:</p>
<ul>
<li>
<p>Upgrade to 16.1:</p>
</li>
<li>
<p>https://www.postgresql.org/about/news/2715</p>
</li>
<li>https://www.postgresql.org/docs/16/release-16.html</li>
<li>https://www.postgresql.org/docs/16/release-16-1.html</li>
</ul>
<p>Changes in postgresql15:</p>
<ul>
<li>
<p>Update to 15.5 https://www.postgresql.org/docs/15/release-15-5.html</p>
</li>
<li>
<p>The libs and mini package are now provided by postgresql16.</p>
</li>
<li>Overhaul postgresql-README.SUSE and move it from the binary
  package to the noarch wrapper package.</li>
<li>Change the unix domain socket location from /var/run to /run.</li>
</ul>
<p>Changes in postgresql:</p>
<ul>
<li>Bump default to 16.</li>
<li>Interlock version and release of all noarch packages except for
  the postgresql-docs.</li>
<li>Bump major version to prepare for PostgreSQL 16, but keep
  default at 15 for now on Factory.</li>
<li>bsc#1122892: Add a sysconfig variable for initdb.</li>
<li>Overhaul postgresql-README.SUSE and move it from the binary
  package to the noarch wrapper package.</li>
<li>bsc#1179231: Add an explanation for the /tmp -> /run/postgresql
  move and permission change.</li>
<li>Add postgresql-README as a separate source file.</li>
<li>bsc#1209208: Drop hard dependency on systemd</li>
<li>bsc#1206796: Refine the distinction of where to use sysusers and
  use bcond to have the expression only in one place.</li>
<li>avoid bashisms in /bin/sh based startup script </li>
<li>Bump to postgresql 15 </li>
<li>Change to systemd-sysusers</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">
                SUSE Linux Enterprise Software Development Kit 12 SP5
                
                    
                        <br/>
                        <code>zypper in -t patch SUSE-SLE-SDK-12-SP5-2023-4425=1</code>
                    
                    
                
            </li>
        
            <li class="list-group-item">
                SUSE Linux Enterprise High Performance Computing 12 SP5
                
                    
                        <br/>
                        <code>zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-4425=1</code>
                    
                    
                
            </li>
        
            <li class="list-group-item">
                SUSE Linux Enterprise Server 12 SP5
                
                    
                        <br/>
                        <code>zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-4425=1</code>
                    
                    
                
            </li>
        
            <li class="list-group-item">
                SUSE Linux Enterprise Server for SAP Applications 12 SP5
                
                    
                        <br/>
                        <code>zypper in -t patch SUSE-SLE-SERVER-12-SP5-2023-4425=1</code>
                    
                    
                
            </li>
        
    </ul>

    <h2>Package List:</h2>
    <ul>
        
            
                <li>
                    SUSE Linux Enterprise Software Development Kit 12 SP5 (noarch)
                    <ul>
                        
                            <li>postgresql-devel-16-4.23.3</li>
                        
                            <li>postgresql-server-devel-16-4.23.3</li>
                        
                    </ul>
                </li>
            
                <li>
                    SUSE Linux Enterprise Software Development Kit 12 SP5 (aarch64 ppc64le s390x x86_64)
                    <ul>
                        
                            <li>postgresql15-server-devel-15.5-3.19.2</li>
                        
                            <li>postgresql15-devel-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-devel-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-server-devel-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-server-devel-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql16-server-devel-16.1-3.7.1</li>
                        
                            <li>postgresql15-devel-15.5-3.19.2</li>
                        
                            <li>postgresql16-devel-16.1-3.7.1</li>
                        
                    </ul>
                </li>
            
        
            
                <li>
                    SUSE Linux Enterprise High Performance Computing 12 SP5 (aarch64 x86_64)
                    <ul>
                        
                            <li>postgresql15-contrib-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-plperl-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-server-15.5-3.19.2</li>
                        
                            <li>postgresql16-contrib-debuginfo-16.1-3.7.1</li>
                        
                            <li>libecpg6-16.1-3.7.1</li>
                        
                            <li>libecpg6-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-plperl-15.5-3.19.2</li>
                        
                            <li>postgresql16-pltcl-16.1-3.7.1</li>
                        
                            <li>postgresql16-server-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-contrib-15.5-3.19.2</li>
                        
                            <li>libpq5-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql15-plperl-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql15-plpython-15.5-3.19.2</li>
                        
                            <li>postgresql16-debugsource-16.1-3.7.1</li>
                        
                            <li>postgresql16-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-plpython-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-16.1-3.7.1</li>
                        
                            <li>postgresql16-plpython-16.1-3.7.1</li>
                        
                            <li>postgresql15-debugsource-15.5-3.19.2</li>
                        
                            <li>postgresql16-pltcl-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-pltcl-15.5-3.19.2</li>
                        
                            <li>postgresql15-server-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-plpython-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql16-plperl-16.1-3.7.1</li>
                        
                            <li>postgresql15-pltcl-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-server-16.1-3.7.1</li>
                        
                            <li>postgresql15-15.5-3.19.2</li>
                        
                            <li>postgresql16-contrib-16.1-3.7.1</li>
                        
                            <li>libpq5-16.1-3.7.1</li>
                        
                    </ul>
                </li>
            
                <li>
                    SUSE Linux Enterprise High Performance Computing 12 SP5 (noarch)
                    <ul>
                        
                            <li>postgresql16-docs-16.1-3.7.1</li>
                        
                            <li>postgresql-plperl-16-4.23.3</li>
                        
                            <li>postgresql-server-16-4.23.3</li>
                        
                            <li>postgresql-plpython-16-4.23.3</li>
                        
                            <li>postgresql-docs-16-4.23.3</li>
                        
                            <li>postgresql-pltcl-16-4.23.3</li>
                        
                            <li>postgresql15-docs-15.5-3.19.2</li>
                        
                            <li>postgresql-16-4.23.3</li>
                        
                            <li>postgresql-contrib-16-4.23.3</li>
                        
                    </ul>
                </li>
            
                <li>
                    SUSE Linux Enterprise High Performance Computing 12 SP5 (x86_64)
                    <ul>
                        
                            <li>libpq5-debuginfo-32bit-16.1-3.7.1</li>
                        
                            <li>libpq5-32bit-16.1-3.7.1</li>
                        
                            <li>libecpg6-debuginfo-32bit-16.1-3.7.1</li>
                        
                            <li>libecpg6-32bit-16.1-3.7.1</li>
                        
                    </ul>
                </li>
            
        
            
                <li>
                    SUSE Linux Enterprise Server 12 SP5 (aarch64 ppc64le s390x x86_64)
                    <ul>
                        
                            <li>postgresql15-contrib-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-plperl-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-server-15.5-3.19.2</li>
                        
                            <li>postgresql16-contrib-debuginfo-16.1-3.7.1</li>
                        
                            <li>libecpg6-16.1-3.7.1</li>
                        
                            <li>libecpg6-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-plperl-15.5-3.19.2</li>
                        
                            <li>postgresql16-pltcl-16.1-3.7.1</li>
                        
                            <li>postgresql16-server-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-contrib-15.5-3.19.2</li>
                        
                            <li>libpq5-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql15-plperl-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql15-plpython-15.5-3.19.2</li>
                        
                            <li>postgresql16-debugsource-16.1-3.7.1</li>
                        
                            <li>postgresql16-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-plpython-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-16.1-3.7.1</li>
                        
                            <li>postgresql16-plpython-16.1-3.7.1</li>
                        
                            <li>postgresql15-debugsource-15.5-3.19.2</li>
                        
                            <li>postgresql16-pltcl-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-pltcl-15.5-3.19.2</li>
                        
                            <li>postgresql15-server-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-plpython-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql16-plperl-16.1-3.7.1</li>
                        
                            <li>postgresql15-pltcl-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-server-16.1-3.7.1</li>
                        
                            <li>postgresql15-15.5-3.19.2</li>
                        
                            <li>postgresql16-contrib-16.1-3.7.1</li>
                        
                            <li>libpq5-16.1-3.7.1</li>
                        
                    </ul>
                </li>
            
                <li>
                    SUSE Linux Enterprise Server 12 SP5 (noarch)
                    <ul>
                        
                            <li>postgresql16-docs-16.1-3.7.1</li>
                        
                            <li>postgresql-plperl-16-4.23.3</li>
                        
                            <li>postgresql-server-16-4.23.3</li>
                        
                            <li>postgresql-plpython-16-4.23.3</li>
                        
                            <li>postgresql-docs-16-4.23.3</li>
                        
                            <li>postgresql-pltcl-16-4.23.3</li>
                        
                            <li>postgresql15-docs-15.5-3.19.2</li>
                        
                            <li>postgresql-16-4.23.3</li>
                        
                            <li>postgresql-contrib-16-4.23.3</li>
                        
                    </ul>
                </li>
            
                <li>
                    SUSE Linux Enterprise Server 12 SP5 (s390x x86_64)
                    <ul>
                        
                            <li>libpq5-debuginfo-32bit-16.1-3.7.1</li>
                        
                            <li>libpq5-32bit-16.1-3.7.1</li>
                        
                            <li>libecpg6-debuginfo-32bit-16.1-3.7.1</li>
                        
                            <li>libecpg6-32bit-16.1-3.7.1</li>
                        
                    </ul>
                </li>
            
        
            
                <li>
                    SUSE Linux Enterprise Server for SAP Applications 12 SP5 (ppc64le x86_64)
                    <ul>
                        
                            <li>postgresql15-contrib-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-plperl-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-server-15.5-3.19.2</li>
                        
                            <li>postgresql16-contrib-debuginfo-16.1-3.7.1</li>
                        
                            <li>libecpg6-16.1-3.7.1</li>
                        
                            <li>libecpg6-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-plperl-15.5-3.19.2</li>
                        
                            <li>postgresql16-pltcl-16.1-3.7.1</li>
                        
                            <li>postgresql16-server-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-contrib-15.5-3.19.2</li>
                        
                            <li>libpq5-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql15-plperl-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql15-plpython-15.5-3.19.2</li>
                        
                            <li>postgresql16-debugsource-16.1-3.7.1</li>
                        
                            <li>postgresql16-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-plpython-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-16.1-3.7.1</li>
                        
                            <li>postgresql16-plpython-16.1-3.7.1</li>
                        
                            <li>postgresql15-debugsource-15.5-3.19.2</li>
                        
                            <li>postgresql16-pltcl-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql15-pltcl-15.5-3.19.2</li>
                        
                            <li>postgresql15-server-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-plpython-debuginfo-16.1-3.7.1</li>
                        
                            <li>postgresql16-plperl-16.1-3.7.1</li>
                        
                            <li>postgresql15-pltcl-debuginfo-15.5-3.19.2</li>
                        
                            <li>postgresql16-server-16.1-3.7.1</li>
                        
                            <li>postgresql15-15.5-3.19.2</li>
                        
                            <li>postgresql16-contrib-16.1-3.7.1</li>
                        
                            <li>libpq5-16.1-3.7.1</li>
                        
                    </ul>
                </li>
            
                <li>
                    SUSE Linux Enterprise Server for SAP Applications 12 SP5 (noarch)
                    <ul>
                        
                            <li>postgresql16-docs-16.1-3.7.1</li>
                        
                            <li>postgresql-plperl-16-4.23.3</li>
                        
                            <li>postgresql-server-16-4.23.3</li>
                        
                            <li>postgresql-plpython-16-4.23.3</li>
                        
                            <li>postgresql-docs-16-4.23.3</li>
                        
                            <li>postgresql-pltcl-16-4.23.3</li>
                        
                            <li>postgresql15-docs-15.5-3.19.2</li>
                        
                            <li>postgresql-16-4.23.3</li>
                        
                            <li>postgresql-contrib-16-4.23.3</li>
                        
                    </ul>
                </li>
            
                <li>
                    SUSE Linux Enterprise Server for SAP Applications 12 SP5 (x86_64)
                    <ul>
                        
                            <li>libpq5-debuginfo-32bit-16.1-3.7.1</li>
                        
                            <li>libpq5-32bit-16.1-3.7.1</li>
                        
                            <li>libecpg6-debuginfo-32bit-16.1-3.7.1</li>
                        
                            <li>libecpg6-32bit-16.1-3.7.1</li>
                        
                    </ul>
                </li>
            
        
    </ul>

    
        <h2>References:</h2>
        <ul>
            
                
                    <li>
                        <a href="https://www.suse.com/security/cve/CVE-2023-5868.html">https://www.suse.com/security/cve/CVE-2023-5868.html</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://www.suse.com/security/cve/CVE-2023-5869.html">https://www.suse.com/security/cve/CVE-2023-5869.html</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://www.suse.com/security/cve/CVE-2023-5870.html">https://www.suse.com/security/cve/CVE-2023-5870.html</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1122892">https://bugzilla.suse.com/show_bug.cgi?id=1122892</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1179231">https://bugzilla.suse.com/show_bug.cgi?id=1179231</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1206796">https://bugzilla.suse.com/show_bug.cgi?id=1206796</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1209208">https://bugzilla.suse.com/show_bug.cgi?id=1209208</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216022">https://bugzilla.suse.com/show_bug.cgi?id=1216022</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216734">https://bugzilla.suse.com/show_bug.cgi?id=1216734</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216960">https://bugzilla.suse.com/show_bug.cgi?id=1216960</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216961">https://bugzilla.suse.com/show_bug.cgi?id=1216961</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://bugzilla.suse.com/show_bug.cgi?id=1216962">https://bugzilla.suse.com/show_bug.cgi?id=1216962</a>
                    </li>
                
            
                
                    <li>
                        <a href="https://jira.suse.com/browse/PED-5586">https://jira.suse.com/browse/PED-5586</a>
                    </li>
                
            
        </ul>
    
</div>