PostgreSQL Server进程检查启动脚本

发布时间：2020-04-14 01:08:16 阅读：683 作者：pgmia 栏目：数据库

亿速云云数据库，读写分离，安全稳定，弹性扩容，低至0.3元/天！！点击查看>>

检测到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

root用户登录，脚本加到cron

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

向AI问一下细节

猜你喜欢