PostgreSQL Server進程檢查啟動指令碼

標籤：postgresql server進程 down

檢測到PostgreSQL Server進程 down 的時候啟動，running狀態無動作

# more pg_server_check.sh 

#!/bin/sh

export PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

prefix=/etc/init.d

DAEMON="$prefix/postgresql"

RUNN_STR="server is running"

Pg_Status=`$DAEMON status|grep "$RUNN_STR"`

LOG_PATH=/opt/cron

CHECK_LOG=$LOG_PATH/pg_server_check.log

Error_log=$LOG_PATH/pg_server_check_Error.log

echo "$Pg_Status"

DT_STR=`date +‘%Y-%m-%d %H:%M:%S‘`

if [ -z "$Pg_Status" ]

then

    echo "Check Time: $DT_STR " > $Error_log

    echo "Error: PostgreSQL Server is down." >> $Error_log

    echo "$DAEMON start"|sh >> $Error_log

else

    

    echo "Check Time: $DT_STR " > $CHECK_LOG

    echo "PostgreSQL Server is running,do nothing." >> $CHECK_LOG

fi

root使用者登入，指令碼加到cron

*/2 * * * * /opt/cron/pg_server_check.sh

本文出自 “yiyi” 部落格，請務必保留此出處http://heyiyi.blog.51cto.com/205455/1890791

PostgreSQL Server進程檢查啟動指令碼