Setting up Postgres on Heroku

setup-postgres-on-heroku.txt

Create Heroku App
  -heroku create

Rename Heroku App
  -heroku apps:rename <new-name>

Create Heroku Postgres DB
  -heroku addons:create heroku-postgresql:hobby-dev

Get DB Credentials
  -heroku pg:credentials:url

Update .env File
  -PROD_MIGRATION_DB_HOST=<host-name>
  -PROD_MIGRATION_DB_PORT=<port>
  -PROD_MIGRATION_DB_NAME=<db-name>
  -PROD_MIGRATION_DB_USER=<db-user>
  -PROD_MIGRATION_DB_PASS=<db-password>

Add Prod Postgrator Config (if not already created)
  require('dotenv').config();

  module.exports = {
    "migrationDirectory": "migrations",
    "driver": "pg",
    "host": process.env.PROD_MIGRATION_DB_HOST,
    "port": process.env.PROD_MIGRATION_DB_PORT,
    "database": process.env.PROD_MIGRATION_DB_NAME,
    "username": process.env.PROD_MIGRATION_DB_USER,
    "password": process.env.PROD_MIGRATION_DB_PASS,
    "ssl": true
  }

Update NPM Scripts
"migrate-production": "postgrator --config postgrator-production-config.js",
"predeploy": "npm audit && npm run migrate-production"

Extra Credit
  -Add dotenv package to create-react-app
  -Create .env file
  -prefix all env vars with REACT_APP
  -require('dotenv').config() inside of Index.js

heyo,

Maybe you didnt want to add it, or solved it a different way, but adding something like

DB_URL: process.env.DATABASE_URL to the server-side config file

or using it directly in the server.js file, to connect o knex

Yea, I have a function inside of my config.js file that sets the DB_URL based of the NODE_ENV