Seitenhistorie
...
Codeblock |
---|
#!/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 # ---------------------------------------------------------------------- |
...
Überblick
Inhalte