SSL for PostgreSQL connection nodejs

node.js postgresql ssl node-postgres
Stefan picture Stefan · Mar 10, 2014 · Viewed 38.3k times · Source

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.

Answer

Jérôme Verstrynge picture Jérôme Verstrynge · Jul 25, 2014

You can achieve this like this:

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

Related questions

What is this Javascript "require"?

I'm trying to get Javascript to read/write to a PostgreSQL database. I found this project on github. I was able to get the following sample code to run in node. var pg = require('pg'); //native libpq bindings = `var pg = …

Read More
How to make connection to Postgres via Node.js

I find myself trying to create a postgres database, so I installed postgres and started a server with initdb /usr/local/pgsql/data, then I started that instance with postgres -D /usr/local/pgsql/data now how can I interact …

Read More
What is the proper way to use the node.js postgresql module?

I am writing a node.js app on Heroku and using the pg module. I can't figure out the "right" way to get a client object for each request that I need to query the database. The documentation uses code …

Read More