Red Hat Security Advisory: postgresql:13 security update
🔗 CVE IDs covered (3)
📋 Description
CVE-2024-10976 — postgresql: PostgreSQL row security below e.g. subqueries disregards user ID changes CVE-2024-10978 — postgresql: PostgreSQL SET ROLE, SET SESSION AUTHORIZATION reset to wrong user ID CVE-2024-10979 — postgresql: PostgreSQL PL/Perl environment variable changes execute arbitrary code
🎯 Affected products138
- Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.aarch64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.ppc64le (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.s390x (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.src (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.x86_64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-debuginfo-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.aarch64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-debuginfo-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.ppc64le (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-debuginfo-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.s390x (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-debuginfo-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.x86_64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-debugsource-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.aarch64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-debugsource-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.ppc64le (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-debugsource-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.s390x (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pg_repack-debugsource-0:1.4.6-3.module+el8.9.0+20664+9c30cf7f.x86_64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.aarch64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.ppc64le (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.s390x (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.src (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.x86_64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debuginfo-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.aarch64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debuginfo-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.ppc64le (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debuginfo-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.s390x (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debuginfo-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.x86_64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debugsource-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.aarch64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debugsource-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.ppc64le (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debugsource-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.s390x (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debugsource-0:1.5.0-1.module+el8.9.0+20664+9c30cf7f.x86_64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-0:0.10.0-2.module+el8.9.0+20664+9c30cf7f.aarch64 (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-0:0.10.0-2.module+el8.9.0+20664+9c30cf7f.ppc64le (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-0:0.10.0-2.module+el8.9.0+20664+9c30cf7f.s390x (postgresql:13) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- +108 more not shown
✅ Remediation
For details on how to apply this update, which includes the changes described in this advisory, refer to: https://access.redhat.com/articles/11258 Workaround: Mitigation for this issue is either not available or the currently available options don't meet the Red Hat Product Security criteria comprising ease of use and deployment, applicability to widespread installation base or stability. Workaround: Currently the following options exist to help mitigate the impact of this vulnerability: 1) Restrict Permissions: the creation of PL/Python and PL/Perl functions should be limited to trusted users only. 2) Environment Variable Sanitization: ensure that environment variables are properly sanitized and any modifications are restricted. 3) Upgrade PostgreSQL: if a fix is released by the PostgreSQL Global Development Group, update to the latest version. 4) Audit Database Functions: perform regular audits on user-created functions to detect and prevent potential exploitation.
🔗 References (6)
- selfhttps://access.redhat.com/errata/RHSA-2024:10832
- externalhttps://access.redhat.com/security/updates/classification/#important
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=2326251
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=2326253
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=2326263
- selfhttps://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_10832.json