C

create role in psql with password

postgres=#CREATE ROLE demorole1 WITH LOGIN ENCRYPTED PASSWORD 'password1';

postgresql Create a new role with a username and password

CREATE ROLE username NOINHERIT LOGIN PASSWORD password;

create role in psql with password

# sudo su - postgres

create role postgres

CREATE ROLE <name> WITH <list of permissions>;