slightly modified code added:
status=`/usr/local/bin/psql -h pgsql74.hub.org -U 186_pgsql -d 186_portal -A -t -F '' -c "SELECT 'SERVER_UP'"`
if [ "$status" != "SERVER_UP" ]; then
echo "DNS not regenerated" | mail -s "WARNING: Server $1:$2 is down!!" [EMAIL
PROTECTED]
exit 1
fi
On Sun, 3 Oct 2004, Dave Page wrote:
-----Original Message----- From: Marc G. Fournier [mailto:[EMAIL PROTECTED] Sent: 03 October 2004 18:29 To: Dave Page Cc: Marc G. Fournier; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: RE: [pgadmin-support] no mirrors availeble
just changed the rebuild script to happen every 6 hours vs 24 ... if that is the reason for the below, this should help at least reduce the length of time til its fixed ...
Did you ever add the database connection check that I suggested once?
chksvr() { # Dummy query to check the server status status=`/usr/local/bin/psql -h $1 -p $2 -U $4 -d $3 -A -t -F '' -c "SELECT 'SERVER_UP'"`
if [ "$status" != "SERVER_UP" ]; then mail -s "WARNING: Server $1:$2 is down!!" [EMAIL PROTECTED] < /tmp/svr-status rm /tmp/svr-status exit 1 fi }
Regards, Dave.
---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org
