Re: no mirrors availeble

> -----Original Message-----
> From: Marc G. Fournier [mailto:scrappy(at)postgresql(dot)org]
> Sent: 03 October 2004 18:29
> To: Dave Page
> Cc: Marc G. Fournier; gerard(at)dehoenderkooi(dot)nl;
> pgadmin-support(at)postgresql(dot)org
> 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!!" webmaster(at)postgresql(dot)org <
/tmp/svr-status
rm /tmp/svr-status
exit 1
fi
}

Regards, Dave.