Worker/Hyperdrive fails to connect to publicly-accessible PG DB unless I use `--remote`

This is a weird one. I have a Hyperdrive binding to a publicly-accessible Postgres DB (as in, it's not behind an IP whitelist). I can connect to the DB just fine from a DB client running on my machine. But when I run my Worker locally, I get a PG connection error:
FATAL: no pg_hba.conf entry for host "<ip>", user ...
FATAL: no pg_hba.conf entry for host "<ip>", user ...
This error goes away if I use the --remote flag. Any idea what this could be?
2 Replies
kian
kian11mo ago
Is the user your Worker uses the same as your DB client?
Mitya
Mitya11mo ago
Yes - and it's the same credentials I set up the Hyperdrive with. It works with --remote but not without.
Want results from more Discord servers?
Add your server