Skip to content
OpenAdvisories
Low · 3.1 CVE-2024-4317 EUVD-2024-43960GHSA-37xw-rpjg-xxfx

PostgreSQL pg_stats_ext and pg_stats_ext_exprs lack authorization checks

Published May 9, 2024 · Updated Mar 28, 2025 · Assigned by PostgreSQL

Description

Missing authorization in PostgreSQL built-in views pg_stats_ext and pg_stats_ext_exprs allows an unprivileged database user to read most common values and other statistics from CREATE STATISTICS commands of other users. The most common values may reveal column values the eavesdropper could not otherwise read or results of functions they cannot execute. Installing an unaffected version only fixes fresh PostgreSQL installations, namely those that are created with the initdb utility after installing that version. Current PostgreSQL installations will remain vulnerable until they follow the instructions in the release notes. Within major versions 14-16, minor versions before PostgreSQL 16.3, 15.7, and 14.12 are affected. Versions before PostgreSQL 14 are unaffected.

Affected products

VendorProductAffectedFixed
— PostgreSQL 16 – < 16.3, 15 – < 15.7, 14 – < 14.12 16.3

Fixed in Linux distributions

Distributions backport fixes, so the version that fixes this vulnerability differs per release — upgrade to at least the version shown. From the distributions' security trackers and advisories.

ReleasePackageFixed inAdvisory
Debian 12 postgresql-15 15.7-0+deb12u1 —
ReleasePackageFixed inAdvisory
Ubuntu 24.04 LTS postgresql-16 16.3-0ubuntu0.24.04.1 USN-6802-1
Ubuntu 22.04 LTS postgresql-14 14.12-0ubuntu0.22.04.1 USN-6802-1
ReleasePackageFixed inAdvisory
RHEL 9 pg_repack 1.4.8-1.module+el9.2.0+17405+aeb9ec60 RHSA-2024:6020, RHSA-2024:5929
RHEL 9 pgaudit 1.7.0-1.module+el9.2.0+17405+aeb9ec60 RHSA-2024:6020, RHSA-2024:5929
RHEL 9 postgres-decoderbufs 1.9.7-1.Final.module+el9.2.0+17405+aeb9ec60 RHSA-2024:6020, RHSA-2024:5929
RHEL 9 postgresql +14 15.8-1.module+el9.4.0+22208+cd6b92ff RHSA-2024:6020, RHSA-2024:5929
RHEL 8 pg_repack 1.4.8-1.module+el8.9.0+19797+c4ce5969 RHSA-2024:6001, RHSA-2024:5927
RHEL 8 pgaudit 1.7.0-1.module+el8.9.0+19797+c4ce5969 RHSA-2024:6001, RHSA-2024:5927
RHEL 8 postgres-decoderbufs 1.9.7-1.Final.module+el8.9.0+19797+c4ce5969 RHSA-2024:6001, RHSA-2024:5927
RHEL 8 postgresql +14 15.8-1.module+el8.10.0+22212+a51fe170 RHSA-2024:6001, RHSA-2024:5927
Show 1 more (older releases, extended support, other products)
ReleasePackageFixed inAdvisory
RHEL 8.8 EUS pg_repack 1.4.8-1.module+el8.8.0+17071+aaaceaa4 RHSA-2024:6142
RHEL 8.8 EUS pgaudit 1.7.0-1.module+el8.8.0+17071+aaaceaa4 RHSA-2024:6142
RHEL 8.8 EUS postgres-decoderbufs 1.9.7-1.Final.module+el8.8.0+17071+aaaceaa4 RHSA-2024:6142
RHEL 8.8 EUS postgresql +14 15.8-1.module+el8.8.0+22236+c63904f0 RHSA-2024:6142

AlmaLinux

Errata ↗
ReleasePackageFixed inAdvisory
AlmaLinux 9 pg_repack 1.4.8-1.module_el9.3.0+52+21733919 ALSA-2024:6020, ALSA-2024:5929
AlmaLinux 9 pgaudit 1.7.0-1.module_el9.3.0+52+21733919 ALSA-2024:6020, ALSA-2024:5929
AlmaLinux 9 postgres-decoderbufs 1.9.7-1.Final.module_el9.3.0+52+21733919 ALSA-2024:6020, ALSA-2024:5929
AlmaLinux 9 postgresql +14 15.8-1.module_el9.4.0+111+667b9e9e ALSA-2024:6020, ALSA-2024:5929
AlmaLinux 8 pg_repack 1.4.8-1.module_el8.9.0+3706+885c732e ALSA-2024:6001, ALSA-2024:5927
AlmaLinux 8 pgaudit 1.7.0-1.module_el8.9.0+3706+885c732e ALSA-2024:6001, ALSA-2024:5927
AlmaLinux 8 postgres-decoderbufs 1.9.7-1.Final.module_el8.9.0+3706+885c732e ALSA-2024:6001, ALSA-2024:5927
AlmaLinux 8 postgresql +14 15.8-1.module_el8.10.0+3888+1aead837 ALSA-2024:6001, ALSA-2024:5927

Rocky Linux

Errata ↗
ReleasePackageFixed inAdvisory
Rocky Linux 9 pgaudit 1.7.0-1.module+el9.5.0+30637+4391fcca RLSA-2024:6020, RLSA-2024:5929
Rocky Linux 9 postgres-decoderbufs 1.9.7-1.Final.module+el9.5.0+30637+4391fcca RLSA-2024:6020, RLSA-2024:5929
Rocky Linux 8 pg_repack 1.4.8-1.module+el8.9.0+1525+fc91df60 RLSA-2024:6001, RLSA-2024:5927
Rocky Linux 8 pgaudit 1.7.0-1.module+el8.9.0+1525+fc91df60 RLSA-2024:6001, RLSA-2024:5927
Rocky Linux 8 postgres-decoderbufs 1.9.7-1.Final.module+el8.9.0+1525+fc91df60 RLSA-2024:6001, RLSA-2024:5927
Rocky Linux 8 postgresql 15.8-1.module+el8.10.0+1864+f5aa9248 RLSA-2024:6001, RLSA-2024:5927
ReleasePackageFixed inAdvisory
SLES 15 SP6 postgresql14 14.12-150600.16.3.1 SUSE-SU-2024:2262-3, SUSE-SU-2024:2262-2, SUSE-SU-2024:2262-1
SLES 15 SP6 postgresql15 15.7-150600.16.3.1 SUSE-SU-2024:2261-1
SLES 15 SP6 postgresql16 16.2-150600.16.2.1 SUSE-SU-2024:3159-2, SUSE-SU-2024:3159-1, SUSE-SU-2024:2266-1
SLES 15 SP5 postgresql14 14.12-150200.5.44.1 SUSE-SU-2024:1768-1
SLES 15 SP5 postgresql15 15.7-150200.5.27.1 SUSE-SU-2024:1777-1
SLES 15 SP5 postgresql16 16.3-150200.5.13.1 SUSE-SU-2024:1652-1
SLES 12 SP5 postgresql14 14.12-3.41.1 SUSE-SU-2024:1703-1
SLES 12 SP5 postgresql15 15.7-3.25.1 SUSE-SU-2024:1653-1
SLES 12 SP5 postgresql16 16.3-3.13.1 SUSE-SU-2024:1651-1
Show 1 more (older releases, extended support, other products)
ReleasePackageFixed inAdvisory
SLES for SAP 12 SP5 postgresql14 14.12-3.41.1 SUSE-SU-2024:1703-1
SLES for SAP 12 SP5 postgresql15 15.7-3.25.1 SUSE-SU-2024:1653-1
SLES for SAP 12 SP5 postgresql16 16.3-3.13.1 SUSE-SU-2024:1651-1
ReleasePackageFixed inAdvisory
openSUSE Tumbleweed postgresql14 14.12-1.1 openSUSE-SU-2024:13946-1
openSUSE Tumbleweed postgresql15 15.7-1.1 openSUSE-SU-2024:13947-1
openSUSE Tumbleweed postgresql16 16.3-1.1 openSUSE-SU-2024:13950-1
openSUSE Leap 15.6 postgresql14 14.12-150600.16.3.1 SUSE-SU-2024:2262-1
openSUSE Leap 15.6 postgresql15 15.7-150600.16.3.1 SUSE-SU-2024:2261-1
openSUSE Leap 15.6 postgresql16 16.2-150600.16.2.1 SUSE-SU-2024:3159-1, SUSE-SU-2024:2266-1
openSUSE Leap 15.5 postgresql14 14.12-150200.5.44.1 SUSE-SU-2024:1768-1
openSUSE Leap 15.5 postgresql15 15.7-150200.5.27.1 SUSE-SU-2024:1777-1
openSUSE Leap 15.5 postgresql16 +1 16.3-150200.5.13.1 SUSE-SU-2024:1652-1

Amazon Linux

ReleasePackageFixed inAdvisory
Amazon Linux 2023 postgresql15 +15 15.7-1.amzn2023.0.1 ALAS2023-2024-635

Azure Linux

ReleasePackageFixed inAdvisory
Azure Linux 3 postgresql 16.3-1 —

Oracle Linux

ReleasePackageFixed inAdvisory
Oracle Linux 9 pg_repack 1.4.8-1.module+el9.2.0+21134+ceb95ed9 ELSA-2024-6020, ELSA-2024-5929
Oracle Linux 9 pgaudit 1.7.0-1.module+el9.2.0+21134+ceb95ed9 ELSA-2024-6020, ELSA-2024-5929
Oracle Linux 9 postgres-decoderbufs 1.9.7-1.Final.module+el9.2.0+21134+ceb95ed9 ELSA-2024-6020, ELSA-2024-5929
Oracle Linux 9 postgresql +14 15.8-1.module+el9.4.0+90399+63b2ad7b ELSA-2024-6020, ELSA-2024-5929
Oracle Linux 8 pg_repack 1.4.8-1.module+el8.9.0+90110+d8a562d5 ELSA-2024-6001, ELSA-2024-5927
Oracle Linux 8 pgaudit 1.7.0-1.module+el8.9.0+90110+d8a562d5 ELSA-2024-6001, ELSA-2024-5927
Oracle Linux 8 postgres-decoderbufs 1.9.7-1.Final.module+el8.9.0+90110+d8a562d5 ELSA-2024-6001, ELSA-2024-5927
Oracle Linux 8 postgresql +14 15.8-1.module+el8.10.0+90396+38e9dad0 ELSA-2024-6001, ELSA-2024-5927

Wolfi

ReleasePackageFixed inAdvisory
Wolfi rolling postgresql-14 14.19-r1 —
Wolfi rolling postgresql-14-client 14.24-r2 —
Wolfi rolling postgresql-15 15.14-r0 —
Wolfi rolling postgresql-15-client 15.19-r2 —
Wolfi rolling postgresql-16 16.3-r0 —

Advisories 37

References