RE: pg_replication_origin_session_setup and superuser

2021-02-16 Thread Zohar Gofer
: pg_replication_origin_session_setup and superuser On Mon, Feb 15, 2021 at 09:37:53AM +, Zohar Gofer wrote: > In my mind the requirement for superuser is too strong. I think that > requiring privileges of a replication user is more suitable. This way > we can require that only a user with replication privil

Re: pg_replication_origin_session_setup and superuser

2021-02-16 Thread Michael Paquier
On Tue, Feb 16, 2021 at 07:54:32AM +, Zohar Gofer wrote: > Thanks. This seems to be the fix we need. > Would it be possible to push it to previous versions? 12 or 13? New features don't go into stable branches, only bug fixes do. And this is not a bug fix, but a feature. -- Michael signatur

Re: pg_replication_origin_session_setup and superuser

2021-02-15 Thread Michael Paquier
On Mon, Feb 15, 2021 at 09:37:53AM +, Zohar Gofer wrote: > In my mind the requirement for superuser is too strong. I think that > requiring privileges of a replication user is more suitable. This > way we can require that only a user with replication privileges will > actually do replication, e

pg_replication_origin_session_setup and superuser

2021-02-15 Thread Zohar Gofer
Hi, Problem description: While working on a homegrown limited solution to replace (a very limited set of) golden gate capabilities we have created a CDC solution using the WAL capabilities. The data flows like this: PG1 --> Debezium(wal2json) --> Kafka1 --> MM2 --> Kafka2 --> Kafka Connect Sink