Received: from odin.cit.act.edu.au ([161.50.48.2])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2E5nhx42624
	for <pgsql-interfaces@postgresql.org>;
	Wed, 14 Mar 2001 00:49:43 -0500 (EST)
	(envelope-from philip.howell@cit.act.edu.au)
Received: by odin.cit.act.edu.au; id RAA27599;
	Wed, 14 Mar 2001 17:42:06 +1100 (EST)
From: <philip.howell@cit.act.edu.au>
Received: from babel.cit.act.edu.au(161.50.1.52) by odin.cit.act.edu.au via
	smap (V5.0) id xma027555; Wed, 14 Mar 01 17:41:59 +1100
Received: from mh-cit.cit.act.edu.au (mh-cit.cit.act.edu.au [161.50.16.125])
	by babel.cit.act.edu.au (8.9.3/8.9.3) with SMTP id QAA08076
	for <pgsql-interfaces@postgresql.org>; Wed, 14 Mar 2001 16:48:44 +1100
Received: from ccMail by mh-cit.cit.act.edu.au (ccMail Link to SMTP
	R8.20.00.25) id AA984551940; Wed, 14 Mar 2001 16:39:03 +1000
Message-Id: <0103149845.AA984551940@mh-cit.cit.act.edu.au>
X-Mailer: ccMail Link to SMTP R8.20.00.25
Date: Wed, 14 Mar 2001 15:43:09 +1000
To: <pgsql-interfaces@postgresql.org>
Subject: Re[2]: libpq PQstatus problem 
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="simple boundary"
X-Archive-Number: 200103/121
X-Sequence-Number: 1282

--simple boundary
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Content-Description: "cc:Mail Note Part"



____________________Forward Header_____________________
Subject:    Re[2]: [INTERFACES] libpq PQstatus problem 
Author: Philip Howell
Date:       14/03/01 3:32 PM

Sorry,
I should have stressed that the postgreSQL  server and the client test program
are on different machines, communicating across the network.  So stopping the
network interface should definitely break the connection.

Thanks

Phil


____________________Reply Separator____________________
Subject:    Re: [INTERFACES] libpq PQstatus problem 
Author: "Joe Conway" <jconway2@home.com>
Date:       13/03/01 9:16 PM

>
> Then I stopped the network (eth0) on the postgreSQL server and hit
<return>
> again and still got
>
> > Connection status... OK
>
> as the output.  However Trying to execute the program with the postgreSQL
server
> offline resulted in the expected error messages, so it seems that in this
case
> the status was detected successfully.
>

I tried stopping the network on my machine, and was still able to connect
when logged on locally via psql. I presume this is because the local unix
sockets connection still works from the local machine. You might test this
by editing your pg_hba.conf file to disallow local sockets. e.g.:

local        all                                           reject


Hope this helps,

Joe



 


--simple boundary
Content-Type: text/plain; charset=US-ASCII; name="RFC822.TXT"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment; filename="RFC822.TXT"

Received: from babel.cit.act.edu.au [161.50.1.52] by mh-cit.cit.act.edu.au (ccMail Link to SMTP R8.20.00.25)
	; Wed, 14 Mar 2001 16:07:10 +1000
Return-Path: <jconway2@home.com>
Received: from odin.cit.act.edu.au (firewall-user@odin.cit.act.edu.au [161.50.47.2])
	by babel.cit.act.edu.au (8.9.3/8.9.3) with ESMTP id QAA07743
	for <philip.howell@cit.act.edu.au>; Wed, 14 Mar 2001 16:16:51 +1100
Received: by odin.cit.act.edu.au; id RAA20137; Wed, 14 Mar 2001 17:10:06 +1100 (EST)
Received: from femail12.sdc1.sfba.home.com(24.0.95.108) by odin.cit.act.edu.au via smap (V5.0)
	id xma020049; Wed, 14 Mar 01 17:09:38 +1100
Received: from jecw2k1 ([24.0.42.111]) by femail12.sdc1.sfba.home.com
          (InterMail vM.4.01.03.00 201-229-121) with SMTP
          id <20010314051605.TLRO2254.femail12.sdc1.sfba.home.com@jecw2k1>;
          Tue, 13 Mar 2001 21:16:05 -0800
Message-ID: <007701c0ac45$e267d3b0$0205a8c0@jecw2k1>
Reply-To: "Joe Conway" <jconway2@home.com>
From: "Joe Conway" <jconway2@home.com>
To: <philip.howell@cit.act.edu.au>, <pgsql-interfaces@postgresql.org>
References: <0103149845.AA984548336@mh-cit.cit.act.edu.au>
Subject: Re: [INTERFACES] libpq PQstatus problem
Date: Tue, 13 Mar 2001 21:16:11 -0800
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400

--simple boundary--