PostgreSQL logical replication

From: Jayadevan M <maymala(dot)jayadevan(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL logical replication
Date: 2024-11-12 10:46:21
Message-ID: CAFS1N4jSe=o=F=ezqD+rDgcndj5o_13S-b-gNWojTnVfaKGdTQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello all,

I am using PostgreSQL 16.4. I tried to set up logical replication with
"postgres" user and all worked fine. Then I created a new user
(my_replication) to be used for the purpose and couldn't figure out which
privileges are necessary. Initially I got an error like "ERROR: permission
denied for database mydb" . So I used GRANT CREATE ON DATABASE..and that
error disappeared. I have also executed...
ALTER USER my_replication WITH replication;
GRANT usage ON SCHEMA public TO my_replication;
GRANT SELECT ON ALL TABLES IN SCHEMA public TO my_replication;
When I try
CREATE PUBLICATION my_publication for table public.term;
I am getting an error
ERROR: must be owner of table term

What privileges should be granted so that I can do
CREATE PUBLICATION my_publication FOR TABLES IN SCHEMA public;

Regards,
Jayadevan

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Vanns 2024-11-12 12:43:26 BitmapOr node not used in plan for ANY/IN but is for sequence of ORs ...
Previous Message Laurenz Albe 2024-11-12 08:48:31 Re: create policy statement USING clause