Expose local postgres database over https
sudo apt-get update
sudo apt-get install postgresql postgresql-contrib
su - postgres
psql
createuser --interactive --pwprompt
createdb -O cleopatra egypt
//on root user
nano /etc/postgresql/10/main/postgresql.conf
listen_addresses = '*'
nano /etc/postgresql/10/main/pg_hba.conf
host all all 0.0.0.0/0 md5
sudo ufw allow 5432/tcp
sudo systemctl restart postgresql