CREATE DATABASE sample_db;

CREATE USER sample_user WITH PASSWORD 'password'; GRANT ALL PRIVILEGES ON DATABASE sample_db TO sample_user;

Enter with psql -U sample_user -d sample_db