Hi. I am new to supabase but not to postgres. Before anything else, I am just trying to connect to the database server using PgAdmin 4 from my desktop. Supabase says my information is as follows: host: db.bmxeffyhgbiecxebotez.supabase.co port: 5432 database: postgres user: postgres password: [I have it] (I'm using "Direct Connection)
Under "Authentication" I have no users set up, but I think the "postgres" user is the default, right? I've tried SSL configuration on and off. Nothing works.
When I do psql -h db.bmxeffyhgbiecxebotez.supabase.co -p 5432 -d postgres -U postgres
I get this error... psql: error: could not translate host name "db.bmxeffyhgbiecxebotez.supabase.co" to address: nodename nor servname provided, or not known
Supabase gives you the tools, documentation, and community that makes managing databases, authentication, and backend infrastructure a lot less overwhelming.