[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-general
Subject: [GENERAL] Connection loosing at some places - caused by firewall
From: Durumdara <durumdara () gmail ! com>
Date: 2017-11-14 11:09:31
Message-ID: CAEcMXhn8Hvu3do5F-k5o3x1nYy3wLHXTNFXU1A2SrADYGo97ww () mail ! gmail ! com
[Download RAW message or body]
Dear Members!
Windows 10, PGSQL 9.4 and 9.6 (Debian with SSL, and Windows without it - it
doesn't matter).
When I (or my boss) work(s) at home, I got connection lost errors from
PGAdmin (3/4) or from other applications too.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
PGAdmin, EMS PostgreSQL manager, Navicat for PGSQL, and psql too.
When minimum 5 minutes passed after the last request (select, insert, or
any communication what I did) the connection lost.
The keepalive timer is 10 minutes in the server - so it is not the source
of the problem.
I tried to set keepalive in the clients (EMS, Navicat called ping) to lower
- no effect.
When I did any request in my side before the 5 minutes "limit" passed, I
got a new 5 minutes.
It seems to be libpq.dll applications need traffic (started by the client)
in 5 minute periods to keep the connection.
In the office I don't have this limitation.
My colleauge can work at home without time limit, and he has same Internet
Provider as mine.
It's not PGSQL server based.
When I use VPN connection from home to reach office PG server, I also got
this problem.
From the office I can use same IP, same server without problem.
I checked the router, I disabled all things - nothing happened.
*I disabled my firewall at home - the problem vanished!!!*
And: if I use a secondary test computer (also Windows 10, PGAdmin III) - it
works at home!!!
I very-very wondered because it seems to be computer firewall problem.
I tried to use wifi and direct cable - no differents, so network card could
be eliminated from the "problem sources" list.
It's very interesting!
The firewall could make differents between networks and limits these
packages timeout to 5 minutes? Hmmm...
I made an exception to the firewall - nothing happened.
I know this is not Windows Admin list, but you may experienced same
problem, or you have idea about what to do.
This is become important for us because one of my customer have same
problem, and we don't know the solution...
What is your opinion about it?
Thanks
dd
[Attachment #3 (text/html)]
<div dir="ltr">Dear Members!<div><br></div><div><br></div><div>Windows 10, PGSQL 9.4 \
and 9.6 (Debian with SSL, and Windows without it - it doesn't \
matter).</div><div><br></div><div>When I (or my boss) work(s) at home, I got \
connection lost errors from PGAdmin (3/4) or from other applications \
too.</div><div><br></div><div><br></div><div><blockquote style="margin:0px 0px 0px \
40px;border:none;padding:0px"><div><div>server closed the connection \
unexpectedly</div><div> This probably means the server terminated \
abnormally</div><div> before or while processing the \
request.</div></div></blockquote></div><div><br></div><div>PGAdmin, EMS PostgreSQL \
manager, Navicat for PGSQL, and psql too.</div><div><br></div><div>When minimum 5 \
minutes passed after the last request (select, insert, or any communication what I \
did) the connection lost. </div><div><br></div><div>The keepalive timer is 10 \
minutes in the server - so it is not the source of the \
problem.</div><div><br></div><div>I tried to set keepalive in the clients (EMS, \
Navicat called ping) to lower - no effect.</div><div><br></div><div>When I did any \
request in my side before the 5 minutes "limit" passed, I got a new 5 \
minutes.</div><div><br></div><div>It seems to be libpq.dll applications need traffic \
(started by the client) in 5 minute periods to keep the \
connection.</div><div><br></div><div>In the office I don't have this limitation. \
<br><br>My colleauge can work at home without time limit, and he has same Internet \
Provider as mine.</div><div><br>It's not PGSQL server based. </div><div>When I \
use VPN connection from home to reach office PG server, I also got this problem. \
<br>From the office I can use same IP, same server without \
problem.</div><div><br></div><div>I checked the router, I disabled all things - \
nothing happened.</div><div><br></div><div><u><b>I disabled my firewall at home - the \
problem vanished!!!</b></u></div><div><br></div><div>And: if I use a secondary test \
computer (also Windows 10, PGAdmin III) - it works at \
home!!!</div><div><br></div><div>I very-very wondered because it seems to be computer \
firewall problem.</div><div>I tried to use wifi and direct cable - no differents, so \
network card could be eliminated from the "problem sources" \
list.</div><div><br></div><div>It's very interesting! </div><div>The firewall \
could make differents between networks and limits these packages timeout to 5 \
minutes? Hmmm...</div><div><br></div><div>I made an exception to the firewall - \
nothing happened.</div><div><br></div><div>I know this is not Windows Admin list, but \
you may experienced same problem, or you have idea about what to do. \
</div><div><br></div><div>This is become important for us because one of my customer \
have same problem, and we don't know the \
solution...</div><div><br></div><div>What is your opinion about \
it?</div><div><br></div><div>Thanks</div><div> dd</div></div>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic