Can't connect to ipv6 database

[Badestrand]

Hi!

I am new to Supabase as well as new to explicitly working with IPv6 addresses.

I just set up my first database and it has the host db.yabmpwszdvnvihxxvejj.supabase.co or IPv6 address 2a05:d014:1c06:5f12:9755:aee3:c23e:c8a3, and no ipv4 address.

I can't get node-postgres to connect to the database though and even on command line it doesn't work.

(connecting via hostname:)

> PGPASSWORD='...' psql -h "db.yabmpwszdvnvihxxvejj.supabase.co" -p 5432 -U postgres -d postgres

psql: error: could not translate host name "db.yabmpwszdvnvihxxvejj.supabase.co" to address: nodename nor servname provided, or not known

(connecting via ip6 address:)

> PGPASSWORD='...' psql -h "2a05:d014:1c06:5f12:9755:aee3:c23e:c8a3" -p 5432 -U postgres -d postgres

psql: error: connection to server at "2a05:d014:1c06:5f12:9755:aee3:c23e:c8a3", port 5432 failed: No route to host
	Is the server running on that host and accepting TCP/IP connections?

-- or when executing on a server of mine, I get the following

psql: error: could not connect to server: Network is unreachable
	Is the server running on host "2a05:d014:1c06:5f12:9755:aee3:c23e:c8a3" and accepting
	TCP/IP connections on port 5432?

Any idea what I need to do to be able to connect to the database?

[GaryAustin1]

Go to your dashboard connection tab at top and get session mode (5432) for supavisor. That is IPv4 compatible.
Otherwise it is up to you to get your computer,OS, router and provider to support IPv6.

[kh0na]

I Love You. been scratching my head for hours. cheers 🍻

[Badestrand]

Okay yes, the AWS session pooler connection works, thanks!