#!/bin/bash

# POSTGRES
postgres () {
	service postgresql stop
	service postgresql start
	sleep 3
	service postgresql stop

	cp -f ./arqs-conf-rhel5/var/lib/pgsql/data/postgresql.conf /var/lib/pgsql/data/
	cp -f ./arqs-conf-rhel5/var/lib/pgsql/data/pg_hba.conf /var/lib/pgsql/data/

	service postgresql start

	su - postgres -c 'dropdb expresso'  || { echo "Banco expresso não existia. [OK]"; }
	su - postgres -c 'createdb -E LATIN1 expresso'  || { echo "Problemas na criação do banco expresso. [Falhou]"; exit 1;}

	sed -e "s/LDAP_DN/$LDAP_DN/g" -e "s/LDAP_PWD/$LDAP_PWD/g" -e "s/ORG/$ORG/g" -e "s/DOMAIN/$DOMAIN/g" ./arqs-conf-rhel5/expresso.dump > /tmp/expresso.dump

	service postgresql start
	chkconfig postgresql on

	su - postgres -c 'psql -f /tmp/expresso.dump expresso'

	rm /tmp/expresso.dump
}