S

Supabase•2w ago

hustler

Urgent Connection Timeout (Errno 10060) on Direct PostgreSQL Connection

I am unable to connect to my PostgreSQL database host url from my local Windows development machine. The connection attempt consistently results in a TimeoutError (Errno 10060)TimeoutError (Errno 10060) during the Uvicorn server startup (via SQLAlchemy/AsyncPG).

Full Context & Troubleshooting Steps Taken:

1. **DNS Resolution Issue:** My local machine is resolving the hostname only to the IPv6 address, and the connection attempts are timing out:
   • Ping Result: Pinging db... [2406:da12:b78:xxxx:xxxx:xxxx:xxxx:xxxx]Pinging db... [2406:da12:b78:xxxx:xxxx:xxxx:xxxx:xxxx] and showing Request timed out.Request timed out.
   • Telnet/Network Test Result: Could not open connection to the host, on port 5432: Connect failedCould not open connection to the host, on port 5432: Connect failed
2. Supabase Console Warning: My console explicitly shows a warning regarding compatibility: "Not IPv4 compatible. Use Session Pooler or purchase IPv4 add-on."
3. **Local Environment Confirmation:**
   • Windows Firewall is disabled.
   • I have tried using both the direct hostname and attempting to use the IPv4 address (but was unable to retrieve a working IPv4 A record from public DNS).
   • The problem persists and appears to be a network routing issue related to my local network's inability to connect via the provided direct host/port, likely due to the lack of a working IPv4 path.

How can I locate the correct, current Pooler (PgBouncer) connection URI (Host and Port) for this project? PLEASE HELP URGENT