postgres_fdw cannot connect to external postgres on free tier

[DevKILC]

When I try to generate a foreign table, I get a '504 Gateway Time-out' error and cannot retrieve the data. However, when I test it locally or with a self-hosted database (not using Supabase), it works fine.