Postgres cheatsheet
As postgres User:
sudo su - postgres
Create new user
createuser <username>
Create database
createdb <dbname>