I am running Node Red v.2.0.6 on a Siemens IoT2050, and using Putty to SSH in.
I have a Postgres database hosted on AWS that I want to send queries to.
I have connected this database to Tecnomatix Plant Simulation, accessed it on DBeaver etc. without any problems. My inbound rules on AWS are set to allow all connections (0.0.0.0/0)
I have tried both node-red-contrib-postgresql and node-red-contrib-re-postgres, and both give the following error when I try to run a query:
error: no pg_hba.conf entry for host "IP Adress", user "postgres", database "dbname", no encryption
The problem is I have no access to the pg_hba.conf file on AWS, and am limited to changing inbound rules (which already allow all connections). I might be missing something very basic but I have no idea how to solve this.