Procedure:Set up PostgreSQL database

Must create new role as user postgres:

 su postgres
 createuser newuser

Then create database as new role:

 su newuser
 createdb testdb

Note - here it is assumed that the role will take on the same username as the OS username.