PostgreSQL: role is not permitted to log in
The role you have created is not allowed to log in. You have to give the role permission to log in.
One way to do this is to log in as the postgres user and update the role:
psql -U postgresOnce you are logged in, type:
ALTER ROLE "asunotest" WITH LOGIN;Here's the documentation http://www.postgresql.org/docs/9.0/static/sql-alterrole.html
CREATE ROLE blog WITH LOGIN SUPERUSER INHERIT CREATEDB CREATEROLE REPLICATION;COMMENT ON ROLE blog IS 'Test';
Using pgadmin4 :
- Select roles in side menu
- Select properties in dashboard.
- Click Edit and select privileges
Now there you can enable or disable login, roles and other options