knexfile.ts
import config from './config';
require('dotenv').config();
module.exports = {
development: {
debug: true,
client: 'postgresql',
connection: {
database: process.env.DB_NAME,
user: process.env.DB_USERNAME,
password: process.env.DB_PASSWORD
},
pool: {
min: 2,
max: 10
},
migrations: {
tableName: 'knex_migrations'
}
},
testing: {
client: 'postgresql',
connection: {
database: config.db.name,
user: config.db.username,
password: config.db.password
},
pool: {
min: 2,
max: 10
},
migrations: {
tableName: 'knex_migrations'
}
},
staging: {
client: 'postgresql',
connection: {
database: config.db.name,
user: config.db.username,
password: config.db.password
},
pool: {
min: 2,
max: 10
},
migrations: {
tableName: 'knex_migrations'
}
},
production: {
client: 'postgresql',
connection: {
database: process.env.PROD_DB_NAME,
user: process.env.PROD_DB_USERNAME,
password: process.env.PROD_DB_PASSWORD
},
pool: {
min: 2,
max: 10
},
migrations: {
tableName: 'knex_migrations'
}
}
};