pg-native error, certificate could not be obtained, no SSL error reported

Hi there,

There are a few things that I could suggest here:

1. Make sure your connection string is properly configured to use SSL. You might want to include sslmode and other related options:

   const conString = "postgres://username:password@host:5432/dbname?sslmode=require";
   const client = new pg.native.Client(conString); client.connectSync();
   

2. Sometimes, the issue might be related to an outdated version of pg-native or the underlying libpq library. Update them to the latest stable version if they’re not already updated.

3. You may need to include the AWS RDS SSL root certificate in your connection configuration. You can download the RDS root certificate from the Amazon documentation.

   Here is an example of how you might include it in your connection:

   const conString = "postgres://username:password@host:5432/dbname?ssl=true&sslmode=require&sslrootcert=path/to/rds-combined-ca-bundle.pem";
   const client = new pg.native.Client(conString);
   client.connectSync();
   

If this still does not work, can you share the Node.js code snippet that you are using to establish the connection?

Alternatively, I could suggest using a Managed Postgres Database with DigitalOcean instead of an AWS RDS instance. This would also benefit the speed of your application as it will reduce the network latency for every single database connection that your application will make.

Best,

Bobby