knexfile.js

// Update with your config settings.
/*eslint-disable*/
module.exports = {

  development: {
    client: 'pg',
    connection: 'postgres://localhost/stars',
    migrations: {
      directory: './db/migrations',
    },
    seeds: {
      directory: './db/seeds/dev',
    },
    useNullAsDefault: true,
  },
  testing: {
    client: 'pg',
    connection:{
      host: '127.0.0.1',
      user: 'postgres',
      password: '',
      database: 'postgres'
    } ,
    migrations: {
      directory: './db/migrations',
    },
    seeds: {
      directory: './db/seeds/testing',
    },
    useNullAsDefault: true,
  },
  production: {
    client: 'pg',
    connection: process.env.DATABASE_URL + "ssl=true",
    migrations: {
      directory: './db/migrations',
    },
    seeds: {
      directory: './db/seeds/production',
    },
    useNullAsDefault: true,
  }
};