Can't connect to new postgres db Endpoint ID is not specified

Troubleshooting and help
1

I can connect to my existing postgres db but the new postgres db I’ve created is generating an error. Looks as though its related to Neon. Not sure if something internally has changed.

DBMS: PostgreSQL (ver. 18.1 (32149dd)) Case sensitivity: plain=lower, delimited=exact Driver: PostgreSQL JDBC Driver (ver. 42.7.3, JDBC4.2)
[28000] 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’. See more at https:// neon. tech/ sni.

The service name is db-test for my account.

I’ve tried connecting using the jdbc connector in datagrip and via a node script but the error above continues to exist. I essentially can’t create any use any new postgres services.

2

Take a look at your postgres URL. You need to add the endpoint as an option to the end of your URL, as Neon/Koyeb’s design shares multiple locations to a single IP, so it needs the endpoint as part of the options to understand where your database exists. Yes, this means the domain-id is listed twice in the URL.

Take a look at my example here and try to replicate it on your end. In theory that should work for connecting, but I’m stuck at this point as I can’t authenticate. If you do get it working, please let me know what you did, as I’m at this point in accessing the database, and I’ve tried for a couple of days.

postgres://[username]:[password]@[domain-id].c-3.us-east-1.pg.koyeb.app/[db-name]?sslmode=require&options=endpoint%3D[domain-id]