public inbox for [email protected]help / color / mirror / Atom feed
pgsql: Add hints for sequence synchronization permission warnings 2+ messages / 1 participants [nested] [flat]
* pgsql: Add hints for sequence synchronization permission warnings @ 2026-07-08 09:17 Fujii Masao <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Fujii Masao @ 2026-07-08 09:17 UTC (permalink / raw) To: [email protected] Add hints for sequence synchronization permission warnings Sequence synchronization reports insufficient privileges on publisher and subscriber sequences, but the warnings do not indicate which role needs which privilege. This makes common configuration mistakes harder to diagnose. Add HINT messages for these warnings. Publisher-side warnings suggest granting SELECT to the role used for the replication connection. Subscriber-side warnings suggest granting UPDATE to the subscription owner when run_as_owner is enabled. Otherwise, the worker runs as the sequence owner, so no useful GRANT hint can be provided. Suggested-by : Amit Kapila <[email protected]> Author: Fujii Masao <[email protected]> Reviewed-by: Amit Kapila <[email protected]> Reviewed-by: Bharath Rupireddy <[email protected]> Discussion: https://postgr.es/m/CAA4eK1JOo0aJRhFHNWpj3hMwaTtNOopY34f1Lh_QD=z=+DrzWQ@mail.gmail.com Backpatch-through: 19 Branch ------ master Details ------- https://git.postgresql.org/pg/commitdiff/3601f976c2e99123203413fd157f117632b3db78 Modified Files -------------- doc/src/sgml/logical-replication.sgml | 14 +++++++++++--- src/backend/replication/logical/sequencesync.c | 23 +++++++++++++++++++++-- 2 files changed, 32 insertions(+), 5 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
* pgsql: Add hints for sequence synchronization permission warnings @ 2026-07-08 09:17 Fujii Masao <[email protected]> 0 siblings, 0 replies; 2+ messages in thread From: Fujii Masao @ 2026-07-08 09:17 UTC (permalink / raw) To: [email protected] Add hints for sequence synchronization permission warnings Sequence synchronization reports insufficient privileges on publisher and subscriber sequences, but the warnings do not indicate which role needs which privilege. This makes common configuration mistakes harder to diagnose. Add HINT messages for these warnings. Publisher-side warnings suggest granting SELECT to the role used for the replication connection. Subscriber-side warnings suggest granting UPDATE to the subscription owner when run_as_owner is enabled. Otherwise, the worker runs as the sequence owner, so no useful GRANT hint can be provided. Suggested-by : Amit Kapila <[email protected]> Author: Fujii Masao <[email protected]> Reviewed-by: Amit Kapila <[email protected]> Reviewed-by: Bharath Rupireddy <[email protected]> Discussion: https://postgr.es/m/CAA4eK1JOo0aJRhFHNWpj3hMwaTtNOopY34f1Lh_QD=z=+DrzWQ@mail.gmail.com Backpatch-through: 19 Branch ------ REL_19_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/165dc09b28619510d9ab0034fdfccfb7af5422ae Modified Files -------------- doc/src/sgml/logical-replication.sgml | 14 +++++++++++--- src/backend/replication/logical/sequencesync.c | 23 +++++++++++++++++++++-- 2 files changed, 32 insertions(+), 5 deletions(-) ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-07-08 09:17 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2026-07-08 09:17 pgsql: Add hints for sequence synchronization permission warnings Fujii Masao <[email protected]> 2026-07-08 09:17 pgsql: Add hints for sequence synchronization permission warnings Fujii Masao <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox