Create PostgreSQL user - without trial and error.

create_postgresql_user.txt

- Go to the postgres user
$ sudo su postgres

- Execute create user
$ createuser --interactive <user>

- Change it's password inside postgres
$ psql
$ ALTER USER <user> WITH PASSWORD '<password>';

- Done, try connecting with prisma. Don't forget to encode the password in case of any special characters.

I do this once every 6 months and every time need to trial-and-error through multiple tutorials. :(