trying to connect to a supabase db via pgadmin but im gettin Supabase #help

trying to connect to a supabase db via pgadmin but...

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

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

09/02/2021, 9:19 AM

this is what supabase shows

09/02/2021, 9:19 AM

is there any other place i should check?

09/02/2021, 9:19 AM

under the "Database" tab in the settings is where this is

jason-lynx

09/02/2021, 10:16 AM

yeah that looks right

jason-lynx

09/02/2021, 10:16 AM

im also using pgadmin and connecting without issues so a this is unusual

jason-lynx

09/02/2021, 10:16 AM

what does your pgadmin connection window look like?

wario

10/05/2021, 8:37 AM

did you ever figure this out? I'm seeing the same message

jason-lynx

10/05/2021, 8:55 AM

do you have a screenshot of your connection window?

jason-lynx

10/06/2021, 1:50 AM

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

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 !

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

Previous Next