Re: upgrade causes psql to not work

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(at)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(at)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
>