setup/doc/postgres.md

Setup Postgres

• install Postgres like this

• create copy of config file pg_hba.conf file
  NOTE: Insert the postgresql version that is running on the respective host

cd /etc/postgresql/<psql version>/main/
sudo cp pg_hba.conf pg_hba.conf-bckp

• switch authentication method from peer to md5 for all local users connecting by Unix domain sockets by opening the following config file and adding the example configuration

sudo vi pg_hba.conf

# "local" is for Unix domain socket connections only
#local   all             all                                     peer
local   all             all                                     md5

• restart PostgreSQL to enable the changes

systemctl status postgresql
sudo systemctl restart postgresql
systemctl status postgresql

• OPTION: allow remote connections like this

• OPTION: disable start up at system boot like this