How Do I Grant the REPLICATION Permission to an RDS for PostgreSQL Database User?
- Log in to the database as user root.
- Grant the REPLICATION permission to your account and query the pg_roles table to verify that the permission has been granted.
SELECT * FROM pg_roles;
You can run the commands to grant permissions as user root only when your database kernel version supports root privilege escalation. For details, see Privileges of the root User.