From: | "Marc G(dot) Fournier" <scrappy(at)postgresql(dot)org> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: no mirrors availeble |
Date: | 2004-10-03 22:46:24 |
Message-ID: | 20041003194602.W96717@ganymede.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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!!" webmaster(at)postgresql(dot)org
exit 1
fi
On Sun, 3 Oct 2004, Dave Page wrote:
>
>
>> -----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.
>
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy(at)hub(dot)org Yahoo!: yscrappy ICQ: 7615664
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2004-10-04 07:19:42 | Re: no mirrors availeble |
Previous Message | Dave Page | 2004-10-03 19:41:31 | Re: no mirrors availeble |