diff options
Diffstat (limited to 'src/bin/createdb/createdb.sh')
| -rw-r--r-- | src/bin/createdb/createdb.sh | 66 |
1 files changed, 66 insertions, 0 deletions
diff --git a/src/bin/createdb/createdb.sh b/src/bin/createdb/createdb.sh new file mode 100644 index 00000000000..2d2116d4699 --- /dev/null +++ b/src/bin/createdb/createdb.sh @@ -0,0 +1,66 @@ +#!/bin/sh +#------------------------------------------------------------------------- +# +# createdb.sh-- +# create a postgres database +# +# this program runs the monitor with the "-c" option to create +# the requested database. +# +# Copyright (c) 1994, Regents of the University of California +# +# +# IDENTIFICATION +# $Header: /cvsroot/pgsql/src/bin/createdb/Attic/createdb.sh,v 1.1.1.1 1996/07/09 06:22:12 scrappy Exp $ +# +#------------------------------------------------------------------------- + +# ---------------- +# Set paths from environment or default values. +# The _fUnKy_..._sTuFf_ gets set when the script is installed +# from the default value for this build. +# Currently the only thing we look for from the environment is +# PGDATA, PGHOST, and PGPORT +# +# ---------------- +[ -z "$PGPORT" ] && PGPORT=5432 +[ -z "$PGHOST" ] && PGHOST=localhost +BINDIR=_fUnKy_BINDIR_sTuFf_ +PATH=$BINDIR:$PATH + +CMDNAME=`basename $0` + +if [ -z "$USER" ]; then + if [ -z "$LOGNAME" ]; then + if [ -z "`whoami`" ]; then + echo "$CMDNAME: cannot determine user name" + exit 1 + fi + else + USER=$LOGNAME + export USER + fi +fi + +dbname=$USER + +while test -n "$1" +do + case $1 in + -a) AUTHSYS=$2; shift;; + -h) PGHOST=$2; shift;; + -p) PGPORT=$2; shift;; + *) dbname=$1;; + esac + shift; +done + +AUTHOPT="-a $AUTHSYS" +[ -z "$AUTHSYS" ] && AUTHOPT="" + +monitor -TN $AUTHOPT -h $PGHOST -p $PGPORT -c "create database $dbname" template1 || { + echo "$CMDNAME: database creation failed on $dbname." + exit 1 +} + +exit 0 |