-- As postgres user:
CREATE DATABASE <DB_NAME>;
CREATE USER <USERNAME> WITH LOGIN ENCRYPTED PASSWORD '<PASSWORD>';
GRANT ALL PRIVILEGES ON DATABASE <DB_NAME> TO <USERNAME>;