Too many open TCP connections with Azure Database for Postgres

[rahulbreddy]

Our application uses 7.4.1 version of pg with all default values. I tried the same application with a local postgres (versions 9.4 and 9.6) and postgres on AWS RDS (version 9.5.1). Both seems to work fine.

However with Azure Database for Postgres, the number of open tcp connections on the client keep increasing. My application executes a couple of queries every minute and looks like the pg module terminates the connection after 30 sec of inactivity.

On my local postgres and postgres on aws, I see that the server acknowledges and sends a FIN signal when it receives an X from the client. However, Azure Database for Postgres sends a keepalive and the TCP connections are kept open forever.

Has any one experienced this behavior?

[rahulbreddy]

Looks like #1608 will fix the issue.