Error connecting to postgres database

Troubleshooting and help
,
1

Hi team, yesterday (16-17 hours ago) I deployed my app and everything was ok, but this morning, I’m unable to connect to the database service.

Initial error was:

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
    at /workspace/node_modules/pg-pool/index.js:45:11

I’ve confirmed that I’m on the latest version of pg already, so followed instructions from link in error here: Connection errors - Neon Docs . However, I was then met with authentication error:

error: password authentication failed for user '*******'
    at /workspace/node_modules/pg-pool/index.js:45:11

I’ve attempted some of the other options like adding the endpoint into the password, even breaking up the DB URL into the different parts when creating my db pool, all of which catches me in this loop.

Can you kindly assist? Error connecting to postgresql serverless service - #5 by Henry1 is essentially the same issue, but I’ve reposted as a new post here for visibility and fix.

Thank you

1 Like