Re: libpq PQstatus problem - Mailing list pgsql-interfaces

From Joe Conway
Subject Re: libpq PQstatus problem
Date
Msg-id 007701c0ac45$e267d3b0$0205a8c0@jecw2k1
Whole thread Raw
In response to libpq PQstatus problem  (<philip.howell@cit.act.edu.au>)
List pgsql-interfaces
>
> 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




pgsql-interfaces by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Don't 'kill -9' the postmaster
Next
From: Stéphane EVEILLARD
Date:
Subject: Big trouble with libpq++