S
Supabase•3y ago
thore

supabase-cli link hostname resolving error

Hi, I'm trying to setup a local dev supabase environment by following these steps https://github.com/supabase/supabase/discussions/6366#discussioncomment-3911475 but I can't the linking to work. I tried this command 
$ supabase link --project-ref khozjjlacisdfkzjvagh --debug
Error: failed to connect to host=db.khozjjlacisdfkzjvagh.supabase.co user=postgres database=postgres: hostname resolving error (lookup db.khozjjlacisdfkzjvagh.supabase.co on [fd00::de15:c8ff:fe2d:8910]:53: dial udp [fd00::de15:c8ff:fe2d:8910]:53: i/o timeout)
$ supabase link --project-ref khozjjlacisdfkzjvagh --debug
Error: failed to connect to host=db.khozjjlacisdfkzjvagh.supabase.co user=postgres database=postgres: hostname resolving error (lookup db.khozjjlacisdfkzjvagh.supabase.co on [fd00::de15:c8ff:fe2d:8910]:53: dial udp [fd00::de15:c8ff:fe2d:8910]:53: i/o timeout)
Debug output: See attachment. and I am getting the mentioned error message. I then copied the connection string from the dashboard and tried pqsql and it works: 
$ psql -h db.khozjjlacisdfkzjvagh.supabase.co -p 5432 -d postgres -U postgres
Password for user postgres: 
psql (14.5 (Homebrew), server 14.1)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

postgres=>  \dt+
                                        List of relations
 Schema | Name | Type  |     Owner      | Persistence | Access method |    Size    | Description 
--------+------+-------+----------------+-------------+---------------+------------+-------------
 public | test | table | supabase_admin | permanent   | heap          | 8192 bytes | test
(1 row)

postgres=> 
$ psql -h db.khozjjlacisdfkzjvagh.supabase.co -p 5432 -d postgres -U postgres
Password for user postgres: 
psql (14.5 (Homebrew), server 14.1)
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits: 256, compression: off)
Type "help" for help.

postgres=>  \dt+
                                        List of relations
 Schema | Name | Type  |     Owner      | Persistence | Access method |    Size    | Description 
--------+------+-------+----------------+-------------+---------------+------------+-------------
 public | test | table | supabase_admin | permanent   | heap          | 8192 bytes | test
(1 row)

postgres=>
I am using the newest version of the supabase-cli and macOS 12.6.1. 
$ brew info supabase
==> supabase/tap/supabase: stable 1.11.7
$ brew info supabase
==> supabase/tap/supabase: stable 1.11.7
Does anybody know how to resolve this? Best Thore
GitHub
How does local development work? · Discussion #6366 · supabase/supa...
Before writing what could seem to be a rant I must thank you for building this extremely useful tool. It is truly amazing. I have read https://supabase.com/docs/guides/local-development a few times...

debug.txt

2 Replies
thore
thoreOP•3y ago
Nevermind, it seems to be resolved now.
silentworks
silentworks•3y ago
How was it resolved?

Did you find this page helpful?