RDS Postgres Superuser permission

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.

Tópicos

Tags

Idioma

English

feita há um ano1861 visualizações

1 Resposta

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.

ESPECIALISTA

respondido há um ano

Conteúdo relevante