These are the steps to creating a new database with it’s own admin user for PostgreSQL.

# On the postgres server
psql -U postgres # log into postgres

create role newdbadmin with login password 'pa$$word';                                                                          

create database newdb;

grant all privileges on database newdb to newdbadmin;