我正在尝试连接到我在 Heroku 中设置的 PostgreSQL 数据库。
const { Sequelize, DataTypes, Model } = require("sequelize");
// DB Configuration
const sequelize = new Sequelize({
database: "[wont'd show db]",
username: "[won't show username]",
password: "[won't show password]",
host: "ec2-54-221-195-148.compute-1.amazonaws.com",
port: 5432,
dialect: "postgres",
dialectOptions: {
ssl: true,
},
});
这就是我得到的输出：
SequelizeConnectionError：自签名证书
这是由于node-postgres版本 8 中的（意外）重大更改（请参阅此 GitHub 问题）。
解决方案是传递rejectUnauthorized: false给sequelize连接参数，如GitHub 用户 jsanta 所述：
const sequelize = new Sequelize({
database: "[wont'd show db]",
username: "[won't show username]",
password: "[won't show password]",
host: "ec2-54-221-195-148.compute-1.amazonaws.com",
port: 5432,
dialect: "postgres",
dialectOptions: {
ssl: {
require: true,
rejectUnauthorized: false // <<<<<<< YOU NEED THIS
}
},
});
它对我有用（在 sequelize config.json 文件上）：
"dialect": "postgres",
"dialectOptions": {
"ssl": {
"require": true,
"rejectUnauthorized": false
}
}
这对我有用，在config.json文件中
"development": {
"username": "dummy",
"password": "dummy",
"database": "dummy",
"host": "dummy",
"dialect": "postgres",
"dialectOptions":{
"ssl": {
"require": true,
"rejectUnauthorized": false
}
}
}
在您的代码中添加以下内容...
dbRDS=false