Help Center/ Relational Database Service/ FAQs/ Database Permission/ How Do I Grant the REPLICATION Permission to an RDS for PostgreSQL Database User?
Updated on 2022-05-07 GMT+08:00
View PDF
Share

How Do I Grant the REPLICATION Permission to an RDS for PostgreSQL Database User?

  1. Log in to the database as user root.
  2. Grant the REPLICATION permission to your account and query the pg_roles table to verify that the permission has been granted.

    ALTER USER <user> REPLICATION;

    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.

Parent topic: Database Permission