Seitenhistorie

#!/bin/bash
# ----------------------------------------------------------------------
# /usr/local/bin/pgprep - prepare nuclos pgsql database
# max@kalhammer.com 2014-02-09
# ----------------------------------------------------------------------

pghost=localhost
pgport=5432
pguser=postgres
pgpass=ds011$SKnuclos
pgnusr=nuclos
pgnpwd=ds011$SK
pgbase=nuclosdb
pgscma=nuclos
pgopts=--no-password
pgpath=/data/pgsql
pgtemp=/var/tmp/pgprep.sql
pgpsql=/opt/PostgreSQL/9.3/bin/psql

echo $pghost:$pgport:$pgbase:$pguser:$pgpass > ~/.pgpass
chmod 600 ~/.pgpass
echo "-- Postgres Database Preparation for Nuclos"                                                             > $pgtemp
echo "-- ========================================"                                                            >> $pgtemp
if [ "$1" = "init" ]; then
 echo "-- Create Role $pgnusr"                                                                                >> $pgtemp
 echo "CREATE ROLE $pgnusr LOGIN UNENCRYPTED PASSWORD '$pgnpwd' NOSUPERUSER INHERIT NOCREATEDB NOCREATEROLE;" >> $pgtemp
fi
#cho "CREATE TABLESPACE $pgnusr WITH OWNER = $pgnusr LOCATION = '$pgpath';"                                   >> $pgtemp
echo "-- Create Database $pgbase with owner $pguser"                                                          >> $pgtemp
echo "CREATE DATABASE $pgbase WITH OWNER = $pgnusr TEMPLATE = template1 ENCODING = 'UTF8';"                   >> $pgtemp
echo "\c $pgbase"                                                                                             >> $pgtemp
echo "-- Create Schema $pgscma for $pgnusr"                                                                   >> $pgtemp
echo "CREATE SCHEMA $pgscma AUTHORIZATION $pgnusr;"                                                           >> $pgtemp
if [ "$1" = "init" ]; then
 echo "-- Create Language plpgsgl"                                                                            >> $pgtemp
 echo "CREATE LANGUAGE plpgsql;"                                                                              >> $pgtemp
fi
chmod 666 $pgtemp
su - $pguser -c "$pgpsql -a --file=$pgtemp"
rm $pgtemp

# ----------------------------------------------------------------------