RDS Postgres Superuser permission

0

Couldnt execute this query without superuser permission ALTER ROLE user WITH REPLICATION;

Im running a postgres db even I have enabled RDS_SUPERUSER role to that user.

1 Answer
1

Hi,

According to https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html does not seem that you can use the WITH replication syntax for rds super users.

You will need to grant replication to an user:

CREATE ROLE <user>; GRANT rds_replication TO <user>;

Hope it helps.

profile picture
EXPERT
answered a year ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions