Re: upgrade causes psql to not work

OK, so there is your problem. It is only listening on 69.94.133.32

I usually set listen_address = '*'

Dave Cramer

dave.cramer(at)credativ(dot)ca
http://www.credativ.ca


On Thu, Jul 26, 2012 at 4:02 PM, BJ Freeman <bjfree@free-man.net> wrote:
> Dave
> sorry was not subscribe before i sent this, I am now
>
>> netstat -nlp | grep 5432
> tcp        0      0 69.94.133.32:5432  0.0.0.0:*             LISTEN
> 2699/postmaster
>
> unix  2      [ ACC ]     STREAM     LISTENING     9964   2699/postmaster
> /tmp/.s.PGSQL.5432
>
>
> 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.
>> console:
>> [root@main jdbc]# psql -h localhost -U gameserver
>> passwordfromentityengine.xml
>>
>> 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@main jdbc]# psql -U gameserver
>> passwordfromentityengine.xml
>> 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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc