I’m currently experiencing a connection issue with my Neon PostgreSQL instance. Since this morning, my application is failing to connect to the database with the following error:
(psycopg2.OperationalError) could not translate host name "ep-shy-grass-a42wchrp-pooler.us-east-1.aws.neon.tech" to address: No such host is known.
What I’ve Tried
Verified the connection string from the Neon dashboard – no typos found.
Attempted to remove the -pooler suffix and connect directly to ep-shy-grass-a42wchrp.us-east-1.aws.neon.tech, but still failed.
Upgraded psycopg2 to the latest version.
My internet connection is stable, and other external services are reachable.
Is there a known issue affecting this region or host? Or has there been a recent change in host naming or DNS setup that could be affecting resolution?
Would appreciate any guidance on how to restore connectivity.
I’m not sure about your problem, In my case i was having DNS resolution issue.
If you are having DNS issue, check it by running nslookup. In your terminal run this commands -
nslookup ep-cool-darkness-a1b2c3d4.ap-southeast-1.aws.neon.tech [your DB Host]
server can not find ep-cool-darkness-a1b2c3d4.ap-southeast-1.aws.neon.tech: REFUSED
[If you see the above message or similar message then try connection with Google DNS]
nslookup ep-cool-darkness-a1b2c3d4.ap-southeast-1.aws.neon.tech 8.8.8.8
Server: dns.google
Address: 8.8.8.8
Non-authoritative answer:
Name: ap-southeast-1.aws.neon.tech
Addresses: 2600:1f18:240c:5421:acd1:6284:5a8a:d6f6
2600:1f18:240c:5419:4ecf:2a7c:cf52:31cf
2600:1f18:240c:543b:a8aa:14fb:d008:11k2
2600:1f18:240c:544d:621b:957c:81:5e8e
2600:1f18:240c:5454:82a4:8209:20f8:a5l1
2600:1f18:240c:540b:c14a:4d57:1251:230e
34.203.0.113.10
52.203.0.113.30
100.203.0.113.20
Aliases: ep-cool-darkness-a1b2c3d4.ap-southeast-1.aws.neon.tech
If you get the addresses that means you have DNS issue.
How I fixed my problem:
Changed my WiFi adapter from Automatic (DHCP) to Manual DNS :
[Cloudflare DNS] - More Private
IpV4
Preferred DNS: 1.1.1.1
Alternate DNS: 1.0.0.1
Ipv6
Preferred DNS: 2606:4700:4700::1111
Alternate DNS: 2606:4700:4700::1001
You can also use Google DNS
[Google DNS] - Less Private
Ipv4
Preferred DNS: 8.8.8.8
Alternate DNS: 8.8.4.4
Ipv6
Preferred DNS: 2001:4860:4860::8888
Alternate DNS: 2001:4860:4860::8844