#!/bin/sh
#
#___INFO__MARK_BEGIN__
##########################################################################
#
#  The Contents of this file are made available subject to the terms of
#  the Sun Industry Standards Source License Version 1.2
#
#  Sun Microsystems Inc., March, 2001
#
#
#  Sun Industry Standards Source License Version 1.2
#  =================================================
#  The contents of this file are subject to the Sun Industry Standards
#  Source License Version 1.2 (the "License"); You may not use this file
#  except in compliance with the License. You may obtain a copy of the
#  License at http://gridengine.sunsource.net/Gridengine_SISSL_license.html
#
#  Software provided under this License is provided on an "AS IS" basis,
#  WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING,
#  WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS,
#  MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING.
#  See the License for the specific provisions governing your rights and
#  obligations concerning the Software.
#
#  The Initial Developer of the Original Code is: Sun Microsystems, Inc.
#
#  Copyright: 2001 by Sun Microsystems, Inc.
#
#  All Rights Reserved.
#
##########################################################################
#___INFO__MARK_END__
#
#
# parameters: we need PGHOST DBNAME and optionally PGPORT

PGHOST=bilbo
DBNAME=sge
export PGHOST

BASEDIR=dist/util/resources/spooling

# check version (pg_config --version)

# check if db is working (psql -l)
databases=`psql -Aqtl | cut -f 1 -d "|" | tr '\n' ' '`
echo $databases

# if database already exists, query admin if it shall be kept or recreated
for i in $databases; do
   if [ $i = $DBNAME ]; then
      echo "deleting database $DBNAME"
      dropdb "${DBNAME}"
   fi
done

createdb "${DBNAME}"
SOLARIS64/spoolinit blah "host=$PGHOST dbname=$DBNAME" init history
#psql -f "${BASEDIR}/init_postgres.sql" $DBNAME

