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 the 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?

Neil Anderson · Accepted Answer · 2018-08-25 02:05:28Z

36

It looks like you need to use CREATE ROLE and assign the rds_superuser role to the new user. It's documented here http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.PostgreSQL.CommonDBATasks.html#Appendix.PostgreSQL.CommonDBATasks.Roles

and I'll paste the instructions too:

postgres=> create role testuser with password 'testuser' login;   
CREATE ROLE   
postgres=> grant rds_superuser to testuser;   
GRANT ROLE   
postgres=>

edited Aug 25, 2018 at 2:05

answered Nov 12, 2017 at 15:41

Neil Anderson

1,39512 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Rafaf Tahsin Over a year ago

grant rds_superuser to testuser; doesn't seem to work

Rafa Viotti Nov 27, 2024 at 17:47

Both commands do work on RDS Aurora PostgreSQL 16.1.

Anand Tripathi Dec 23, 2024 at 15:58

This is what I was looking for

Collectives™ on Stack Overflow

Amazon RDS PostgreSQL: how to create user?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related