On Wed, 15 Jul 2026 at 17:23, Amit Kapila <[email protected]> wrote: > > So, I prefer the GUC approach and we are > already overriding it for session_replication_role and search_path > GUC's. The one minor difference could be that for PG19, we set it only > for sequencesync worker and in HEAD for all workers.
Here is a patch to handle the same. v4-0001 patch has the changes to set default_transaction_read_only guc in InitializeLogRepWorker which is common to logical replication workers in master branch and v4_PG19 patch has the changes to set default_transaction_read_only guc in SequenceSyncWorkerMain which is only for sequence sync worker. Regards, Vignesh
v4_PG19-0001-Ignore-default_transaction_read_only-in-sequence-.patch
Description: Binary data
v4-0001-Allow-logical-replication-workers-to-ignore-defau.patch
Description: Binary data
