Can't connect from my K8s Cluster to my Managed Database

Hi,

I am currently running a managed postgres database and a kubernetes cluster in digital ocean.

These are both running in the same VPC

I have added the kubernetes cluster to the trusted sources of the managed database.

I am able to connect to the database from my local machine if I add my local to my trusted sources.

However, I am seeing that my connection keeps timing out when trying to connect to the database in one of my k8s pods.

My code looks like this:

import dotenv from 'dotenv';
import pg from 'pg';

dotenv._config_();

export const _pool_ = new pg._Pool_({
  connectionString: _process_.env.DATABASE_URL,
  ssl:
    _process_.env.ENVIRONMENT !== 'local'
      ? {
          rejectUnauthorized: true,
          ca: _process_.env.DATABASE_CRT,
        }      : undefined,
});

I pass the DATABASE_CRT and the DATABASE_URL via secrets. I tried base64 encoded and decoding the DATABASE_CRT but I was still unable to connect. I also created a small script that I ran in the pod with the DATABASE_CRT in-lined, also was timing out.

I am using the VPC connection string as the DATABASE_URL, and the ca-certificate downloaded from the managed postgres page.