SSL Connection string issues - Retool Database

Queries and Resources
1

Retool have adjusted the connection string to the retool database and I am now getting the following error when connecting through my windows ODBC connector -

image
image734×524 54.8 KB

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'

This is my connection string, password hidden for this.

postgresql://retool:xxxxxxxxxx@ep-polished-truth-34291300.us-west-2.retooldb.com/retool?sslmode=require

Server = ep-polished-truth-34291300.us-west-2.retooldb.com
Database = Production
User Name = Production
SSL MODE = Required
Post = 5432
Password = xxxxxxxxx

I dont understand what needs to be done to the above to fix the error highlighted "pass the endpoint ID (first part of the domain name) as a parameter: '?options=endpoint%3D'*"

I have tried adjusting the server to the following and still get an error, I never had any issues in the past until retool migrated our database.

ep-polished-truth-34291300.us-west-2.retooldb.com/retool?options=endpoint%3Dep-polished-truth-34291300

image

Any help would be much appreciated

Thanks

2

I still can connect it with js library.

image

Could u check your database connection information here?

3

Hi,

Yes checked the connection and reran multiple times. Issue seems to be unique to the ODBC Connector, of which I cant seem to get right logic on the server requirements?

4

Also looks like you havent been migrated, does your connection end in retool?sslmode=require?

5

image
It seem not end with that