Horton

Fixups for commit 93db6cbda0.

Amit Kapila <akapila@postgresql.org>

View on postgr.es
Commit: b3f6b14cf48ffa81084072f1fdeee2fe9df20746
Author: Amit Kapila <akapila@postgresql.org>
Date: 2024-02-29T04:15:20Z
Releases: 17.0 
Fixups for commit 93db6cbda0.

Ensure to set always-secure search path for both local and remote
connections during slot synchronization, so that malicious users can't
redirect user code (e.g. operators).

In the passing, improve the name of define, remove spurious return
statement, and a minor change in one of the comments.

Author: Bertrand Drouvot and Shveta Malik
Reviewed-by: Amit Kapila, Peter Smith
Discussion: https://postgr.es/m/514f6f2f-6833-4539-39f1-96cd1e011f23@enterprisedb.com
Discussion: https://postgr.es/m/ZdcejBDCr+wlVGnO@ip-10-97-1-34.eu-west-3.compute.internal
Discussion: https://postgr.es/m/CAJpy0uBNP=nrkNJkJSfF=jSocEh8vU2Owa8Rtpi=63fG=SvfVQ@mail.gmail.com

Files

PathChange+/−
src/backend/access/transam/xlogrecovery.c modified +8 −7
src/backend/replication/libpqwalreceiver/libpqwalreceiver.c modified +5 −1
src/backend/replication/logical/slotsync.c modified +15 −8
src/test/recovery/t/040_standby_failover_slots_sync.pl modified +54 −0

Discussion