Old Postgres driver - can't connect PostgreSQL DB hosted on neon.tech

[olifink]

Issue Summary

Can't connect a Postgres DB hosted on neon.tech because it appears redash uses an older driver that doesn't support Endpoint IDs. Also, there is no way to enter the parameters in the connection string for a workaround

Connection Test Failed:
ERROR: Endpoint ID is not specified. Either please upgrade the postgres client library (libpq) for SNI support or pass the endpoint ID (first part of the domain name) as a parameter: '?options=endpoint%3D<endpoint-id>'. See more at https://neon.tech/sni

Steps to Reproduce

1. Setup the database with the following connection string

DATABASE_URL='postgresql://neondb_owner:XXXXXXXXXX@ep-shiny-wildflower-ag83nxur-pooler.c-2.eu-central-1.aws.neon.tech/neondb?sslmode=require&channel_binding=require'

Any other info e.g. Why do you consider this to be a bug? What did you expect to happen instead?

Technical details:

• Redash Version: 8.0.0+b32245
• Browser/OS: Chrome/Fedora 43
• How did you install Redash: your image on GCP following https://redash.io/help/open-source/setup/

[yoshiokatsuneo]

I'm not sure the cause.

But, I think you are using older Redash.
I can suggest to upgrade to the latest Redash, with the latest docker compose file.

[eradman]

The problem here appears to be that we do not have a means of specifying connection parameters.
https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS

I will look into a solution for this.