Thread

Additional info for CREATE ROLE with REPLICATION

Marcos Pegoraro <marcos@f10.com.br> — 2025-11-25T21:45:59Z

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