it takes lot of refresh attempts to connect to DB

[nikhil2406]

i have postgres DB in AWS. I use this client to connect to it in VScode. I need to click refresh multiple times before it can establish a connection to my AWS DB. Then the connection breaks after some inactivity, I need to then do the same refresh button click again. Is there a way to increase time it waits for connection establishment to succeed? Is there a keep alive so that it doesnt break the connection often.

update:
Here is the log i see on output. Today it connected relatively quickly. But some days i need to keep clicking refresh.
2024-03-24 11:39:53 Execute fail : SELECT datname "Database" FROM pg_database WHERE datistemplate = false order by datname ASC;
2024-03-24 11:39:53 Error: read ETIMEDOUT
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
2024-03-24 11:39:53 Execute fail : SELECT datname "Database" FROM pg_database WHERE datistemplate = false order by datname ASC;
2024-03-24 11:39:53 Error: read ETIMEDOUT
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
2024-03-24 11:39:53 Execute fail : SELECT datname "Database" FROM pg_database WHERE datistemplate = false order by datname ASC;
2024-03-24 11:39:53 Error: read ETIMEDOUT
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
2024-03-24 11:39:53 Execute fail : SELECT datname "Database" FROM pg_database WHERE datistemplate = false order by datname ASC;
2024-03-24 11:39:53 Error: read ETIMEDOUT
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
2024-03-24 11:39:54 Creating PostgreSQL connection for 1697345580019/postgres_tree
2024-03-24 11:40:15 Execute fail : SELECT nspname "schema" from pg_catalog.pg_namespace order by nspname ASC;
2024-03-24 11:40:15 Error: read ETIMEDOUT
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
2024-03-24 11:40:15 Execute fail : SELECT nspname "schema" from pg_catalog.pg_namespace order by nspname ASC;
2024-03-24 11:40:15 Error: read ETIMEDOUT
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
2024-03-24 11:40:15 Error: read ETIMEDOUT
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
2024-03-24 11:40:15 Error: read ETIMEDOUT
at TCP.onStreamRead (node:internal/stream_base_commons:217:20)
2024-03-24 11:40:16 Creating PostgreSQL connection for 1697345580019/maindb_tree

[cweijan]

Hi, you can modify the connection timeout. The default time is 5 seconds. Is your connection to the AWS database very slow?

Regarding keep alive, I will try to support it in the next version.