pg_net http post request fails with numeric IP address
🟢SQL
When running below SQL code on Supabase cloud using the domain of the Postman Echo (commented line) server, it works (i.e. I see the Postman Echo response in the _http_response table.
But it fails, i.e. I get a timeout in _http_response showing the server was never reached, when I change to use the IP address instead (code as shown). Note that I have a Host header to make it work with numeric IP. And I know that works since when I do the same call from the Postman app on my local Mac with numeric IP, it works. I was trying to reach my own server with numeric IP and that failed as well with timeout response, while that one works from local Postman app as well. What is wrong? Do somehow outbound http calls to numeric IP not go out of Supabase cloud? In all cases the http_request_queue table is empty showing the requests should have been sent. Help appreciated; you can easily replicate below in the SQL editor of your own Supabase project. I'm on Postgres 17, http 1.6, pg_net 0.19.5
But it fails, i.e. I get a timeout in _http_response showing the server was never reached, when I change to use the IP address instead (code as shown). Note that I have a Host header to make it work with numeric IP. And I know that works since when I do the same call from the Postman app on my local Mac with numeric IP, it works. I was trying to reach my own server with numeric IP and that failed as well with timeout response, while that one works from local Postman app as well. What is wrong? Do somehow outbound http calls to numeric IP not go out of Supabase cloud? In all cases the http_request_queue table is empty showing the requests should have been sent. Help appreciated; you can easily replicate below in the SQL editor of your own Supabase project. I'm on Postgres 17, http 1.6, pg_net 0.19.5
