Red Hat Security Advisory: postgresql security update
🔗 CVE IDs covered (1)
📋 Description
CVE-2024-10979 — postgresql: PostgreSQL PL/Perl environment variable changes execute arbitrary code
🎯 Affected products77
- Red Hat Enterprise Linux Server (v. 7 ELS)
- Red Hat Enterprise Linux Server Optional (v. 7 ELS)
- postgresql-0:9.2.24-9.el7_9.2.i686 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-0:9.2.24-9.el7_9.2.ppc as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-0:9.2.24-9.el7_9.2.ppc64 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-0:9.2.24-9.el7_9.2.ppc64le as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-0:9.2.24-9.el7_9.2.s390 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-0:9.2.24-9.el7_9.2.s390x as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-0:9.2.24-9.el7_9.2.src as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-0:9.2.24-9.el7_9.2.x86_64 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-contrib-0:9.2.24-9.el7_9.2.ppc64 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-contrib-0:9.2.24-9.el7_9.2.ppc64le as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-contrib-0:9.2.24-9.el7_9.2.s390x as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-contrib-0:9.2.24-9.el7_9.2.x86_64 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.i686 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.i686 as a component of Red Hat Enterprise Linux Server Optional (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.ppc as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.ppc as a component of Red Hat Enterprise Linux Server Optional (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.ppc64 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.ppc64 as a component of Red Hat Enterprise Linux Server Optional (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.ppc64le as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.ppc64le as a component of Red Hat Enterprise Linux Server Optional (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.s390 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.s390 as a component of Red Hat Enterprise Linux Server Optional (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.s390x as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.s390x as a component of Red Hat Enterprise Linux Server Optional (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.x86_64 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-debuginfo-0:9.2.24-9.el7_9.2.x86_64 as a component of Red Hat Enterprise Linux Server Optional (v. 7 ELS)
- postgresql-devel-0:9.2.24-9.el7_9.2.i686 as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- postgresql-devel-0:9.2.24-9.el7_9.2.ppc as a component of Red Hat Enterprise Linux Server (v. 7 ELS)
- +47 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: 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.