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 ip to the 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 (typescript):

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

dotenv._config_();

export const _pool_ = new pg._Pool_({
  connectionString: process.env.DATABASE_URL,
  connectionTimeoutMillis: 5000,
  ssl:
    process_.env.ENVIRONMENT !== 'local'
      ? {
          rejectUnauthorized: true,
          ca: _Buffer_._from_(
            _process_.env.DATABASE_CRT as string,
            'base64',
          )._toString_('utf-8'),
        }      : undefined,
});

I pass the DATABASE_CRT and the DATABASE_URL via secrets -> env variables.

I base64 encoded the DATABASE_CRT.

I also created a small script that I ran in the pod with the DATABASE_CRT in-lined, also was timing out… This same code worked locally

I am using the VPC connection string as the DATABASE_URL, and the ca-certificate (I base64 encoded and placed in my secret) downloaded from the managed postgres page.

I was able to hit the database via telnet from the pod ie. curl -v telnet://<db-host>:<db-port>

Any advice?