Help Center > > FAQs> Database Permission> How Do I Grant the REPLICATION Permission to an RDS for PostgreSQL Database User?

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

Updated at: Jun 09, 2021 GMT+08:00
  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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel