PostgreSQL superuser

• postgres is superuser in PostgreSQL
• rds_superuser is Superuser in AWS RDS PostgreSQL

Examples

To grant rds_superuser to a user user:

GRANT rds_superuser TO "your_username";

Output:
GRANT ROLE 

ALTER USER myuser WITH SUPERUSER;
Error: must be superuser to alter superusers

Related

• CREATE ROLE
• PostgreSQL: Database roles
• root
• DROP DATABASE
• Elasticsearch superuser
• pg_read_all_settings Read all configuration variables, even those normally visible only to superusers.

See also

• CREATE ROLE, Terraform resource: postgresql_role
• PostgreSQL: Database roles, CREATE USER, CREATE ROLE, \du, \du+, create user, Alter user
• PostgreSQL users, predefined roles: pg_read_all_data, pg_monitor, create role, .pgpass, PostgreSQL read only user
• root, /, /root/, /var/root/, admin, administrator, MasterUsername, AdministratorAccess, PostgreSQL superuser, roles/admin