I have problems connecting strapi to CockroachDB

I cannot seem to connect to the CockroachDb Database with strapi. I get this error which I don’t know how to fix and what to do about it.
As CockroachDb is a PostgreSql database, it should be supported.
I’ve also downloaded the .cert file and have made sure that it is recognized within the database.ts configurations.

I am trying to deploy Strapi to a Oracle Cloud service in order to have it running.

Here is the error that I receive when trying to connect to the database.

TypeError: Cannot read properties of null (reading '1')
    at Client_PG._parseVersion (C:\Users\user\Documents\Repos\project\node_modules\knex\lib\dialects\postgres\index.js:135:56)
    at Query.<anonymous> (C:\Users\user\Documents\Repos\project\node_modules\knex\lib\dialects\postgres\index.js:129:22)
    at Query.handleReadyForQuery (C:\Users\user\Documents\Repos\project\node_modules\pg\lib\query.js:142:14)
    at Client._handleReadyForQuery (C:\Users\user\Documents\Repos\project\node_modules\pg\lib\client.js:311:19)
    at Connection.emit (node:events:518:28)
    at Connection.emit (node:domain:488:12)
    at C:\Users\user\Documents\Repos\project\node_modules\pg\lib\connection.js:116:12
    at Parser.parse (C:\Users\user\Documents\Repos\project\node_modules\pg-protocol\src\parser.ts:103:9)
    at TLSSocket.<anonymous> (C:\Users\user\Documents\Repos\project\node_modules\pg-protocol\src\index.ts:7:48)
    at TLSSocket.emit (node:events:518:28)

This topic has been created from a Discord post (1298654957091684413) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord