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.
ssl=trueas a URL query parameter as inpostgres://user:pass@host:port/database?ssl=true. – Milen A. Radev Mar 10 at 15:15