Fly.io with Render PG: "ssl recv (idle): closed"

1

In evaluating Render’s managed PG service, I cannot seem to get past the following Ecto error when trying to connect fro Fly.io:

Postgrex.Protocol (#PID<0.5077.0>) failed to connect: ** (DBConnection.ConnectionError) ssl recv (idle): closed

SSL is enabled, and I’m using the “External Database URL” as found in the info page.

What did I miss?

2

Hi there,

Please try adding some additional keep alive settings when you connect to Postgres via our external URL. The settings to try are:

  • tcp_keepalives_idle = 300
  • tcp_keepalives_interval = 60
  • tcp_keepalives_count = 5

Regards,

Keith
Render Support, UTC+10 :australia: