Hey all. I’m having issues with recent versions of n8n.
I initially deployed to Heroku with this configuration which worked great, but used a slightly outdated version missing some features (Thanks @jan for the help on the other thread!). When I upgraded from 0.98.0 to 0.104.0 I to access those features I started getting an error connecting to the hosting DB.
There was an error initializing DB: no pg_hba.conf entry for host "x", user "y", database "z", SSL off
I believe this is because Heroku Postgres databases require you to connect with SSL and it’s saying that it isn’t connecting to the database with SSL.
Unfortunately Heroku doesn’t give access to the CA files to use SSL with Postgres. I think it’s just a matter of connecting with the
sslmode=require parameter Heroku mentions here. This worked in the previous version without issue. Any thoughts as to what might be happening here?