Postgresql with nodered - Error: connect ECONNREFUSED 192.168.0.27:5432

Developing Nodes
1

Hi!
I am trying to connect PostgreSQL with nodered, but:
Error: connect ECONNREFUSED 192.168.0.27:5432

Nodered is inside a virtual machine (ip: 192.168.0.28)

PostgreSQL isinside virtual machine (192.168.0.27)
db_instalacion
user_instalacion
port:5432

Between the virtual machines the communication is correct, since I can ping without problem

What is happening?

Thanks

conf1
conf1952×498 55.7 KB

conf2
conf2820×523 53.8 KB

2

Have you etup PostgreSQL to allow Remote Connections?

Tons of info on the net e.g. "How To Configure PostgreSQL to Allow Remote Connections – TecAdmin" How To Configure PostgreSQL to Allow Remote Connections – TecAdmin

3

Also check (from the node-red machine) that port 5432 is open on the db machine. Using nmap for example.

4

Thanks! I have follow link steps. In the first time i had a problem because i couldn´t login in pgadmin after the pg_hba.conf file change. After i saw a comment thas says: use "host all all ::0/0 md5" and not "host all all :/0 md5" and the connection was ok! Thanks!