# Postgres Setup on WSL

1. Download Postgres: `sudo apt install postgresql`.
1. NOTE: Restart your terminal if you already have it open. And if you're using the terminal in VSCode, you'll have to restart VSCode to have it pick up the changes to the PATH variable.
1. Run `$ psql -U postgres` in command prompt. This runs the psql command as the default "postgres" superuser.
1. Run: `postgres=# CREATE USER "[WINDOWS_USERNAME]" WITH PASSWORD '[PASSWORD]' SUPERUSER;`
1. Quit postgres: `postgres=# \q`
1. Run `psql postgres` and type the password you used in the `CREATE USER` command

Starting/Stopping/Restarting postgres: https://stackoverflow.com/a/53062239

If you get tired of typing your password in everytime you run `psql`, try one of these options: https://dba.stackexchange.com/questions/14740/how-to-use-psql-with-no-password-prompt.

https://learn.microsoft.com/en-us/windows/wsl/tutorials/wsl-database#install-postgresql