OK, so there is your problem. It is only listening on 18.104.22.168
I usually set listen_address = '*'
On Thu, Jul 26, 2012 at 4:02 PM, BJ Freeman <bjfree(at)free-man(dot)net> wrote:
> sorry was not subscribe before i sent this, I am now
>> netstat -nlp | grep 5432
> tcp 0 0 22.214.171.124:5432 0.0.0.0:* LISTEN
> unix 2 [ ACC ] STREAM LISTENING 9964 2699/postmaster
> BJ Freeman sent the following on 7/26/2012 12:40 PM:
>> did a centos 5.6 server upgrade to PostgreSQL version 8.4.12.
>> [root(at)main jdbc]# psql -h localhost -U gameserver
>> psql: could not connect to server: Connection refused
>> Is the server running on host "localhost" and accepting
>> TCP/IP connections on port 5432?
>> I notice there is no localhost and th 127.0.0.1 has /32 added.
>> I can not add a localhost to the allowed hosts
>> psql is running
>> if I do
>> [root(at)main jdbc]# psql -U gameserver
>> with out defining the host, it works.
>> I believe it is using Unix pipes instead of TCP
>> I also can manage the psql server through webmin.
>> I looked on the http://jdbc.postgresql.org/
>> and could not find any docs on the jdbc string to use my old one with
>> localhost and 127.0.0.1 do not work any more.
>> here is the conf
>> # "local" is for Unix domain socket connections only
>> local all all trust
>> # IPv4 local connections:
>> host all all 127.0.0.1/32 trust
>> # IPv6 local connections:
>> host all all ::1/128 trust
>> host all all 127.0.0.1 255.255.255.255 trust
>> host all all 0.0.0.0 0.0.0.0 trust
> Sent via pgsql-jdbc mailing list (pgsql-jdbc(at)postgresql(dot)org)
> To make changes to your subscription:
In response to
pgsql-jdbc by date
|Next:||From: Brady Mathis||Date: 2012-07-27 19:46:20|
|Subject: Opening view that uses a function - empty column|
|Previous:||From: BJ Freeman||Date: 2012-07-26 20:02:05|
|Subject: Re: upgrade causes psql to not work|