I created a superuser portal with the following command
create role portal with superuser password 'portal'
When I tried to login into postgres with portal user I am getting the following error in rails.
FATAL: role "portal" is not permitted to log in
I can't follow what is going on.
of course I can alter user with login command to enable portal user to login. I would like to understand why super user can't login.
role
can never log in. You should have usedcreate user
if you want something that can log in.CREATE ROLE
andCREATE USER
, see Craig's answer.