PostgreSQL数据库管理脚本

适用于PostgreSQL数据库管理，使用普通用户postgres管理，参数为(start|stop|restart|condrestart|status)

#!/bin/bash

if [ -f /etc/rc.d/functions ];
then
. /etc/init.d/functions
fi

#数据库data路径

data_dir="/cache1/PostgreSQL/9.1"
# PostgreSQL Service script for Linux
start()
{
echo $"Starting PostgreSQL_9.1: "
su - postgres -c "LD_LIBRARY_PATH=$data_dir/lib:$LD_LIBRARY_PATH $data_dir/bin/pg_ctl -w start -D \"$data_dir/data\" -l \"$data_dir/data/pg_log/startup.log\""
if [ $? -eq 0 ];
then
echo "PostgreSQL_9.1_data started successfully"
exit 0
else
echo "PostgreSQL_9.1_data did not start in a timely fashion, please see $data_dir/data/pg_log/startup.log for details"
exit 1
fi
}
stop()
{
echo $"Stopping PostgreSQL_9.1: "
su - postgres -c "LD_LIBRARY_PATH=$data_dir/lib:$LD_LIBRARY_PATH $data_dir/bin/pg_ctl stop -m fast -w -D \"$data_dir/data\""
}
restart()
{
echo $"Restarting PostgreSQL_9.1: "
su - postgres -c "LD_LIBRARY_PATH=$data_dir/lib:$LD_LIBRARY_PATH $data_dir/bin/pg_ctl -w restart -D \"$data_dir/data\" -l \"$data_dir/data/pg_log/startup.log\" -m fast"
if [ $? -eq 0 ];
then
echo "PostgreSQL_9.1_data restarted successfully"
exit 0
else
echo "PostgreSQL_9.1_data did not start in a timely fashion, please see $data_dir/data/pg_log/startup.log for details"

exit 1
fi
}
reload()
{
echo $"Reloading PostgreSQL_9.1: "
su - postgres -c "LD_LIBRARY_PATH=$data_dir/lib:$LD_LIBRARY_PATH $data_dir/bin/pg_ctl reload -D \"$data_dir/data\""
}
# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
restart)
restart
;;
reload)
reload
;;
condrestart)
if [ -f "$data_dir/data/postmaster.pid" ]; then
restart
fi
;;
status)
# su - postgres -c "LD_LIBRARY_PATH=$data_dir/lib:$LD_LIBRARY_PATH $data_dir/bin/pg_ctl status -D \"$data_dir/data_002\""
PIDS=`ps aux |grep postgres |grep "\-D"|grep "data" |awk '{print $2}'`
[ "$PIDS" != "" ] && echo -e "postgresql_data (pid $PIDS) is running"
[ "$PIDS" == "" ] && echo -e "postgresql_data is stop"
;;
*)
echo $"Usage: $data_dir/installer/server/startupcfg.sh {start|stop|restart|condrestart|status}"
exit 1
esac