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
Description: Binary data
