Re: another can't connect

Please don't top-post, it's so hard to follow discussions.

> Chris sent the following on 6/28/2009 7:33 PM:
>> BJ Freeman wrote:
>>> PostgreSQL version 8.1.11 (With schemas)
>>> I have read the recent emails and believe I have covered all the bases
>>> from net stat
>>> tcp        0      0 127.0.0.1:5432              0.0.0.0:*
>>>     LISTEN      5091/postmaster
>>>
>>> I do a
>>> psql -h 127.0.0.1  -U ofbiz -d ofbiz
>>> from a terminal on the server.
>>>
>>> and get this after a time
>>> psql: could not connect to server: Connection timed out
>>>     Is the server running on host "127.0.0.1" and accepting
>>>     TCP/IP connections on port 5432?
>>>
>>> Note this was working till about Fri.
>>> then only thing I have been doing is adding to my IPtables.
>>
>>> ACCEPT     tcp  --  localhost            localhost           tcp
>>> dpt:postgres state NEW
>> What about established connections?

 > tcp        0      0 127.0.0.1:5432              0.0.0.0:*
 >     LISTEN
 > is the only line for that port

established connections for the firewall, not just new connections.

see man iptables, --ctstate .

--
Postgresql & php tutorials
http://www.designmagick.com/