Quick writeup on how to create a new user on postgresql

sudo -u postgres createuser --superuser $USER
sudo -u postgres psql
postgres=# \password $USER