postgresql_provisioning.sh

# root

sudo apt-get update
sudo apt-get install postgresql postgresql-contrib
sudo -i -u postgres

# postgres

createuser # TODO superuser, with password
echo "host    all    $USERNAME    0.0.0.0/0    md5" >> /etc/postgresql/9.3/main/pg_hba.conf
echo "listen_addresses = '*'" >> /etc/postgresql/9.3/main/postgresql.conf
exit

# back to root

sudo service postgresql restart

sudo ufw allow ssh
sudo ufw allow postgres
sudo ufw enable