Resent-From: POSTGRES mailing list <postman@postgres.Berkeley.EDU>
Resent-Message-Id: <199311040714.XAA21146@nobozo.CS.Berkeley.EDU>
Sender: owner-postman@postgres.Berkeley.EDU
From: PostGres <postgres@st.nepean.uws.edu.au>
Message-Id: <199311040714.AA23883@guinevere.st.nepean.uws.edu.au>
Subject: Detecting no postmaster
To: postgres@postgres.Berkeley.EDU (PostGres Mail Group)
Date: Thu, 4 Nov 1993 18:14:21 +1100 (EST)
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Length: 1410      
Resent-To: postgres-dist@postgres.Berkeley.EDU
Resent-Date: Wed, 03 Nov 93 23:14:31 -0800
Resent-XMts: smtp

Dear gurus,

I am wondering whether there is any way to detect that
a postmaster is not running on a given host.

What I am trying to do is change from on postmaster to
another postmaster during the execution of the program.

The code is like the following :
(the name of the new host is retrieved from the db)

strcpy(PQhost, PQgetvalue(PQparray("blank"),0,0));
PQsetdb("remote");

to change postmasters and databases, then I thought I
might be able to tramsmit a bogus query and capture
the return to see if the postmaster exists.

If the postmaster on the remote machine is not running
the code terminates with :

StreamOpen: connect: errno=61
Error: Failed to connect to backend (host=tron, port=4321)
Is the postmaster running?

I would like to capture this and display something more
like :

Server on host "tron" is not responding !

Thanx for any advice that you can give,
Glen Darby.
-- 
--------------------------------------------------------
| University Of Western Sydney                         |
| Postgres Database Aministration                      |
|                                                      |
| Administrator :  Glen Darby                          |
|                                                      |
|                                                      |
| Return Mail : postgres@st.nepean.uws.edu.au          |
========================================================