cd `dirname $0`

# set PGUSER and PGPASS 
source ./env.sh

echo " install postgres "

# please do not restart postgres at random times
sudo apt-get remove -y unattended-upgrades

sudo apt-get install -y postgresql
sudo apt-get install -y postgresql-contrib

# this hack will probably get us the version number...
PGVER=`ls /etc/postgresql/`

sudo pg_dropcluster --stop $PGVER main
sudo pg_createcluster --locale en_US.UTF-8 --start $PGVER main


echo " attempting to setup postgres $PGVER "

PGMAIN=/etc/postgresql/$PGVER/main

#append to postgresql.conf
sudo bash -c "echo \"#HAXTBH\" >> $PGMAIN/postgresql.conf"
sudo bash -c "echo \"max_wal_senders=1\" >> $PGMAIN/postgresql.conf"
sudo bash -c "echo \"wal_level=hot_standby\" >> $PGMAIN/postgresql.conf"
sudo bash -c "echo \"synchronous_commit = off\" >> $PGMAIN/postgresql.conf"
sudo bash -c "echo \"work_mem = 128MB\" >> $PGMAIN/postgresql.conf"
sudo bash -c "echo \"statement_timeout = 3600000\" >> $PGMAIN/postgresql.conf"

#replace pg_hba.conf
sudo bash -c "echo \"#HAXTBH\" > $PGMAIN/pg_hba.conf"
sudo bash -c "echo \"host dstore readonly 127.0.0.1/32 md5\" >> $PGMAIN/pg_hba.conf"
sudo bash -c "echo \"host dstore readonly ::1/128 md5\" >> $PGMAIN/pg_hba.conf"
sudo bash -c "echo \"local all all trust\" >> $PGMAIN/pg_hba.conf"
sudo /etc/init.d/postgresql restart


echo ' creating postgres users only not databases which are created later '

sudo -u postgres bash -c "psql -c \"CREATE USER $PGUSER WITH SUPERUSER PASSWORD '$PGPASS';\""
sudo -u postgres bash -c "psql -c \"CREATE USER readonly WITH LOGIN PASSWORD 'secret' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE NOREPLICATION VALID UNTIL 'infinity';\""