Re: [SPAM] Remote Connection Help
Il 21/11/19 22:40, Peter J. Holzer ha scritto: On 2019-11-21 17:27:04 +0100, Moreno Andreo wrote: 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. Almost exactly the other way around. If you try to connect to a port where no server is listening, you get a connection refused message. If something is blocking the connection you may get a timeout. hp O.O You're right, obviously. Don't know why, it's since school days that sometines I swap these 2 error meanings (and have to deal with the consequences)... But I'm confident that one day there will be no more swapping... hopefully until I retire ...:-) Thanks for pointing out and sorry for the mistake (blushing) Moreno.-
Re: [SPAM] Remote Connection Help
On 2019-11-21 17:27:04 +0100, Moreno Andreo wrote: > 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. Almost exactly the other way around. If you try to connect to a port where no server is listening, you get a connection refused message. If something is blocking the connection you may get a timeout. hp -- _ | Peter J. Holzer| Story must make more sense than reality. |_|_) || | | | h...@hjp.at |-- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" signature.asc Description: PGP signature
Re: ***SPAM*** Re: [SPAM] Remote Connection Help
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 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 > *Sent:* Thursday, November 21, 2019 11:27 AM > *To:* pgsql-general@lists.postgresql.org > *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 (Ox274D/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.'
RE: ***SPAM*** Re: [SPAM] Remote Connection Help
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 Sent: Thursday, November 21, 2019 11:27 AM To: pgsql-general@lists.postgresql.org 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 (Ox274D/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.-
Re: [SPAM] Remote Connection Help
Il 21/11/19 15:21, Jason L. Amerson ha scritto: could not connect to server: Connection refused (Ox274D/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.-