安装驱动
建议使用pg-pool,但要同时安装pg与pg-pool
cnpm install pg pg-pool --save
编写模块
/**postgres.js*/
const Pool = require(‘pg-pool‘);
const config = {
user: ‘postgres_user‘,
password: ‘postgres_password‘,
host: ‘postgres_ip‘,
port: 5432,
database: ‘Haikou_vegetables_project‘,
// ssl: true
};
const pool = new Pool(config);
exports.query = (SQL, value) =>{
return new Promise((resolve, reject) => {
pool.connect((err,client) => {
if(err) reject(err);
client.query(SQL, value, (err, res) => {
// client操作完后建议手动进行释放
client.release();
if(err) reject(err);
resolve(res);
});
});
});
};
此处注意client.release的手动释放操作。因为options中如果不设置poolSize或max&