Quick PostgreSQL query to create a username, a database, and than grant all priviledges of the database to the username
Login first: sudo -u postgres psql
then:
CREATE USER username;
CREATE DATABASE dbname;
ALTER USER username WITH ENCRYPTED PASSWORD 'password';
GRANT ALL PRIVILEGES ON DATABASE dbname TO username;