sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name

Hi there,
I deployed a website in my computer and tried to connect with Render database. The IP address of my computer is in Taiwan, and the IP address of the Render database is in Singapore. I set the External Database URL to psycopg2 to connect with the database, but got this error, sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) could not translate host name “dpg-ce7di802i3mre1kpkg20-a.singapore-postgresql.render.com” to address: nodename nor servname provided, or not known.
Hope you guys can help me figure out what was going on here, thx!

Hi @Chung_Han___Hsin,

It looks like the hostname might be incorrect there. Can you try specifying dpg-ce7di802i3mre1kpkg20-a.singapore-postgres.render.com and let me know if that works (Note the spelling of “postgres”)?

Yes, it works!!!
Thank you for your reply, you are my hero😂

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.