celeroncoder / notary-API

Notes App with NestJS-Typescript, MongoDB.
MIT License
2 stars 1 forks source link

TypeORM cannot connect to Remote Heroku Postgress Database #36

Open celeroncoder opened 2 years ago

celeroncoder commented 2 years ago

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 isself-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.