sudo -u postgres -i
psql -d postgres
createuser -U postgres -s YOURUSERNAME
createdb YOURUSERNAME
template1=# CREATE USER username WITH PASSWORD 'user_password';
template1=# GRANT ALL PRIVILEGES ON DATABASE "user_database" to username;
sudo -u postgres createrUser Username