Re: Additional info for CREATE ROLE with REPLICATION

> On Nov 26, 2025, at 05:45, Marcos Pegoraro <marcos(at)f10(dot)com(dot)br> wrote:
>
> When a logical replication is created and a ROLE with REPLICATION clause is used for that, there is no info on [0] that that role needs to have read permission on those tables. CREATE PUBLICATION and CREATE SUBSCRIPTION commands works as expected but replication doesn't work, only a "access denied" is added on logs.
>
> So it would be good to explain that a GRANT is needed.
>
> [0] - https://www.postgresql.org/docs/current/sql-createrole.html
>
> regards
> Marcos
>
> <0001-Master - Additional info for create role with REPLICATION.diff>

Hi Marcos,

The statement you added is correct, however I don’t think it is the right place to add the statement, “create role” just describes how to assign the replication attribute.

On I found that in logical-replication.html, there is an explanation already:
```
<para>
In order to be able to copy the initial table or sequence data, the role
used for the replication connection must have the <literal>SELECT</literal>
privilege on a published table or sequence (or be a superuser).
</para>
```

Best regards,
--
Chao Li (Evan)
HighGo Software Co., Ltd.
https://www.highgo.com/