postgresql cheatsheet

[dum3ng]

After install, use:

sudo -u postgres psql postgres

to login.

create new user as superuser

In the postgresql repl:

create user new_user;
alter user new_user with superuser;