sudo -u postgres psql postgres=# create database mydb; postgres=# create user myuser with encrypted password 'mypass'; postgres=# grant all privileges on database mydb to myuser;
CREATE DATABASE dbname;
CREATE DATABASE [Database to create] WITH TEMPLATE [Database to copy] OWNER [Your username];