Amazon RDS PostgreSQL: how to create user?

Question

I have created 3 databases in one RDS DB instance. The owner of these databases is user Postgres. I'd like to create a new power user. When I am trying to create it I receive: "User 'Postgres' has no privileges to edit users" But it is the one user which I can use. How I can create the new user?

Answer 1

Use CREATE ROLE and to the new user assign rds_superuser role. Check out this documentation.

These are the instructions:

postgres=> create role testuser with password 'testuser' login;   

CREATE ROLE   

postgres=> grant rds_superuser to testuser;   

GRANT ROLE   

postgres=>