0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

Supabaseの無料枠で直接接続するのはIPv4では無理かもしれない?

Posted at

Supabaseでpsqlの接続を行おうとしました。が、うまくいきません。

$ psql -h db.xxxxxxxxxxxxxxxx.supabase.co -p 5432 -d postgres -U postgres
psql: error: could not translate host name "db.xxxxxxxxxxxxxxxx.supabase.co" to address: nodename nor servname provided, or not known

nslookupをしても失敗します。

$ nslookup  db.xxxxxxxxxxxxxxxx.supabase.co
Server:		8.8.8.8
Address:	8.8.8.8#53

Non-authoritative answer:
*** Can't find db.xxxxxxxxxxxxxxxx.supabase.co: No answer

v6で引いてみるとちゃんと引けました。

$ nslookup -type=AAAA db.xxxxxxxxxxxxxxxx.supabase.co
Server:		8.8.8.8
Address:	8.8.8.8#53

Non-authoritative answer:
db.dxcpruqasddaclemiecy.supabase.co	has AAAA address 2406:da14:xxxx:xxxxx:xxxx:xxxx:xxxx:xxxx

Authoritative answers can be found from:

で、psqlでこのv6アドレスを指定しましたが駄目でした。

$ psql -h '2406:da14:xxxx:xxxxx:xxxx:xxxx:xxxx:xxxx' -p 5432 -d postgres -U postgres
psql: error: connection to server at "2406:da14:xxxx:xxxxx:xxxx:xxxx:xxxx:xxxx", port 5432 failed: No route to host
	Is the server running on that host and accepting TCP/IP connections?

IPv6に詳しい方助けてください😂

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?