setup/doc/postgres-connect-remote.md

Allow Remote Connections

• configure ports and update firewall using the firewall setup

sudo ufw allow 5432
//OPTION: sudo ufw allow 5432
sudo ufw enable
sudo ufw status numbered

• create config backup

sudo cp /etc/postgresql/<version>/main/postgresql.conf /etc/postgresql/<version>/main/postgresql.conf-backup

• open config file to define what IP addresses postgres to listen on

sudo vi /etc/postgresql/<version>/main/postgresql.conf

• edit config file like this

#listen_addresses = 'localhost'
listen_addresses = '*'

• open config file to define access to all databases for all users with an encrypted key

sudo vi /etc/postgresql/<version>/main/pg_hba.conf

• edit config file like this

# TYPE  DATABASE	USER	ADDRESS   	METHOD
host    all     	all     0.0.0.0/0       md5
host    all             all     :/0             md5

• restart PostgreSQL to enable the changes

sudo systemctl restart postgresql
systemctl status postgresql