node.js ECONNRESET error after a while idle

Question

I'm using node.js and PostgreSQL as my database. I use the below code to connect my database.

 const pool = new pg.Pool(config);
pool.connect((err) => {
  if (err) {
    console.log(err);
    return;
  }
  console.log('connected to database', config.database);
});

and this is the config codes:

const crypto = require('crypto').randomBytes(256).toString('hex');
module.exports = {
    host:'192.168.87.8',
    user: 'fjavadpour',
    database: 'fj_correspondence',
    password: 'Fariba321',
    port: 5432,
    max: 200,
    secret:crypto,
    idleTimeoutMillis: 72000000
};

but my database connection will crash and stop after being idle about one hour. how can I fix it?

@AnshulVerma yes! I can connect to the host at first but it crashes and get ECONNRESET error when I don't contact to the database after about an hour — fariba.j
– fariba.j, Commented Mar 28, 2018 at 8:14

Anshul Verma · Accepted Answer · 2018-03-28 08:25:57Z

5

Can you try adding keepAlive:true to your config and then check?

answered Mar 28, 2018 at 8:25

Anshul Verma

1,1011 gold badge10 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

node.js ECONNRESET error after a while idle

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related