Enable SSL

[Sneppers]

My host provider requires SSL (Heroku) to connect from remote locations.
Any 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, am using the connection-pooled method:

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

Please, let me know.

[brianc]

Hey @Sneppers -

I use heroku a lot too. To enable ssl append '?ssl=require' to the query string of the connection string url, set an environment variable to PGSSLMODE=require or set it as your default pg settings in require('pg').defaults.ssl = true

[Sneppers]

Thank for the reply.
I just tried both:

postgres://user:pass@host:port/database?ssl=require;
and
require('pg').defaults.ssl = true

For both cases I still get the same connection refused error.
Any more ideas?

[brianc]

Hmmm...that's strange. Try setting require('pg').defaults.ssl = 'require'

Also, this is how I usually do it: https://github.com/brianc/node-postgres/blob/master/test/integration/client/heroku-ssl-tests.js

[Sneppers]

Finally, thank you.
The require('pg').defaults.ssl = 'require' did also not do it.
Simply putting the ssl property in the config object did the trick.

I am pretty sure I had tried that before... Anyway, works now.

[lepinsk]

@brianc – my guess is that you're seeing people having issues with this because heroku's docs instruct hard-coding "pg": "0.6.15", (I suffered through the same problems above, for the same reason)

[brianc]

barf - those docs are extreeeemly out of date! I've let them know before, & I'll contact them again.

[brianc]

I talked to the heroku team & they updated the docs. @lepinsk thanks for pointing that out. :)

[lepinsk]

Glad to be of assistance @brianc; it's the least I could do. :-)

[hunterloftis]

@brianc @lepinsk, I've updated the docs so users following them will always start with the latest version of pg. That should help folks avoid resolved issues in the future.

I've also added a note about the ssl requirements:

• https://devcenter.heroku.com/articles/heroku-postgresql#connecting-in-node-js