not - connected { Error: self signed certificate in certificate chain while connecting to postgres

Question

Hi,

I have created a postgres database. I have integrated my backend which is in nodejs with postgres.
When i deploy my code on server ,I get below error

not - connected { Error: self signed certificate in certificate chain
..
Pls guide.

Thanks
Swati

Answer 1

bobbyiliev February 28, 2021

Hi there,

Is it a Managed PostgreSQL cluster that you are using or is it a PostgreSQL service installed on a Droplet?

Note that with the Managed clusters, you need to set the sslmode to require.

Regards,
Bobby

Reply Report

Answer 2

scorsi April 15, 2021

With TypeORM I have to set the options to:

{
  // other settings
  ssl: {
    rejectUnauthorized: false
  }
}

Reply Report

Related