How to create a pool object in javascript that can connect to a database backend using SSL?

Question

I followed a guide on how to create a Node JS backend on PostgreSQL and a ReactJS frontend, which is working well, see here for more.

The js pool object of the quide looks as follows:

const Pool = require('pg').Pool
const pool = new Pool({
  user: 'my_user',
  host: 'localhost',
  database: 'my_database',
  password: 'postgres',
  port: 5432,
});

I tried doing the same with a PostgreSQL Webserver using SSL encryption. This question is not tagged postgresql since the pool looks the same for mysql and other databases. It is also not tagged Linux since it should work the same on other OS.

How to create a pool object from the Pool class in javascript that can connect to a PostgreSQL backend using SSL?

questionto42 · Accepted Answer · 2021-09-11 10:23:15Z

0

You need to save the certificate, call it server-certificate.pem, in a place with a static path starting with / (~ for your user's home directory does not work). Therefore, you need to move it to a static place.

I copied the file to a newly created directory certificates, but that is of course up to you. You will need super user rights for this.

/etc/certificates/server-certificate.pem

You need to load fs and use it in the SSL part, see How to establish a secure connection (SSL) from a Node.js API to an AWS RDS.

const Pool = require('pg').Pool
const fs = require('fs');
const pool = new Pool({
  user: 'my_user',
  host: 'my_host',
  database: 'my_database',
  password: 'my_password',
  port: 22222,
  ssl: {
    ca: fs
      .readFileSync("/etc/certificates/server-certificate.pem")
      .toString()
  }
});

answered Sep 11, 2021 at 10:23

questionto42

9,9428 gold badges81 silver badges125 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to create a pool object in javascript that can connect to a database backend using SSL?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related