From: philip.howell@cit.act.edu.au
To: pgsql-interfaces@postgresql.org
Subject: Re[2]: libpq PQstatus problem
Date: Wed, 14 Mar 2001 15:43:09 +1000
Message-ID: <0103149845.AA984551940@mh-cit.cit.act.edu.au> (raw)
____________________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
Attachments:RFC822.TXT (text/plain, 1.4K) download
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: philip.howell@cit.act.edu.au
Subject: Re: Re[2]: libpq PQstatus problem
In-Reply-To: <0103149845.AA984551940@mh-cit.cit.act.edu.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox