Hi Dimitri,
Per PostgreSQL | Render Docs ;
To use the internal connection, the service and database need to be in the same account/team and region.
Since the database is functional because it works via the External URL, it’s most likely that one or both of those pre-requisites are not the case between the database and the Web Service, Background Worker, etc., app trying to access it.