1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
#!/bin/sh
#drop template_gis
#it may be used to drop any postgresql template, by supplying argument
source @bindir@/postgis_env.sh
for ARGVN in $1 $2 $3 $4 ; do
if [ `expr substr $ARGVN 1 11` = "--template=" ]; then
TDB=`echo $ARGVN | sed -e s/^--template=//`
elif [ `expr substr $ARGVN 1 6` = "--dba=" ]; then
DBAUSER=`echo $ARGVN | sed -e s/^--dba=//`
elif [ -n $ARGVN ]; then
echo "Usage of `basename $0`"
echo "Supply arguments as follows"
echo "--template=templatename of the template to remove"
echo "--dba=dbaname of the dba to run administrational programs as"
echo "You must usually be either root, or a postgresql dba in order"
echo "to use `basename $0`"
exit 1
fi
done
source @bindir@/postgres_lib.sh
sudo_dba $DBAUSER
export DBAUSER TDB
$SUDO -c "@bindir@/rmtemplate_gis.sh"
|
