Red Hat Security Advisory: postgresql:10 security and bug fix update
🔗 CVE IDs covered (6)
📋 Description
CVE-2019-10130 — postgresql: Selectivity estimators bypass row security policies CVE-2019-10164 — postgresql: Stack-based buffer overflow via setting a password CVE-2019-10208 — postgresql: TYPE in pg_temp executes arbitrary SQL during SECURITY DEFINER execution CVE-2020-1720 — postgresql: ALTER ... DEPENDS ON EXTENSION is missing authorization checks CVE-2020-14349 — postgresql: Uncontrolled search path element in logical replication CVE-2020-14350 — postgresql: Uncontrolled search path element in CREATE EXTENSION
🎯 Affected products102
- Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-0:10.14-1.module+el8.2.0+7801+be0fed80.aarch64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-0:10.14-1.module+el8.2.0+7801+be0fed80.ppc64le (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-0:10.14-1.module+el8.2.0+7801+be0fed80.s390x (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-0:10.14-1.module+el8.2.0+7801+be0fed80.src (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-0:10.14-1.module+el8.2.0+7801+be0fed80.x86_64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-contrib-0:10.14-1.module+el8.2.0+7801+be0fed80.aarch64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-contrib-0:10.14-1.module+el8.2.0+7801+be0fed80.ppc64le (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-contrib-0:10.14-1.module+el8.2.0+7801+be0fed80.s390x (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-contrib-0:10.14-1.module+el8.2.0+7801+be0fed80.x86_64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-contrib-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.aarch64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-contrib-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.ppc64le (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-contrib-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.s390x (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-contrib-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.x86_64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.aarch64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.ppc64le (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.s390x (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.x86_64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-debugsource-0:10.14-1.module+el8.2.0+7801+be0fed80.aarch64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-debugsource-0:10.14-1.module+el8.2.0+7801+be0fed80.ppc64le (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-debugsource-0:10.14-1.module+el8.2.0+7801+be0fed80.s390x (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-debugsource-0:10.14-1.module+el8.2.0+7801+be0fed80.x86_64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-docs-0:10.14-1.module+el8.2.0+7801+be0fed80.aarch64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-docs-0:10.14-1.module+el8.2.0+7801+be0fed80.ppc64le (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-docs-0:10.14-1.module+el8.2.0+7801+be0fed80.s390x (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-docs-0:10.14-1.module+el8.2.0+7801+be0fed80.x86_64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-docs-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.aarch64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-docs-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.ppc64le (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-docs-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.s390x (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-docs-debuginfo-0:10.14-1.module+el8.2.0+7801+be0fed80.x86_64 (postgresql:10) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- +72 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
🔗 References (10)
- selfhttps://access.redhat.com/errata/RHSA-2020:3669
- externalhttps://access.redhat.com/security/updates/classification/#moderate
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1707109
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1719698
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1734416
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1798852
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1857228
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1865744
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1865746
- selfhttps://security.access.redhat.com/data/csaf/v2/advisories/2020/rhsa-2020_3669.json