Unable to connect to Supabase DB
Hi, new to Supabase here. Just created a free account, organization and project, and created some public tables, but having issues/difficulty connecting to it via various means.
host: db.zxyvbjmatrsuvcyyniqi.supabase.co
port: 5432
database: postgres
user: postgres
python code:
import psycopg2
try:
conn = psycopg2.connect(
host="db.zxyvbjmatrsuvcyyniqi.supabase.co",
port="5432",
database="postgres",
user="postgres",
password="*"
)
print("Connection successful!")
conn.close()
except Exception as e:
print(f"Connection failed: {e}")
When I tried to connect via python/psycopg2 running on my local windows 10 machine with the above parameters, got this error - "Connection failed: could not translate host name "db.zxyvbjmatrsuvcyyniqi.supabase.co" to address: No such host is known."
host: db.zxyvbjmatrsuvcyyniqi.supabase.co
port: 5432
database: postgres
user: postgres
python code:
import psycopg2
try:
conn = psycopg2.connect(
host="db.zxyvbjmatrsuvcyyniqi.supabase.co",
port="5432",
database="postgres",
user="postgres",
password="*"
)
print("Connection successful!")
conn.close()
except Exception as e:
print(f"Connection failed: {e}")
When I tried to connect via python/psycopg2 running on my local windows 10 machine with the above parameters, got this error - "Connection failed: could not translate host name "db.zxyvbjmatrsuvcyyniqi.supabase.co" to address: No such host is known."
