pgsql: Empty search_path in logical replication apply worker and walsen - Mailing list pgsql-committers

From Noah Misch
Subject pgsql: Empty search_path in logical replication apply worker and walsen
Date
Msg-id E1k5AbJ-0004tH-87@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Empty search_path in logical replication apply worker and walsender.

This is like CVE-2018-1058 commit
582edc369cdbd348d68441fc50fa26a84afd0c1a.  Today, a malicious user of a
publisher or subscriber database can invoke arbitrary SQL functions
under an identity running replication, often a superuser.  This fix may
cause "does not exist" or "no schema has been selected to create in"
errors in a replication process.  After upgrading, consider watching
server logs for these errors.  Objects accruing schema qualification in
the wake of the earlier commit are unlikely to need further correction.
Back-patch to v10, which introduced logical replication.

Security: CVE-2020-14349

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/412c5c4010c0bec294f60a10cd56929680d3f95b

Modified Files
--------------
.../replication/libpqwalreceiver/libpqwalreceiver.c     | 17 +++++++++++++++++
src/backend/replication/logical/worker.c                |  6 ++++++
src/test/subscription/t/001_rep_changes.pl              |  4 ++++
3 files changed, 27 insertions(+)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Make contrib modules' installation scripts more secure.
Next
From: Tom Lane
Date:
Subject: pgsql: Last-minute updates for release notes.