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 :/

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 :/

• javascript
• postgresql
• heroku
• sails.js

Share Improve this question Follow edited Mar 4, 2014 at 17:00 CSharpBeginner asked Mar 4, 2014 at 15:32 CSharpBeginnerCSharpBeginner 1,72566 gold badges2424 silver badges3939 bronze badges

Add a ment  | 

1 Answer 1

Sorted by: Reset to default 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