Setting up local postgresql database server for WSL/Ubuntu

The offical Ubuntu guide can be a little confusing.

Here are the correct steps in order to set up a local postgresql database server.

1. sudo apt install postgresql
2. sudo service postgresql start
3. sudo su - postgres
4. createuser --superuser $USER where $USER is your username
5. psql
6. \password $USER is typed into the psql console to set up your account.
7. \q to exit
8. createdb $USER by convention
9. exit and now you can run psql in your own console with your username.