source: sandbox/doc-expressolivre/arquivos/scripts/bd.sh @ 2245

#!/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
}