#!/bin/bash
data=`date +%Y-%M-%d" "%H:%m`
netstat -lntup|grep 5432 && ps -ef|grep postmaster
if [ $? -eq 0 ];then
	for IP in xx.xx.xx.xx xx.xx.10.189
	do
	/usr/bin/psql -h xx.xx.10.190 -p 5432 -U repl -d postgres --command "select * from pg_stat_replication"|grep $IP
	if [ "$?" != "0" ];then
		echo "postgresql master-slave status is error! please login check!"|mail -r "it-arch" -s "postgresql master-slave status is error" it-arch \
		&& echo "$data postgresql postgresql master-slave status is error!">>/var/log/postgresql-error.log
	fi
	done
else
	echo "postgresql master-slave status is error! please login check!"|mail -r "it-arch" -s "postgresql master-slave status is error" it-arch \
	&& echo "$data postgresql postgresql master-slave status is error!">>/var/log/postgresql-error.log
fi