Closed
Description
If we take the example on the main page:
var pg = require('pg');
var conString = "postgres://username:password@localhost/database";
//this initializes a connection pool
//it will keep idle connections open for a (configurable) 30 seconds
//and set a limit of 10 (also configurable)
pg.connect(conString, function(err, client, done) {
if(err) {
return console.error('error fetching client from pool', err);
}
client.query('SELECT $1::int AS number', ['1'], function(err, result) {
//call `done()` to release the client back to the pool
done();
if(err) {
return console.error('error running query', err);
}
console.log(result.rows[0].number);
//output: 1
});
});And simply switch to Node.js 6.0.0, we are immediately getting an error:
error fetching client from pool { error: password authentication failed for user "postgres"
at Connection.parseE (D:\NodeJS\tests\node_modules\pg\lib\connection.js:539:11)
at Connection.parseMessage (D:\NodeJS\tests\node_modules\pg\lib\connection.js:366:17)
at Socket.<anonymous> (D:\NodeJS\tests\node_modules\pg\lib\connection.js:105:22)
at emitOne (events.js:96:13)
at Socket.emit (events.js:188:7)
at readableAddChunk (_stream_readable.js:172:18)
at Socket.Readable.push (_stream_readable.js:130:10)
at TCP.onread (net.js:535:20)
name: 'error',
length: 115,
severity: 'FATAL',
code: '28P01',
detail: undefined,
hint: undefined,
position: undefined,
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'src\\backend\\libpq\\auth.c',
line: '304',
routine: 'auth_failed' }
i.e. authentication doesn't work under the newly released Node.js 6.0.0
My Test environment:
- Windows 10, 64-bit
- Node.js 6.0.0 (released)