#! /bin/bash
#SuperUser=YES

echo
echo Fix RDBMS settings in your virtual machine
echo
pg=`find / -mount -name postgresql.conf 2> /dev/null`
if [ -n "$pg" ]
then
    echo
    echo Changing listening address for postgresql
    grep "^listen_addresses = '\*'" $pg > /dev/null 2>&1 || echo "listen_addresses = '*'"  >> $pg
else
    echo Postgres.conf file not found
fi

pg=`find / -mount -name pg_hba.conf 2> /dev/null`
if [ -n "$pg" ]
then
    echo Changing host allowance for postgresql
    grep "^host.*0\.0\.0\.0/0" $pg > /dev/null 2>&1 || echo "host  all  all   Proprietary information hidden/0  trust" >> $pg
 echo applying md5 to peer authentication
 sed -i "/^local.*all.*all.*peer$/s/peer/md5/g" $pg

 echo postgres restart in 5 minutes. We wait 5 min so we not interfere with prpc startup.
 echo service postgresql restart \> restart.res 2\>\&1 | at now + 5 min
else
     echo Postgres pg_hba.conf file not found
fi