TypeORM cannot connect to Remote Heroku Postgress Database

[celeroncoder]

Describe the bug
While connecting to the Heroku Postgres server the connection is refused with an error that SSL is not configured and if SSL: true in config the error is self-signed certificate`.

To Reproduce
Steps to reproduce the behavior:

1. Go to the root of the project
2. Run npm run start:prod
3. Wait for the nest application to be initialized.
4. See the error.

Expected behavior
The Server must connect to the Postgres DB with no errors.

Screenshots
If applicable, add screenshots to help explain your problem.

Additional context
Most probably the reason is that the Postgress database hosted on Heroku is configured with ssl-only: true.