Additional info for CREATE ROLE with REPLICATION
Marcos Pegoraro <marcos@f10.com.br>
From: Marcos Pegoraro <marcos@f10.com.br>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-11-25T21:45:59Z
Lists: pgsql-hackers
Attachments
- 0001-Master - Additional info for create role with REPLICATION.diff (application/octet-stream)
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