/
knexfile.js
46 lines (43 loc) · 1.03 KB
/
knexfile.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
// Comment this line in for Localhost
// require('dotenv').load();
//
module.exports = {
development: {
client: 'postgres',
connection: {
host : process.env.DB_HOST,
// host : process.env.DATABASE_URL || process.env.DB_HOST,
user : process.env.DB_USER,
password : process.env.DB_PASS,
database : process.env.DB_NAME || 'midterm',
port : process.env.DB_PORT,
ssl : process.env.DB_SSL
},
migrations: {
directory: './db/migrations',
tableName: 'migrations'
},
seeds: {
directory: './db/seeds'
},
pool: { min:0, max: 10 }
},
production: {
client: 'postgres',
connection: {
host : process.env.DB_HOST,
user : process.env.DB_USER,
password : process.env.DB_PASS,
database : process.env.DB_NAME || 'midterm',
port : process.env.DB_PORT,
ssl : process.env.DB_SSL
},
pool: {
min: 2,
max: 10
},
migrations: {
tableName: 'migrations'
}
}
};