Postgres on Linux
PostgreSQL is a powerful relational database. Relational databases offer a wealth of performance advantages over file-based data storage.
Start and Stop Server
The following commands can be used to start and stop the Postgres server, and check the status of the server.
sudo service postgresql start sudo service postgresql stop sudo service postgresql restart sudo service postgresql status
Installation on WSL
Microsoft offers a detailed guide for installing Postgres on WSL. In addition to the steps listed on the Microsoft website, I found it necessary to complete the following steps.
The authentication config file is located at
/etc/postgresql/10/main/pg_hba.conf, or a similar location. Change the authentication method from
trust. Specifically, I changed these two lines
local all postgres peer local all all peer
local all postgres trust local all all trust
Reload, and restart the server for the changes to take effect.
sudo /etc/init.d/postgresql reload sudo service postgresql restart