MIME-Version: 1.0
References: <CAFS1N4jSe=o=F=ezqD+rDgcndj5o_13S-b-gNWojTnVfaKGdTQ@mail.gmail.com>
In-Reply-To: <CAFS1N4jSe=o=F=ezqD+rDgcndj5o_13S-b-gNWojTnVfaKGdTQ@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Tue, 12 Nov 2024 09:16:54 -0500
Message-ID: <CANzqJaCUdAjjJhaUEhcW4ifJcy0BN=ghJyPYUknrdUY4_8=UUQ@mail.gmail.com>
Subject: Re: PostgreSQL logical replication
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000003021b20626b7df21"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaCUdAjjJhaUEhcW4ifJcy0BN%3DghJyPYUknrdUY4_8%3DUUQ%40mail.gmail.com>
Precedence: bulk

--0000000000003021b20626b7df21
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

The documentation tells you, down in the Notes section.

https://www.postgresql.org/docs/16/sql-createpublication.html

On Tue, Nov 12, 2024 at 5:46=E2=80=AFAM Jayadevan M <maymala.jayadevan@gmai=
l.com>
wrote:

> 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:  permissi=
on
> 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
>
>

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

--0000000000003021b20626b7df21
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">The documentation tells you, down in the Notes section.<di=
v><br><div><a href=3D"https://www.postgresql.org/docs/16/sql-createpublicat=
ion.html">https://www.postgresql.org/docs/16/sql-createpublication.html</a>=
<br></div></div></div><br><div class=3D"gmail_quote"><div dir=3D"ltr" class=
=3D"gmail_attr">On Tue, Nov 12, 2024 at 5:46=E2=80=AFAM Jayadevan M &lt;<a =
href=3D"mailto:maymala.jayadevan@gmail.com">maymala.jayadevan@gmail.com</a>=
&gt; wrote:<br></div><blockquote class=3D"gmail_quote" style=3D"margin:0px =
0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div=
 dir=3D"ltr">Hello all,<div><br><div>I am using=C2=A0PostgreSQL 16.4. I tri=
ed to set up logical replication with &quot;postgres&quot;=C2=A0user and al=
l worked fine.=C2=A0 Then I created a new user (my_replication) to be used =
for the purpose and couldn&#39;t figure out which privileges are necessary.=
 Initially I got an error like &quot;ERROR: =C2=A0permission denied for dat=
abase mydb&quot; . So I used=C2=A0GRANT CREATE ON DATABASE..and that error =
disappeared. I have also executed...</div></div><div>ALTER USER my_replicat=
ion WITH replication;<br>GRANT usage ON SCHEMA public TO my_replication;<br=
>GRANT SELECT ON ALL TABLES IN SCHEMA public TO my_replication;</div><div>W=
hen I try=C2=A0</div><div>=C2=A0CREATE PUBLICATION my_publication for table=
 public.term;</div><div>I am getting an error=C2=A0</div><div>ERROR: =C2=A0=
must be owner of table term</div><div><br></div><div>What privileges should=
 be granted so that I can do=C2=A0</div><div>=C2=A0CREATE PUBLICATION my_pu=
blication FOR TABLES IN SCHEMA public;</div><div><br></div><div>Regards,</d=
iv><div>Jayadevan</div><div><br></div></div>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div=
>Don&#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobs=
ter!</div></div></div></div></div>

--0000000000003021b20626b7df21--