pg.ddx.io  pgsql-interfaces@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Joe Conway <jconway2@home.com>
To: philip.howell@cit.act.edu.au
To: pgsql-interfaces@postgresql.org
Subject: Re: libpq PQstatus problem
Date: Tue, 13 Mar 2001 21:16:11 -0800
Message-ID: <007701c0ac45$e267d3b0$0205a8c0@jecw2k1> (raw)
References: <0103149845.AA984548336@mh-cit.cit.act.edu.au>

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





view thread (4+ messages)  latest in thread

Message-ID: <007701c0ac45$e267d3b0$0205a8c0@jecw2k1>
Permalink:  ../007701c0ac45$e267d3b0$0205a8c0@jecw2k1/
Also on:    postgresql.org/message-id/007701c0ac45$e267d3b0$0205a8c0@jecw2k1

 · 

reply

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: jconway2@home.com, philip.howell@cit.act.edu.au
  Subject: Re: libpq PQstatus problem
  In-Reply-To: <007701c0ac45$e267d3b0$0205a8c0@jecw2k1>

* 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