https://supabase.com/ logo
Powered by
#help
Title
# help
o

Ox

09/02/2021, 8:32 AM
trying to connect to a supabase db via pgadmin but im getting this error:
Copy code
Unable to connect to server:

could not connect to server: Connection refused
Is the server running on host "db.asdasdasdasdasd.supabase.co" (XX.XX.XXX.XXX) and accepting
TCP/IP connections on port 5432
i tried connecting via ssl using an crt file as well as via password. both gave the same response. i tried looking it up and all the answers say to configure the config file for the postgres server, but im not sure how to do that on supabase
j

jason-lynx

09/02/2021, 9:18 AM
is the port definitely 5432? some time back i randomly encountered it because one of the test instances i created turned out to be on 6543 as well
o

Ox

09/02/2021, 9:19 AM
this is what supabase shows
is there any other place i should check?
under the "Database" tab in the settings is where this is
j

jason-lynx

09/02/2021, 10:16 AM
yeah that looks right
im also using pgadmin and connecting without issues so a this is unusual
what does your pgadmin connection window look like?
w

wario

10/05/2021, 8:37 AM
did you ever figure this out? I'm seeing the same message
j

jason-lynx

10/05/2021, 8:55 AM
do you have a screenshot of your connection window?
yeah looks the same - only thing i can think of is to double-check the host name + port to make sure they're definitely right
s

Seb Toombs

10/06/2021, 4:00 AM
Just came across this too. Supabase dashboard shows port 5432, but 6543 works instead. Thanks for the tip @User !
j

jason-lynx

10/06/2021, 4:07 AM
oh interesting, so it's a display bug - worth creating a github issue to let the team know! @User you can try and see if it works for you
Powered by