Re: ***SPAM*** Re: [SPAM] Remote Connection Help

[Andrew Kerber <andrew.kerber@xxxxxxxxx>]

If you just removed the iptables rules, then every port is blocked.  If you turned off iptables (service iptables stop, chkconfig iptables off,) then iptables is disabled.

On Thu, Nov 21, 2019 at 10:50 AM Jason L. Amerson <drjason@xxxxxxxxxxxxxxx> wrote:

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

 

Jason L. Amerson

 

From: Moreno Andreo <moreno.andreo@xxxxxxxxxx>
Sent: Thursday, November 21, 2019 11:27 AM
To: pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: ***SPAM*** Re: [SPAM] Remote Connection Help

 

Il 21/11/19 15:21, Jason L. Amerson ha scritto:

 

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.-

--

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'