RE: ***SPAM*** Re: [SPAM] Remote Connection Help - Mailing list pgsql-general

I have removed the rules in the iptables and restarted it and got nothing. iptables is turned off and still nothing.

 

could not connect to server: Connection refused (Ox0000274D/10061) Is the server running on host " xx.xx.xx.xx" and accepting

TCP/IP connections on port 5432'

 

Connection refused means somthing has blocked it. If it was all OK and simply Postgres was not listening, you should've received a "connection timed out"(10060) message.
Have you tried adjusting/tearing off iptables and check what happens, as also Ekaterina pointed out?

And, just as a side note, I normally don't activate IPv6 if it's not necessary (it has not been necessary in the last 10 years :-) ), 'cause I've run in some troubles that have been cleared getting rid of IPv6)
so I'll try editing postgresql.conf as
listen = '127.0.0.1'

HTH,
Moreno.-