Failed to connect using interval private network Postgres

[jsaied99]

I've set up a private network with PostgreSQL on both Fly.io and Railway.app, but I'm encountering issues when trying to connect Supabase to PostgreSQL via the internal network. The error message I receive is: [error] Postgrex.Protocol (#PID<0.2843.0>) failed to connect: ** (DBConnection.ConnectionError) tcp connect (postgres.*.internal:5432): non-existing domain - :nxdomain. Interestingly, when I switch to using the regular domain for the public network, the connection works flawlessly. I have verified that the internal network functions correctly with other services. To troubleshoot, I attempted to modify the database configuration by adding a socket option socket_options: [:inet6], yet the issue persists with the domain not being recognized. This is the only service I'm having trouble with when connecting through the private network. Given my limited knowledge of Elixir, I find it quite challenging to debug this issue further. Does anyone have any insights or suggestions?

[nicolas-geysse]

Same issue here !

[Hdnaye]

Hello @jsaied99, did you get it to work through the internal network ? I'm having the exact same problem

[jsaied99]

@Hdnaye and @nicolas-geysse . unfortunately I never got it to work and actually decided to switch to using regular PgBouncer. I believe this issue still persists and in my case, having the addresses public wasn't an option.

[nicolas-geysse]

@jsaied99 thanks for your anwser !
I wonder if that would lead to issues at some point...
https://github.com/orgs/supabase/discussions/17817

[abc3]

@hauleth this is likely an IPv6 issue and will probably be fixed by this #654

[nicolas-geysse]

We've tried with the updated version but still can't connect internally...
https://github.com/orgs/supabase/discussions/36995

[6ixfalls]

@abc3 Was #654 tested to work correctly? I'm still seeing the same issue, although different (Doesn't crash anymore, but repeatedly logs the following):

02:45:34.253 region=local [error] #PID<0.4927.0> (Postgrex.Notifications) failed to connect to Postgres: ** (DBConnection.ConnectionError) tcp connect (supabase.railway.internal:5432): non-existing domain - :nxdomain

Could there be another setting that needs to be configured for Postgrex to work properly?