How to make heroku play nice with sequelize.js + postgres?

Question

I'm most of the way there, has anyone gotten it to succesfully work? I only have the database working locally, after I git push heroku master the connection to the database fails.

Ferdinand Cruz · Accepted Answer · 2018-02-15 00:05:54Z

6

Add 'Heroku Postgres' either through the Heroku CLI or under your project's Resources tab. It should also give you a DATABASE_URL variable which you need for later.

Add pg module from Heroku. See the documentation here.

$ npm install --save --save-exact pg

Then, on the server, use the DATABASE_URL we just got.

const client = new Client({
  connectionString: process.env.DATABASE_URL,
  ssl: true,
});

client.connect();

Put "use_env_variable": "DATABASE_URL" on the config.json file under "production". Should look like
```
"production": {
    "use_env_variable": "DATABASE_URL"
    ...
}
```
Run migrations on Heroku. An option if you want to use sequelize-cli is:
```
$ npm install sequelize-cli --save
$ heroku run sequelize db:migrate
```

And it should work.

answered Feb 15, 2018 at 0:05

Ferdinand Cruz

761 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to make heroku play nice with sequelize.js + postgres?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related