node.js - SSL for PostgreSQL connection nodejs

Question

I am trying to connect to my Heroku PostgreSQL DB and I keep getting an SSL error. Does anyone have an idea on how to enable SSL in the connection string?

postgres://user:pass@host:port/database;

Been looking for it everywhere but it does not seem to be a very popular topic. By the way, I am running Nodejs and the node-pg module with its connection-pooled method:

pg.connect(connString, function(err, client, done) {
  // Should work.
});

Comments are much appreciated.

question from:https://stackoverflow.com/questions/22301722/ssl-for-postgresql-connection-nodejs

Answer 1

You can achieve this like this:

postgres://user:pass@host:port/database?ssl=true