Close SSL connections gracefully
When the client closes a Postgres connection (by sending the "X" command) that uses SSL, a normal Postgres server sends SSL "close_notify" alert, thus closing the connection gracefully (client sees graceful "end of stream").
With Azure PostgreSQL, I see just a TCP RST packet, and the client sees an abrutly terminated connection.
This causes unnecessary errors with at least some Postgresql client libraries. For example, the current version of Node.js pg / node-postgres library.
A fix for this was rolled out in 2018. Our apologies for not updating this item promptly.
If you encounter any issues with this particular scenario, do email postgresqluservoice at microsoft.com or open an Azure support ticket so we can closely investigate.
Rachel, on behalf of the Azure Database for PostgreSQL team