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
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 |