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/