SHELL

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