CREATE ROLE dba NOLOGIN SUPERUSER CREATEDB CREATEROLE REPLICATION;
Then I add my role 'carlos' to the 'dba' role:
GRANT dba TO carlos;
So doesn't that mean that 'carlos' is now a superuser? When I logged in as carlos and tried to do something in pgAdmin, I got an error saying I wasn't a superuser. Am I missing something? Not sure if my user role 'carlos' or group role 'dba' is missing some kind of INHERIT which would make all roles granted to 'dba' a superuser.