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 f2E5Hex39367
	for <pgsql-interfaces@postgresql.org>;
	Wed, 14 Mar 2001 00:17:40 -0500 (EST)
	(envelope-from joe.conway@mail.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 <20010314051739.TNBD2254.femail12.sdc1.sfba.home.com@jecw2k1>;
	Tue, 13 Mar 2001 21:17:39 -0800
Message-ID: <008c01c0ac46$1aa9fcd0$0205a8c0@jecw2k1>
Reply-To: "Joe Conway" <joe.conway@mail.com>
From: "Joe Conway" <joe.conway@mail.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:17:45 -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/120
X-Sequence-Number: 1281

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