[BUG] SSH proxy doesn't automatically reconnect (PostgreSQL)

[EdenGottlieb]

Describe the bug

On network change (e.g. switching between networks / closing the lid for extended periods of time) the SSH proxy used to connect to the database (defined in the Proxy tab in database connection settings) disconnects and doesn't reconnect automatically (all queries load indefinitely)

Private key authentication (Auth set to Key)

Platform and Database

macOS 15.7.3
Dataflare 2.8.6 (non-activated)
PostgreSQL 16.10
OpenSSH_9.2p1 on remote (Google Cloud Compute Engine)

[wyhaya]

Hi @EdenGottlieb , thank you for your feedback.

I tested it on my MacBook and found that whether the network is disconnected, switched, or the SSH tunnel is closed, the hang lasts at most 30-40s, which I believe is expected.

After that you receive an error:

SSH proxy error: Connection reset by peer (os error 54)
IO error: channel closed
IO error: early eof

Re-running the query will re-establish the network.
Could you test it again to see if the hang lasts longer than one minute?

---

You can also manually reconnect by typing reconnect in the Quick Search.

[EdenGottlieb]

@wyhaya thank you for the quick response!
I can confirm that after about 30 seconds the connection reconnects automatically.
reconnect command works great so I'm gonna use that as 30 seconds delay is a tad long for me.
I'd suggest adding some UI indication of this reconnection. Thank you very much!