knexfile.cloudgov.js
const VCAP_SERVICES_JSON = JSON.parse(process.env.VCAP_SERVICES);
module.exports = {
production: {
client: "postgresql",
connection: {
host: VCAP_SERVICES_JSON["aws-rds"][0]["credentials"]["host"],
user: VCAP_SERVICES_JSON["aws-rds"][0]["credentials"]["username"],
password: VCAP_SERVICES_JSON["aws-rds"][0]["credentials"]["password"],
database: VCAP_SERVICES_JSON["aws-rds"][0]["credentials"]["db_name"],
port: 5432,
ssl: true,
},
pool: {
min: 2,
max: 10,
},
migrations: {
tableName: "knex_migrations",
},
},
};