I am new to node, so forgive me if this is a silly question.
I have written a node js/express/postgress app on my local system and things work great.
I tried to move the app to the Amazon Cloud -- everything the postgress DB and node code. When the node app tries to connect to the postgress DB I see this error:
error: no pg_hba.conf entry for host "54.201.213.227", user "automation", database "automationdb", SSL off
I tried using:
var pg = require('pg').native;
but it does not help.
you probably need to set PGSSLMODE=require as an environment variable. node postgres sniffs those and will connect over SSL properly in that case
Yes -- thanks so much for taking the time to respond.
No problemo!
Most helpful comment
you probably need to set PGSSLMODE=require as an environment variable. node postgres sniffs those and will connect over SSL properly in that case