Running Adonis migrations before deployment on Heroku

[jlemein]

I am having a problem running migrations before a deployment on Heroku, for my Adonis application.
My Procfile is as follows:

release: cd build && node ace migration:run --force
web: cd build && npm ci --omit="dev" && node bin/server.js

My database.ts file looks as follows:

import env from '#start/env'
import { defineConfig } from '@adonisjs/lucid'

const dbConfig = defineConfig({
  connection: 'postgres',
  connections: {
    postgres: {
      client: 'pg',
      connection: {
        connectionString: env.get('DATABASE_URL'),
        ssl: {
          rejectUnauthorized: true
        },
      },
      migrations: {
        naturalSort: true,
        paths: ['database/migrations'],
        disableRollbacksInProduction: true
      },
    },
  },
})

export default dbConfig

The error I am getting is
Error: unable to get local issuer certificate

It looks like it cannot create a secure connection with the database. I am running the application on one of the *.herokuapp.com domains, so I would assume SSL is configured.

I would like my migrations to run before deployment. Is there somebody who has an idea why this doesn't work?

[jlemein]

I managed to solve the issue by adding an additional environment variable to my heroku app: heroku config:set NODE_EXTRA_CA_CERTS=/etc/ssl/certs/ca-certificates.crt