3 Answers
- Newest
- Most votes
- Most comments
0
You may grant REPLICATION privilege by below command:
GRANT rds_replication TO rdsadmin;
Verify by:
SELECT rolname, rolreplication
FROM pg_roles
WHERE rolname = 'rdsadmin';
answered 2 days ago
0
You need to get access with to the DB with a user that have the ability to grant you that privilege. If you have access to manage the DB, use the console or CLI to change rdsadmin password, and than connect to the database as rdsadmin and grant the new user the needed privilege. If you don't have access work with the person that have access to grant you access.
answered 2 days ago
0
Hi,
Why do you need REPLICATION privileges and rds_replication is not enough? In RDS if you want to use logical replication you can just grant the rds_replication role to your user as rds_superuser.
answered 10 hours ago
Relevant content
- asked 2 years ago
- asked 2 years ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
Hello Kidd, thank you for your response. But I am trying to add REPLICATION to a new user I've created that is not "rdsadmin". Here is an example of how I created the new user:
The issue is that we do not have the password for "rdsadmin". We are logging in as an elevated user, but it lacks superuser privileges.