Cannot connect to Postgres database hosted on AWS "no pg_hba.conf entry"

Hi everyone!

Some context:
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)

My problem
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.

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.