TLS/SSL

node-postgres supports TLL/SSL connections to your PostgreSQL server as long as the server is configured to support it. When instantiating a pool or a query you can provide an ssl property on the config object and it will be passed to the constructor for the node TLSSocket.

Self-signed cert

Here's an example of a configuration you can use to connect a client or a pool to a PostgreSQL server.

const config = {
  database : 'database-name',
  host     : "host-or-ip",
  // this object will be passed to the TLSSocket constructor
  ssl : {
    rejectUnauthorized : false,
    ca   : fs.readFileSync("/path/to/server-certificates/maybe/root.crt").toString(),
    key  : fs.readFileSync("/path/to/client-key/maybe/postgresql.key").toString(),
    cert : fs.readFileSync("/path/to/client-certificates/maybe/postgresql.crt").toString(),
  }
}

import { Client, Pool } from 'pg'

const client = new Client(config)
client.connect((err) => {
  if (err) {
    console.error('error connecting', err.stack)
  } else {
    console.log('connected')
    client.end()
  }
})


const pool = new Pool(config)
pool.connect()
  .then(client => {
    console.log('connected')
    client.release()
  })
  .catch(err => console.error('error connecting', err.stack))
  .then(() => pool.end())
made withby@briancarlson