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/
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
