DNS Resolution Issue with Supabase Database Host
Hi everyone,
I'm having trouble connecting to my Supabase database from my local machine using pg_dump. I keep getting a DNS resolution error for
my production database host.
What I'm trying to do:
Create a backup of my production database using pg_dump.
The Hostname:
db.tzebxchpjqbbspmrmblu.supabase.co
The Error:
pg_dump: error: could not translate host name "db.tzebxchpjqbbspmrmblu.supabase.co" to address: nodename nor servname provided, or
not known
What I've tried so far:
* ping db.tzebxchpjqbbspmrmblu.supabase.co (fails with "Unknown host")
* nslookup db.tzebxchpjqbbspmrmblu.supabase.co 8.8.8.8 (fails with ANSWER: 0)
* Double-checking the project reference ID, which seems correct.
* Using the connection pooler host (aws-0-us-east-1.pooler.supabase.com), which resolves, but then I get a password error.
I'm confident I have the right project ID and password. It seems like the db.tzebxchpjqbbspmrmblu.supabase.co DNS record might not
be active or pointing anywhere.
Has anyone encountered this before? Any ideas on what I can check?
Thanks in advance
4 Replies
You likely are not IPv6 compatible so need to use the session pooler.
You need to sort the password error. Maybe you have special characters in it?
The Supabase password requries 4 special chareacters... what isnt allowed?
If you use special characters then you have to URL encode them IF you are providing a full URL versus filling in a form. I don't think special chars are required for the password to the DB.
What is your exact error for the session pooler?
And when using that the user is of the form postgres.instanceId not just the user name postgres.
Gotcha. I just enabled ipv4 and im good, I had a "!" which was having issues in the terminal due to obvious reasons this is resolved thank you