我使用pg 7.4.2 npm软件包。
我的数据库升级到10.2后似乎无法连接。
要清楚的是,我已经连续6个月没有问题地使用相同的连接字符串,该连接字符串具有?ssl = true附加到它。
$ b $ AssertionError [ERR_ASSERTION]:false == true 位于Object.exports.connect(_tls_wrap.js:1099:3)位于Socket。< anonymous> (/home/e/express/testpg/node_modules/pg/lib/connection.js:94:23)在Object.onceWrapper(events.js:219:13)在Socket.emit( at Socket.emit(domain.js:421:20) at addChunk(_stream_readable.js:269:12) at readableAddChunk(_stream_readable.js :256:11) at Socket.Readable.push(_stream_readable.js:213:10) at TCP.onread(net.js:598:20) $ c $现在我正在对完整的postgres连接字符串进行硬编码,所以env变量没有问题。 $ b $ <$ p b我尝试在连接字符串的末尾添加/删除?ssl = true,并在构造函数中添加/删除ssl:true。我也尝试过和没有承诺。同样的错误,无论本地和部署到heroku上。
进口:
import {Pool,Client} from'pg'方法1:
let pool = new Pool({ connectionString:csnew, ssl:true }) pool.connect()。then(client => { console.log('connected')}) .catch(e => { console.log(e)})方法2:
let pgclient = new Client({ connectionString:csnew, ssl:true )) pgclient.connect()。then(()=> { console.log('connected')})。catch(e => { console.log (e)})解决方案
v7.4.2打破了对SSL的支持。 这是未解决的问题。
您必须严格使用v7.4.1才能解决问题。
更新
7.4.3版解决了问题。
It seems after my database was upgraded to 10.2 I'm unable to connect.
I'm using the pg 7.4.2 npm package.
To be clear, I have been connecting without issue for 6 months using the same connection string which had ?ssl=true appended to it.
I get this error connecting via Pool or Client.
AssertionError [ERR_ASSERTION]: false == true at Object.exports.connect (_tls_wrap.js:1099:3) at Socket.<anonymous> (/home/e/express/testpg/node_modules/pg/lib/connection.js:94:23) at Object.onceWrapper (events.js:219:13) at Socket.emit (events.js:127:13) at Socket.emit (domain.js:421:20) at addChunk (_stream_readable.js:269:12) at readableAddChunk (_stream_readable.js:256:11) at Socket.Readable.push (_stream_readable.js:213:10) at TCP.onread (net.js:598:20)I'm now hardcoding the full postgres connection string so there is no issue with env variables.
I've tried adding/removing ?ssl=true to the end of the connection string and adding/removing ssl:true from the constructor. I've also tried with and without promises. Same error no matter what on both local and deployed to heroku.
imports:
import { Pool, Client } from 'pg'method 1:
let pool = new Pool({ connectionString: csnew, ssl: true }) pool.connect().then( client => { console.log('connected') }) .catch(e=> { console.log(e) })method 2:
let pgclient = new Client({ connectionString: csnew, ssl: true }) pgclient.connect().then( () => { console.log('connected') }).catch(e=> { console.log(e) })解决方案
That's because v7.4.2 broke its SSL support. Here's the open issue.
You need to use strictly v7.4.1 till the issue is resolved.
UPDATE
Version 7.4.3 fixed the issue.
更多推荐
连接到nodejs中的heroku postgress数据库时出错
发布评论