SUSE-SU-2023:4425-1

See a problem?

Import Source

https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:4425-1.json

JSON Data

https://api.osv.dev/v1/vulns/SUSE-SU-2023:4425-1

Related

Published

2023-11-13T12:36:26Z

Modified

2023-11-13T12:36:26Z

Summary

Security update for postgresql, postgresql15, postgresql16

Details

This update for postgresql, postgresql15, postgresql16 fixes the following issues:

This update ships postgresql 16 (jsc#PED-5586).

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 pgsignalbackend role from signalling background workers and autovacuum processes. The documentation says that pgsignalbackend 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'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)

Changes in postgresql16:

Upgrade to 16.1:
- https://www.postgresql.org/about/news/2715
- https://www.postgresql.org/docs/16/release-16.html
- https://www.postgresql.org/docs/16/release-16-1.html

Changes in postgresql15:

Update to 15.5 https://www.postgresql.org/docs/15/release-15-5.html
The libs and mini package are now provided by postgresql16.
Overhaul postgresql-README.SUSE and move it from the binary package to the noarch wrapper package.
Change the unix domain socket location from /var/run to /run.

Changes in postgresql:

Bump default to 16.
Interlock version and release of all noarch packages except for the postgresql-docs.
Bump major version to prepare for PostgreSQL 16, but keep default at 15 for now on Factory.
bsc#1122892: Add a sysconfig variable for initdb.
Overhaul postgresql-README.SUSE and move it from the binary package to the noarch wrapper package.
bsc#1179231: Add an explanation for the /tmp -> /run/postgresql move and permission change.
Add postgresql-README as a separate source file.
bsc#1209208: Drop hard dependency on systemd
bsc#1206796: Refine the distinction of where to use sysusers and use bcond to have the expression only in one place.
avoid bashisms in /bin/sh based startup script
Bump to postgresql 15
Change to systemd-sysusers

References

Affected packages

SUSE:Linux Enterprise Software Development Kit 12 SP5 / postgresql

Package

Name: postgresql
Purl: purl:rpm/suse/postgresql&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

16-4.23.3

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-server-devel": "15.5-3.19.2",
            "postgresql-devel": "16-4.23.3",
            "postgresql15-devel": "15.5-3.19.2",
            "postgresql-server-devel": "16-4.23.3",
            "postgresql16-devel": "16.1-3.7.1",
            "postgresql16-server-devel": "16.1-3.7.1"
        }
    ]
}

SUSE:Linux Enterprise Software Development Kit 12 SP5 / postgresql15

Package

Name: postgresql15
Purl: purl:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

15.5-3.19.2

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-server-devel": "15.5-3.19.2",
            "postgresql-devel": "16-4.23.3",
            "postgresql15-devel": "15.5-3.19.2",
            "postgresql-server-devel": "16-4.23.3",
            "postgresql16-devel": "16.1-3.7.1",
            "postgresql16-server-devel": "16.1-3.7.1"
        }
    ]
}

SUSE:Linux Enterprise Software Development Kit 12 SP5 / postgresql16

Package

Name: postgresql16
Purl: purl:rpm/suse/postgresql16&distro=SUSE%20Linux%20Enterprise%20Software%20Development%20Kit%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

16.1-3.7.1

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-server-devel": "15.5-3.19.2",
            "postgresql-devel": "16-4.23.3",
            "postgresql15-devel": "15.5-3.19.2",
            "postgresql-server-devel": "16-4.23.3",
            "postgresql16-devel": "16.1-3.7.1",
            "postgresql16-server-devel": "16.1-3.7.1"
        }
    ]
}

SUSE:Linux Enterprise Server 12 SP5 / postgresql

Package

Name: postgresql
Purl: purl:rpm/suse/postgresql&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

16-4.23.3

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-contrib": "15.5-3.19.2",
            "libecpg6": "16.1-3.7.1",
            "libpq5-32bit": "16.1-3.7.1",
            "postgresql-plperl": "16-4.23.3",
            "postgresql15": "15.5-3.19.2",
            "postgresql15-plperl": "15.5-3.19.2",
            "postgresql15-plpython": "15.5-3.19.2",
            "postgresql15-server": "15.5-3.19.2",
            "postgresql16-plperl": "16.1-3.7.1",
            "libpq5": "16.1-3.7.1",
            "postgresql-pltcl": "16-4.23.3",
            "postgresql16": "16.1-3.7.1",
            "postgresql15-docs": "15.5-3.19.2",
            "postgresql-docs": "16-4.23.3",
            "libecpg6-32bit": "16.1-3.7.1",
            "postgresql-plpython": "16-4.23.3",
            "postgresql16-server": "16.1-3.7.1",
            "postgresql16-plpython": "16.1-3.7.1",
            "postgresql15-pltcl": "15.5-3.19.2",
            "postgresql-contrib": "16-4.23.3",
            "postgresql16-contrib": "16.1-3.7.1",
            "postgresql": "16-4.23.3",
            "postgresql16-pltcl": "16.1-3.7.1",
            "postgresql-server": "16-4.23.3",
            "postgresql16-docs": "16.1-3.7.1"
        }
    ]
}

SUSE:Linux Enterprise Server 12 SP5 / postgresql15

Package

Name: postgresql15
Purl: purl:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

15.5-3.19.2

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-contrib": "15.5-3.19.2",
            "libecpg6": "16.1-3.7.1",
            "libpq5-32bit": "16.1-3.7.1",
            "postgresql-plperl": "16-4.23.3",
            "postgresql15": "15.5-3.19.2",
            "postgresql15-plperl": "15.5-3.19.2",
            "postgresql15-plpython": "15.5-3.19.2",
            "postgresql15-server": "15.5-3.19.2",
            "postgresql16-plperl": "16.1-3.7.1",
            "libpq5": "16.1-3.7.1",
            "postgresql-pltcl": "16-4.23.3",
            "postgresql16": "16.1-3.7.1",
            "postgresql15-docs": "15.5-3.19.2",
            "postgresql-docs": "16-4.23.3",
            "libecpg6-32bit": "16.1-3.7.1",
            "postgresql-plpython": "16-4.23.3",
            "postgresql16-server": "16.1-3.7.1",
            "postgresql16-plpython": "16.1-3.7.1",
            "postgresql15-pltcl": "15.5-3.19.2",
            "postgresql-contrib": "16-4.23.3",
            "postgresql16-contrib": "16.1-3.7.1",
            "postgresql": "16-4.23.3",
            "postgresql16-pltcl": "16.1-3.7.1",
            "postgresql-server": "16-4.23.3",
            "postgresql16-docs": "16.1-3.7.1"
        }
    ]
}

SUSE:Linux Enterprise Server 12 SP5 / postgresql16

Package

Name: postgresql16
Purl: purl:rpm/suse/postgresql16&distro=SUSE%20Linux%20Enterprise%20Server%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

16.1-3.7.1

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-contrib": "15.5-3.19.2",
            "libecpg6": "16.1-3.7.1",
            "libpq5-32bit": "16.1-3.7.1",
            "postgresql-plperl": "16-4.23.3",
            "postgresql15": "15.5-3.19.2",
            "postgresql15-plperl": "15.5-3.19.2",
            "postgresql15-plpython": "15.5-3.19.2",
            "postgresql15-server": "15.5-3.19.2",
            "postgresql16-plperl": "16.1-3.7.1",
            "libpq5": "16.1-3.7.1",
            "postgresql-pltcl": "16-4.23.3",
            "postgresql16": "16.1-3.7.1",
            "postgresql15-docs": "15.5-3.19.2",
            "postgresql-docs": "16-4.23.3",
            "libecpg6-32bit": "16.1-3.7.1",
            "postgresql-plpython": "16-4.23.3",
            "postgresql16-server": "16.1-3.7.1",
            "postgresql16-plpython": "16.1-3.7.1",
            "postgresql15-pltcl": "15.5-3.19.2",
            "postgresql-contrib": "16-4.23.3",
            "postgresql16-contrib": "16.1-3.7.1",
            "postgresql": "16-4.23.3",
            "postgresql16-pltcl": "16.1-3.7.1",
            "postgresql-server": "16-4.23.3",
            "postgresql16-docs": "16.1-3.7.1"
        }
    ]
}

SUSE:Linux Enterprise Server for SAP Applications 12 SP5 / postgresql

Package

Name: postgresql
Purl: purl:rpm/suse/postgresql&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

16-4.23.3

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-contrib": "15.5-3.19.2",
            "libecpg6": "16.1-3.7.1",
            "libpq5-32bit": "16.1-3.7.1",
            "postgresql-plperl": "16-4.23.3",
            "postgresql15": "15.5-3.19.2",
            "postgresql15-plperl": "15.5-3.19.2",
            "postgresql15-plpython": "15.5-3.19.2",
            "postgresql15-server": "15.5-3.19.2",
            "postgresql16-plperl": "16.1-3.7.1",
            "libpq5": "16.1-3.7.1",
            "postgresql-pltcl": "16-4.23.3",
            "postgresql16": "16.1-3.7.1",
            "postgresql15-docs": "15.5-3.19.2",
            "postgresql-docs": "16-4.23.3",
            "libecpg6-32bit": "16.1-3.7.1",
            "postgresql-plpython": "16-4.23.3",
            "postgresql16-server": "16.1-3.7.1",
            "postgresql16-plpython": "16.1-3.7.1",
            "postgresql15-pltcl": "15.5-3.19.2",
            "postgresql-contrib": "16-4.23.3",
            "postgresql16-contrib": "16.1-3.7.1",
            "postgresql": "16-4.23.3",
            "postgresql16-pltcl": "16.1-3.7.1",
            "postgresql-server": "16-4.23.3",
            "postgresql16-docs": "16.1-3.7.1"
        }
    ]
}

SUSE:Linux Enterprise Server for SAP Applications 12 SP5 / postgresql15

Package

Name: postgresql15
Purl: purl:rpm/suse/postgresql15&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

15.5-3.19.2

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-contrib": "15.5-3.19.2",
            "libecpg6": "16.1-3.7.1",
            "libpq5-32bit": "16.1-3.7.1",
            "postgresql-plperl": "16-4.23.3",
            "postgresql15": "15.5-3.19.2",
            "postgresql15-plperl": "15.5-3.19.2",
            "postgresql15-plpython": "15.5-3.19.2",
            "postgresql15-server": "15.5-3.19.2",
            "postgresql16-plperl": "16.1-3.7.1",
            "libpq5": "16.1-3.7.1",
            "postgresql-pltcl": "16-4.23.3",
            "postgresql16": "16.1-3.7.1",
            "postgresql15-docs": "15.5-3.19.2",
            "postgresql-docs": "16-4.23.3",
            "libecpg6-32bit": "16.1-3.7.1",
            "postgresql-plpython": "16-4.23.3",
            "postgresql16-server": "16.1-3.7.1",
            "postgresql16-plpython": "16.1-3.7.1",
            "postgresql15-pltcl": "15.5-3.19.2",
            "postgresql-contrib": "16-4.23.3",
            "postgresql16-contrib": "16.1-3.7.1",
            "postgresql": "16-4.23.3",
            "postgresql16-pltcl": "16.1-3.7.1",
            "postgresql-server": "16-4.23.3",
            "postgresql16-docs": "16.1-3.7.1"
        }
    ]
}

SUSE:Linux Enterprise Server for SAP Applications 12 SP5 / postgresql16

Package

Name: postgresql16
Purl: purl:rpm/suse/postgresql16&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2012%20SP5

Affected ranges

Type: ECOSYSTEM
Events: Introduced

0Unknown introduced version / All previous versions are affected

Fixed

16.1-3.7.1

Ecosystem specific

{
    "binaries": [
        {
            "postgresql15-contrib": "15.5-3.19.2",
            "libecpg6": "16.1-3.7.1",
            "libpq5-32bit": "16.1-3.7.1",
            "postgresql-plperl": "16-4.23.3",
            "postgresql15": "15.5-3.19.2",
            "postgresql15-plperl": "15.5-3.19.2",
            "postgresql15-plpython": "15.5-3.19.2",
            "postgresql15-server": "15.5-3.19.2",
            "postgresql16-plperl": "16.1-3.7.1",
            "libpq5": "16.1-3.7.1",
            "postgresql-pltcl": "16-4.23.3",
            "postgresql16": "16.1-3.7.1",
            "postgresql15-docs": "15.5-3.19.2",
            "postgresql-docs": "16-4.23.3",
            "libecpg6-32bit": "16.1-3.7.1",
            "postgresql-plpython": "16-4.23.3",
            "postgresql16-server": "16.1-3.7.1",
            "postgresql16-plpython": "16.1-3.7.1",
            "postgresql15-pltcl": "15.5-3.19.2",
            "postgresql-contrib": "16-4.23.3",
            "postgresql16-contrib": "16.1-3.7.1",
            "postgresql": "16-4.23.3",
            "postgresql16-pltcl": "16.1-3.7.1",
            "postgresql-server": "16-4.23.3",
            "postgresql16-docs": "16.1-3.7.1"
        }
    ]
}