Error: Connection terminated unexpectedly how can i resolve?

1

Hi all,
I have this database.js code :
require(‘dotenv’).config();
const { Pool } = require(‘pg’);

// Configurazione della connessione al database utilizzando variabili d’ambiente
const pool = new Pool({
user: process.env.DB_USER,
host: process.env.DB_HOST,
database: process.env.DB_NAME,
password: process.env.DB_PASSWORD,
port: process.env.DB_PORT,
ssl: {
rejectUnauthorized: false
} // 5 secondi di timeout// Porta di default di PostgreSQL
});
console.log(‘DB_USER:’, process.env.DB_USER);
console.log(‘DB_HOST:’, process.env.DB_HOST);
console.log(‘DB_NAME:’, process.env.DB_NAME);
console.log(‘DB_PASSWORD:’, process.env.DB_PASSWORD);
console.log(‘DB_PORT:’, process.env.DB_PORT);

pool.connect((err, client, release) => {
if (err) {
console.error(‘Errore di connessione al database:’, err.stack);
} else {
console.log(‘Connessione a Postgres riuscita!’);
}

// Rilascia il client subito dopo aver verificato la connessione
if (client) {
    release();
}

});
and in the DB_HOST i have the external url of the postgres database on render.

How can I resolve the problem
Error: Connection terminated unexpectedly at Connection. (/opt/render/project/src/node_modules/pg/lib/client.js:131:73) at Object.onceWrapper (node:events:638:28) at Connection.emit (node:events:524:28) at Socket. (/opt/render/project/src/node_modules/pg/lib/connection.js:62:12) at Socket.emit (node:events:536:35) at TCP. (node:net:350:12)
When I try to deploy my web service?

2

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.