Red Hat Security Advisory: postgresql security update
🔗 CVE IDs covered (3)
📋 Description
CVE-2019-10208 — postgresql: TYPE in pg_temp executes arbitrary SQL during SECURITY DEFINER execution CVE-2020-25694 — postgresql: Reconnection can downgrade connection security settings CVE-2020-25695 — postgresql: Multiple features escape "security restricted operation" sandbox
🎯 Affected products139
- Red Hat Enterprise Linux Client (v. 7)
- Red Hat Enterprise Linux Client Optional (v. 7)
- Red Hat Enterprise Linux ComputeNode Optional (v. 7)
- Red Hat Enterprise Linux Server (v. 7)
- Red Hat Enterprise Linux Server Optional (v. 7)
- Red Hat Enterprise Linux Workstation (v. 7)
- Red Hat Enterprise Linux Workstation Optional (v. 7)
- postgresql-0:9.2.24-6.el7_9.i686 as a component of Red Hat Enterprise Linux Client Optional (v. 7)
- postgresql-0:9.2.24-6.el7_9.i686 as a component of Red Hat Enterprise Linux ComputeNode Optional (v. 7)
- postgresql-0:9.2.24-6.el7_9.i686 as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-0:9.2.24-6.el7_9.i686 as a component of Red Hat Enterprise Linux Workstation (v. 7)
- postgresql-0:9.2.24-6.el7_9.ppc as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-0:9.2.24-6.el7_9.ppc64 as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-0:9.2.24-6.el7_9.ppc64le as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-0:9.2.24-6.el7_9.s390 as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-0:9.2.24-6.el7_9.s390x as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-0:9.2.24-6.el7_9.src as a component of Red Hat Enterprise Linux Client (v. 7)
- postgresql-0:9.2.24-6.el7_9.src as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-0:9.2.24-6.el7_9.src as a component of Red Hat Enterprise Linux Workstation (v. 7)
- postgresql-0:9.2.24-6.el7_9.x86_64 as a component of Red Hat Enterprise Linux Client Optional (v. 7)
- postgresql-0:9.2.24-6.el7_9.x86_64 as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-0:9.2.24-6.el7_9.x86_64 as a component of Red Hat Enterprise Linux Workstation (v. 7)
- postgresql-contrib-0:9.2.24-6.el7_9.ppc64 as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-contrib-0:9.2.24-6.el7_9.ppc64le as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-contrib-0:9.2.24-6.el7_9.s390x as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-contrib-0:9.2.24-6.el7_9.x86_64 as a component of Red Hat Enterprise Linux Client Optional (v. 7)
- postgresql-contrib-0:9.2.24-6.el7_9.x86_64 as a component of Red Hat Enterprise Linux ComputeNode Optional (v. 7)
- postgresql-contrib-0:9.2.24-6.el7_9.x86_64 as a component of Red Hat Enterprise Linux Server (v. 7)
- postgresql-contrib-0:9.2.24-6.el7_9.x86_64 as a component of Red Hat Enterprise Linux Workstation (v. 7)
- postgresql-debuginfo-0:9.2.24-6.el7_9.i686 as a component of Red Hat Enterprise Linux Client (v. 7)
- +109 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 If the postgresql service is running, it will be automatically restarted after installing this update. Workaround: If your use case requires SECURITY DEFINER functions, please follow the advice below to write them safely so they do not rely on search_path and restrict the set of users which can access them. https://www.postgresql.org/docs/devel/sql-createfunction.html#SQL-CREATEFUNCTION-SECURITY Workaround: While promptly updating PostgreSQL is the best remediation for most users, a user unable to do that can work around the vulnerability by disabling autovacuum and not manually running ANALYZE, CLUSTER, REINDEX, CREATE INDEX, VACUUM FULL, REFRESH MATERIALIZED VIEW, or a restore from output of the pg_dump command. Performance may degrade quickly under this workaround.
🔗 References (6)
- selfhttps://access.redhat.com/errata/RHSA-2021:1512
- externalhttps://access.redhat.com/security/updates/classification/#important
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1734416
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1894423
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1894425
- selfhttps://security.access.redhat.com/data/csaf/v2/advisories/2021/rhsa-2021_1512.json