Red Hat Security Advisory: postgresql:12 security update
🔗 CVE IDs covered (6)
📋 Description
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 CVE-2020-25694 — postgresql: Reconnection can downgrade connection security settings CVE-2020-25695 — postgresql: Multiple features escape "security restricted operation" sandbox CVE-2020-25696 — postgresql: psql's \gset allows overwriting specially treated variables
🎯 Affected products125
- Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.4.0-4.module+el8.3.0+9042+664538f4.aarch64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.4.0-4.module+el8.3.0+9042+664538f4.ppc64le (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.4.0-4.module+el8.3.0+9042+664538f4.s390x (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.4.0-4.module+el8.3.0+9042+664538f4.src (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-0:1.4.0-4.module+el8.3.0+9042+664538f4.x86_64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debuginfo-0:1.4.0-4.module+el8.3.0+9042+664538f4.aarch64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debuginfo-0:1.4.0-4.module+el8.3.0+9042+664538f4.ppc64le (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debuginfo-0:1.4.0-4.module+el8.3.0+9042+664538f4.s390x (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debuginfo-0:1.4.0-4.module+el8.3.0+9042+664538f4.x86_64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debugsource-0:1.4.0-4.module+el8.3.0+9042+664538f4.aarch64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debugsource-0:1.4.0-4.module+el8.3.0+9042+664538f4.ppc64le (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debugsource-0:1.4.0-4.module+el8.3.0+9042+664538f4.s390x (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- pgaudit-debugsource-0:1.4.0-4.module+el8.3.0+9042+664538f4.x86_64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-0:0.10.0-2.module+el8.3.0+9042+664538f4.aarch64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-0:0.10.0-2.module+el8.3.0+9042+664538f4.ppc64le (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-0:0.10.0-2.module+el8.3.0+9042+664538f4.s390x (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-0:0.10.0-2.module+el8.3.0+9042+664538f4.src (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-0:0.10.0-2.module+el8.3.0+9042+664538f4.x86_64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-debuginfo-0:0.10.0-2.module+el8.3.0+9042+664538f4.aarch64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-debuginfo-0:0.10.0-2.module+el8.3.0+9042+664538f4.ppc64le (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-debuginfo-0:0.10.0-2.module+el8.3.0+9042+664538f4.s390x (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-debuginfo-0:0.10.0-2.module+el8.3.0+9042+664538f4.x86_64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-debugsource-0:0.10.0-2.module+el8.3.0+9042+664538f4.aarch64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-debugsource-0:0.10.0-2.module+el8.3.0+9042+664538f4.ppc64le (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-debugsource-0:0.10.0-2.module+el8.3.0+9042+664538f4.s390x (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgres-decoderbufs-debugsource-0:0.10.0-2.module+el8.3.0+9042+664538f4.x86_64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-0:12.5-1.module+el8.3.0+9042+664538f4.aarch64 (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-0:12.5-1.module+el8.3.0+9042+664538f4.ppc64le (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- postgresql-0:12.5-1.module+el8.3.0+9042+664538f4.s390x (postgresql:12) as a component of Red Hat Enterprise Linux AppStream (v. 8)
- +95 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: 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. Workaround: Using \gset with a prefix not found among specially treated variables, e.g. any lowercase string, precludes the attack in an unpatched psql.
🔗 References (13)
- selfhttps://access.redhat.com/errata/RHSA-2020:5620
- externalhttps://access.redhat.com/security/updates/classification/#important
- externalhttps://www.postgresql.org/docs/12/release-12-2.html
- externalhttps://www.postgresql.org/docs/12/release-12-3.html
- externalhttps://www.postgresql.org/docs/12/release-12-4.html
- externalhttps://www.postgresql.org/docs/12/release-12-5.html
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1798852
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1865744
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1865746
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1894423
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1894425
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=1894430
- selfhttps://security.access.redhat.com/data/csaf/v2/advisories/2020/rhsa-2020_5620.json