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?
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 optionsocket_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?