SUSE-SU-2023:4479-1
- Source
- https://www.suse.com/support/update/announcement/2023/suse-su-20234479-1/
- Import Source
- https://ftp.suse.com/pub/projects/security/osv/SUSE-SU-2023:4479-1.json
- JSON Data
- https://api.osv.dev/v1/vulns/SUSE-SU-2023:4479-1
- Upstream
- Related
- Published
- 2023-11-20T09:09:23Z
- Modified
- 2026-02-04T03:51:33Z
- Summary
- Security update for postgresql14
- Details
-
This update for postgresql14 fixes the following issues:
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 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'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)
-
update to 14.10: https://www.postgresql.org/docs/14/release-14-10.html
-
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.
- References
-
- https://www.suse.com/support/update/announcement/2023/suse-su-20234479-1/
- https://bugzilla.suse.com/1216022
- https://bugzilla.suse.com/1216734
- https://bugzilla.suse.com/1216960
- https://bugzilla.suse.com/1216961
- https://bugzilla.suse.com/1216962
- https://www.suse.com/security/cve/CVE-2023-5868
- https://www.suse.com/security/cve/CVE-2023-5869
- https://www.suse.com/security/cve/CVE-2023-5870
Affected packages
openSUSE:Leap 15.4
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/opensuse/postgresql14&distro=openSUSE%20Leap%2015.4
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-llvmjit": "14.10-150200.5.36.1",
"postgresql14-llvmjit-devel": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1",
"postgresql14-test": "14.10-150200.5.36.1"
}
]
}openSUSE:Leap 15.5
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/opensuse/postgresql14&distro=openSUSE%20Leap%2015.5
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-llvmjit": "14.10-150200.5.36.1",
"postgresql14-llvmjit-devel": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1",
"postgresql14-test": "14.10-150200.5.36.1"
}
]
}SUSE:Enterprise Storage 7.1
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Enterprise%20Storage%207.1
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise High Performance Computing 15 SP2-LTSS
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP2-LTSS
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise High Performance Computing 15 SP3-ESPOS
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-ESPOS
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise High Performance Computing 15 SP3-LTSS
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20High%20Performance%20Computing%2015%20SP3-LTSS
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise Module for Basesystem 15 SP4
SUSE:Linux Enterprise Module for Legacy 15 SP5
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Legacy%2015%20SP5
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-llvmjit": "14.10-150200.5.36.1",
"postgresql14-llvmjit-devel": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise Module for Package Hub 15 SP4
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP4
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
SUSE:Linux Enterprise Module for Package Hub 15 SP5
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Package%20Hub%2015%20SP5
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
SUSE:Linux Enterprise Module for Server Applications 15 SP4
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Module%20for%20Server%20Applications%2015%20SP4
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise Server 15 SP2-LTSS
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP2-LTSS
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise Server 15 SP3-LTSS
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%2015%20SP3-LTSS
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise Server for SAP Applications 15 SP2
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP2
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}SUSE:Linux Enterprise Server for SAP Applications 15 SP3
postgresql14
Package
- Name
- postgresql14
- Purl
- pkg:rpm/suse/postgresql14&distro=SUSE%20Linux%20Enterprise%20Server%20for%20SAP%20Applications%2015%20SP3
Affected ranges
- Type
- ECOSYSTEM
- Events
-
Introduced0 Unknown introduced version / All previous versions are affectedFixed14.10-150200.5.36.1
Ecosystem specific
{
"binaries": [
{
"postgresql14": "14.10-150200.5.36.1",
"postgresql14-contrib": "14.10-150200.5.36.1",
"postgresql14-devel": "14.10-150200.5.36.1",
"postgresql14-docs": "14.10-150200.5.36.1",
"postgresql14-plperl": "14.10-150200.5.36.1",
"postgresql14-plpython": "14.10-150200.5.36.1",
"postgresql14-pltcl": "14.10-150200.5.36.1",
"postgresql14-server": "14.10-150200.5.36.1",
"postgresql14-server-devel": "14.10-150200.5.36.1"
}
]
}