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:
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 notbe active or pointing anywhere.Has anyone encountered this before? Any ideas on what I can check?Thanks in advance
