Managed Database password authentication failed for user

Hi,

I have been trying to connect to my managed database server through node. I am using pg-promise library with the following code which makes use of sslrootcert:

"use strict";
const fs = require('fs')
const pgPromise = require("pg-promise");
const {ConnectionString} = require('connection-string');
const path = require('path');

var options = {
// Initialization Options
};
let pgp = pgPromise(options);
const dotenv = require('dotenv');
dotenv.config();

const a = new ConnectionString('postgresql://username:password@server:port/mydb?sslmode=require');

var cert= fs.readFileSync(__dirname + '/certs/ca-certificate.crt', 'utf8')
a.setDefaults({   
    params: {
        
        sslrootcert : cert

    }
    });

let dbpool = pgp(a);
module.exports = { dbpool };

However, when I try to connect, I am getting:

error: password authentication failed for user "username"

Now, I am definite I am using the correct user and password. I have added my user and database to “Users and Databases”.

I have added my home ip to trusted sources.

I am using the connection string provided in “Overview” “Connection details”

I am not seeing any connection attempts in “Recent Logs”

Is there anything else I am overlooking? Have I passed the SSL check?