How to connect to Heroku Postgresql from Sails.js Java Script

Question

js to create my application. I want to use Heroku database hosting where I created and got database. Now i try to connect to it from my application. That's snippet from my local.js :

adapters: {

'default': 'postgres',
 module   : 'sails-postgresql',
 host     : '...',
 port     : 5432,
 user     : '...',
 password : '...',
 database : '...',

 schema: true //This makes sure that sails matches 
               //the database schema to your models.
}

When i lift the sails application i got error :

"Error creating a connection to Postgresql: error: no pg_hba_conf entry for host "83.21...", user ..., database ..., SSL off"

The "..." are user,databse etc from my local.js.

How to fix the problem? When I change the data in the local.js to my local postgresql database it works fine, but when I change the data and try to connect to the database on Heroku hosting it displays the error all time :/

CSharpBeginner · Accepted Answer · 2014-03-04 17:04:13Z

8

Heroku requires the ssl setting to be turned on. Add ssl: true to your config like so:

module   : 'sails-postgresql',
host     : '...',
port     : 5432,
user     : '...',
password : '...',
database : '...',
ssl      : true

edited Mar 4, 2014 at 17:04

CSharpBeginner

1,7356 gold badges24 silver badges39 bronze badges

answered Mar 4, 2014 at 16:15

particlebanana

2,41621 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to connect to Heroku Postgresql from Sails.js Java Script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related