Error connecting to postgresql serverless service

Troubleshooting and help
, ,
1

I’m having trouble trying to connect to the postgresql serverless instance i created using the free tier service.

The first errors I encountered were related to the fact i was not passing in the connection string the sslmode or the endpoint id using “options”.

Following the troubleshooting documentation I was able to correct those previous errors but now I am receiving an error related to an incorrect password. Which kinda puzzles me as I am using the information provided by the database connection web panel.

This is the command I have been using:

psql -h [endpoint-id].c-3.us-east-1.pg.koyeb.app -p 5432 -U demo -d “dbname=demodb sslmode=require options=endpoint=[endpoint-id]”

After that I get prompted to input the password. But no luck. I just get:

ERROR: password authentication failed for user [user]

I have also tried to connect using pgadmin both desktop or web version.

Could you help me with this?

2

Just wanted to note that I’m having this same issue, too. On a lark, I tried starting up the free database from scratch to make sure it wasn’t something I had flubbed.

psql -h [endpoint-id].c-3.us-east-1.pg.koyeb.app -U koyeb-adm -d “dbname=koyebdb sslmode=require options=endpoint=[endpoint-id]”

psql: error: connection to server at “[endpoint-id].c-3.us-east-1.pg.koyeb.app” (35.171.11.169), port 5432 failed: ERROR: password authentication failed for user 'koyeb-adm’

I even tried typing the password out by hand instead of copy-pasting to see if it was that, but no luck.

1 Like
3

I’m having the same issue. I’ve tried 100 different ways and can’t seem to get this to work. It’s possible I’m missing something still but this really seems like a bug.

4

Folks, I apologize for a late answer. We’ve identified the problem, and it should be resolved now.

5

Hi @Lukasz_Oles - I’m getting the same issue. Both my server and db services were deployed ok yesterday, but today, was getting “error: Endpoint ID is not specified.” If I try to add the “?options=endpoint%3D”, password authentication fails. This is the same situation for the other options in this document: Connection errors - Neon Docs

Can you kindly assist? Thanks!

Error connecting to postgres database