From: | PG User <pguser1982(at)gmail(dot)com> |
---|---|
To: | "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org> |
Subject: | keep alive support |
Date: | 2014-05-09 04:59:53 |
Message-ID: | CAB7tN8bTc1Sz1FS9tOGuW7aqhQcyzEVpxEDTD9yxCPj+Bx_QYw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
Hi All,
Last time I demanded the support for TCP keep alive setting for postgres
odbc driver. I can see the code in 9.3.210, but when I tried msi installer
on windows, I still see the issue of firewall dropping connection.
I have the following setting in registry:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters\:
-
KeepAliveTime: 30000
-
KeepAliveInterval: 1000
-
TcpMaxDataRetransmissions: 10
I had tried it on Linux last time and it was working there. On linux, I had
the following settings:
/sbin/sysctl -w net.ipv4.tcp_keepalive_time=200
net.ipv4.tcp_keepalive_intvl=200 net.ipv4.tcp_keepalive_probes=5
Has it worked for anyone on windows?
Do I need to do any setting on machine?
Is there any tool (on windows) which I can use to see if TCP connection has
keep alive option?
Thanking you.
- Nachiket
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2014-05-12 01:35:02 | Error string typo in statement.c |
Previous Message | Malcolm MacLeod | 2014-05-07 14:37:29 | Re: CC_send_query_append crash |