Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28])
	by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f2EF6Hx22219
	for <pgsql-interfaces@postgresql.org>;
	Wed, 14 Mar 2001 10:06:17 -0500 (EST)
	(envelope-from pgsql-interfaces-owner@postgresql.org)
Received: from femail12.sdc1.sfba.home.com (femail12.sdc1.sfba.home.com
	[24.0.95.108])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2E5G6x39308
	for <pgsql-interfaces@postgresql.org>;
	Wed, 14 Mar 2001 00:16:06 -0500 (EST)
	(envelope-from jconway2@home.com)
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: 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
X-Archive-Number: 200103/126
X-Sequence-Number: 1287

>
> 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