postgresql create role
CREATE ROLE role_name with NOSUPERUSER NOINHERIT NOCREATEROLE NOCREATEDB LOGIN NOREPLICATION NOBYPASSRLS;
create role in psql with password
# sudo su - postgres
Source: docs.rackspace.com
postgresql create user roles
CREATE ROLE admin WITH CREATEDB CREATEROLE;
Source: www.postgresql.org
create role postgres
CREATE ROLE <name> WITH <list of permissions>;