Can't send HTTP requests to localhost from a trigger function about pg_net

[steve-chavez]

When trying to send a request from a trigger function, the request doesn't reach the server. In the _http_response table, the error message is:
Couldn't connect to server

Hm, this looks more of an infra issue since pg_net is reporting the error correctly.

This seems related supabase/supabase#9837

@HTMHell Could you try reaching your edge function with pgsql-http?

[pcnc]

This seems related supabase/supabase#9837

Yep, this is unfortunately due to localhost mapping to the Postgres container itself - to reach the Docker host (and all ports exposed on it), either host.docker.internal or 172.17.0.1 have to be used as the target hostname.

@HTMHell could you try using any of the above options to confirm that the http request connects as expected?

[HTMHell]

This seems related supabase/supabase#9837

Yep, this is unfortunately due to localhost mapping to the Postgres container itself - to reach the Docker host (and all ports exposed on it), either host.docker.internal or 172.17.0.1 have to be used as the target hostname.

@HTMHell could you try using any of the above options to confirm that the http request connects as expected?

Yup, that did the trick. Thank you!