can't connect to Postgresql provided by nhost.io

[yureckey]

there is nhost.io service which provides Postgresql in the Amazon cloud, I'm not sure exactly what they use (not RDS, maybe K8S) when I'm trying to connect to this db from other dashboard-building tools (Retool, Appsmith, Nocodb) it's working fine. But connecting from Tooljet isn't working

Version Information

latest

Environment

ToolJet Cloud

What is the expected behaviour?

working connection to Postgresql instance

What is the current behaviour?

see screenshot of error

How to reproduce the issue?

1. signup and create new project in the nhost.io
2. get connection string
3. try to connect

Screenshots or Screencast

[mslourens]

the startup argument statement_timeout is not supported by the Postgresql version used by Nhost.io, but it is passed by the Tooljet Postgresql plugin.

[shivangT]

Hey @yureckey ,

Let me discuss this with the team. Getting back shortly. What PostgreSQL version are you using?

Thanks for waiting

[yureckey]

it's PostgreSQL 14.5

[piperubio]

Hello,

I am also experiencing a similar problem with Postgres 15.3. Like @yureckey, I am unable to connect to a Postgres Pool provided by Digital Ocean Managed DB.

In my case, I am using pgBouncer for connection pooling. I noticed that the statement_timeout option in the connection configuration seems to be causing the issue. pgBouncer does not support this option, and it's causing the connection to fail. GL#338076.

Is there any update on this issue? It would be great if I could get some guidance on how to resolve it or if there is any plan for a fix in a future update.

Thank you for your time and assistance.