Login to Postgre
sudo -u postgres psql
Create Database
postgres=# create database mydb;
Create User
postgres=# create user myuser with encrypted password 'password';
Grant Privileges to User
postgres=# GRANT ALL PRIVILEGES ON DATABASE "mydb" to myuser;