Hi! I'm trying to set up a VPS with Postgres via docker compose and then bind it in a worker via Hyperdrive.
I have followed the instructions line by line except when setting up the public hostname: instead of localhost:5432 -> postgres:5432.
When the API calls the Hyperdrive returns 504 (Gateway Timeout) to the client. To make sure the DB is working, I have tried to access the database from the VPS console through postgres:5432 and it works fine.
Any suggestions?