CODEWITHSUNDEEP
node.jspostgresqlherokutypeorm
Jonatha Rihan
Jonatha Rihan

Reputation: 89

Heroku Postgres Typeorm Migrations

I am trying to perform my migrations on the database provided by Heroku, but the following error appears:

Error during migration run:
Error: self signed certificate
    at TLSSocket.onConnectSecure (_tls_wrap.js:1501:34)
    at TLSSocket.emit (events.js:315:20)
    at TLSSocket._finishInit (_tls_wrap.js:936:8)
    at TLSWrap.ssl.onhandshakedone (_tls_wrap.js:710:12) {
  code: 'DEPTH_ZERO_SELF_SIGNED_CERT'
}

ormconfig.js

module.exports = {
  type: `${process.env.DATABASE_TYPE}`,
  host: `${process.env.DATABASE_HOST}`,
  port: `${process.env.DATABASE_PORT}`,
  username: `${process.env.DATABASE_USERNAME}`,
  password: `${process.env.DATABASE_PASSWORD}`,
  database: `${process.env.DATABASE_NAME}`,
  entities: [`${process.env.DATABASE_ENTITIES}`],
  migrations: [`${process.env.DATABASE_MIGRATIONS}`],
  cli: { migrationsDir: `${process.env.DATABASE_MIGRATIONS_DIR}` },
  extra: {
    ssl: true
  }
};

Upvotes: 1

Views: 1484

Answers (1)

Jonatha Rihan
Jonatha Rihan

Reputation: 89

module.exports = {
  type: `postgres`,
  url: `${process.env.DATABASE_URL}`,
  entities: [`${process.env.DATABASE_ENTITIES}`],
  migrations: [`${process.env.DATABASE_MIGRATIONS}`],
  cli: { migrationsDir: `${process.env.DATABASE_MIGRATIONS_DIR}` },
  extra: {
    ssl: {
      rejectUnauthorized: false,
    }
  }
};

Works fine!

Upvotes: 5

Related Questions