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 年前檢視次數 1861 次
1 個回答
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
專家
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南