I need help to deploy my project to Heroku. Every time that I attempt to deploy my project I get this error:
Error: no pg_hba.conf entry for host "104.57.187.158", user "epcifomwotivdd", database "dummyDB12", SSL off
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] migrate: `postgrator --config postgrator-config.js`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] migrate script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\Juan Mireles\AppData\Roaming\npm-cache\_logs\2021-01-23T21_21_52_677Z-debug.log
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] migrate:production: `env SSL=true DATABASE_URL=dummyDB npm run migrate`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] migrate:production script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\Juan Mireles\AppData\Roaming\npm-cache\_logs\2021-01-23T21_21_52_760Z-debug.log
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! [email protected] predeploy: `npm audit && npm run migrate:production`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the [email protected] predeploy script.
npm ERR! This is probably not a problem with npm. There is likely additional logging output above.
npm ERR! A complete log of this run can be found in:
npm ERR! C:\Users\Juan Mireles\AppData\Roaming\npm-cache\_logs\2021-01-23T21_21_52_809Z-debug.log
I've tried adding the host to the pg_hba.conf and changed the postgresql.conf to the setting to accept all hosts.
This is my pg_hba.conf:
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all trust
# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all 0.0.0.0/0 trust #inserted
# IPv6 local connections:
host all all ::0/0 trust #inserted
host all all ::1/128 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
local replication all trust
host replication all 127.0.0.1/32 trust
host replication all ::1/128 trust
host all all 0.0.0.0/0 trust #inserted
I tried adding and removing the inserted host in different ways, but I can't get it to work. Also, with every change that I did I restarted the server. I did see some other options to try but they were for Mac and I'm on a Windows computer.