create.sh
上传用户:blenddy
上传日期:2007-01-07
资源大小:6495k
文件大小:1k
- #!/bin/sh
- # $Header: /usr/local/cvsroot/pgsql/src/test/bench/create.sh,v 1.2 1997/04/17 13:48:49 scrappy Exp $
- #
- if [ ! -d $1 ]; then
- echo " you must specify a valid data directory "
- exit
- fi
- if [ -d ./obj ]; then
- cd ./obj
- fi
- echo =============== destroying old bench database... =================
- echo "drop database bench" | postgres -D${1} template1 > /dev/null
- echo =============== creating new bench database... =================
- echo "create database bench" | postgres -D${1} template1 > /dev/null
- if [ $? -ne 0 ]; then
- echo createdb failed
- exit 1
- fi
- postgres -D${1} -Q bench < create.sql > /dev/null
- if [ $? -ne 0 ]; then
- echo initial database load failed
- exit 1
- fi
- exit 0