PostgreSQL create user

postgresql-create-user.md

PostgreSQL - create user

Login first using the superuser account:

psql -h 127.0.0.1 -p 54320 -U postgres -W

Create your dev user:

CREATE USER shanks WITH PASSWORD 'password' SUPERUSER;

Bonus: create a database

CREATE DATABASE redhair;

Connect after creating a database:

psql -h 127.0.0.1 -p 54320 -U shanks -W -d redhair