Short version:

sudo -u postgres psql
create database mydb;
create user myuser with encrypted password 'password';
grant all privileges on database mydb to myuser;