it was a combination of two things.
the up grade to 8.4.12 does not use localhost. only host IP address for TCP
netstat -nlp | grep 5432
tcp 0 0 xx.xx.xxx.32:5432 0.0.0.0:*
LISTEN 2699/postmaster
unix 2 [ ACC ] STREAM LISTENING 9964 2699/postmaster
/tmp/.s.PGSQL.5432
.
next centos 5.8 no longer allows 127.0.1 without it being put in
firewall for both source and destination as well as port.
Rajbir Saini sent the following on 7/24/2012 8:49 PM:
> It looks your PostgreSql is not listening on TCP sockets. Instead it is
> listening on Linux socket and that is the reason when you give localhost
> switch to psql client, it tries to use the loopback interface.
>
> Simple solution is to make change in your postgresql.conf file to listen
> on TCP socket.
>
> Thanks,
>
> Raj
>
> On Wednesday 25 July 2012 08:31 AM, BJ Freeman wrote:
>> The 5 ofbiz installs have no changes since Jan 2012. the have been
>> running since 2011.
>> did a centos 5.6 server upgrade.
>> 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?
>>
>>
>> yet I can without the -h localhost, connect
>>
>> this is a PostgreSQL problem that I am dealing with in their mailing
>> list.
>>
>> just thought I would give a heads up.
>>
>>
>> Jacques Le Roux sent the following on 7/24/2012 2:01 PM:
>>> I currently use 9.1, no issues in production
>>>
>>> Jacques
>>>
>>> From: "BJ Freeman" <
[hidden email]>
>>>> PostgreSQL version 8.4.12 does not support 127.0.0.1 or localhost.
>>>> they use 127.0.0.1/32 in allowed host.
>>>> my entityengine.xml setting no longer work.
>>>> I am still working on a solution.
>>>
>>
>
>
Locked
