How did you create that role?
What was the exact CREATE ROLE command you used?
My guess is, that you simply forgot to grant the login privilege to the role
ALTER ROLE carlos WITH login
should fix this
I just pulled this out of the history file:
CREATE ROLE carlos WITH superuser;
So you mean to tell me that if I configure a new user / role with the 'SUPERUSER' option, I still have to also tell him I need 'login' privileges as well. Seems a little redundant, no? Am I missing something here because it's not making sense to me...
A role having the LOGIN attribute can be thought of as a user. Roles without this attribute are useful for managing database privileges, but are not users in the usual sense of the word. If not specified, NOLOGIN is the default, except when CREATE ROLE is invoked through its alternative spelling CREATE USER]