I cannot access my render-hosted Postgres database from a background worker.
This is the error when testing via the shell:
$ psql --host=dpg-abc psql: could not translate host name "dpg-abc" to address: Name or service not known
Note that if I execute the same command from my web service, everything is fine:
$ psql --host=dpg-abc Password for user render:
I can’t find anything in the docs to indicate that render hosted databases cannot be accessed from background workers. Have I missed something? Currently the database access control is open to the world so I don’t think it relates to this - and if I use the external connection string within my background worker instead, everything is fine - but this isn’t ideal for production.