Create a user in a PostgreSQL Database

# su - postgres
# psql

CREATE USER username WITH PASSWORD 'password' CREATEDB CREATEUSER;