# Cannot able to query data into PostgreSQL from PI

**URL:** <https://discourse.nodered.org/t/cannot-able-to-query-data-into-postgresql-from-pi/85164>\
**Category:** General\
**Tags:** database\
**Created:** [3 February 2024 13:34 UTC](https://discourse.nodered.org/t/cannot-able-to-query-data-into-postgresql-from-pi/85164 "2024-02-03T13:34:16Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![shubhamnodered](https://avatars.discourse-cdn.com/v4/letter/s/e8c25b/32.png) [@shubhamnodered](https://discourse.nodered.org/u/shubhamnodered)\
**Post date:** [3 February 2024 13:34 UTC](https://discourse.nodered.org/t/cannot-able-to-query-data-into-postgresql-from-pi/85164/1 "2024-02-03T13:34:16Z")

</div>

Hi Guys! Needed help...

- Node-red version [PC]: -- node-red@3.0.2
- Node.js version: -- v18.17.1

I am trying to query data into PostgreSQL [running on my PC] from node-red [running on PI]. But i received error " **Error: Connection terminated due to connection timeout**". How to troubleshoot it?

- Node-red version [PC]: -- node-red@3.1.0
- Node.js version: -- v18.17.1

However, when I am try to query data into PostgreSQL from node-red [Both are running on same PC], things works flawlessly.

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/2/2/22b616e11d9ae68357ba119cbea47f1f31837d5c.png)

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [3 February 2024 14:05 UTC](https://discourse.nodered.org/t/cannot-able-to-query-data-into-postgresql-from-pi/85164/2 "2024-02-03T14:05:12Z")

</div>

What do you have in your postgres configuration files postgresql.conf for listen\_addresses and in pg\_hba.conf?

---

<div class="post-metadata">

**Author:** ![shubhamnodered](https://avatars.discourse-cdn.com/v4/letter/s/e8c25b/32.png) [@shubhamnodered](https://discourse.nodered.org/u/shubhamnodered)\
**Post date:** [3 February 2024 16:33 UTC](https://discourse.nodered.org/t/cannot-able-to-query-data-into-postgresql-from-pi/85164/3 "2024-02-03T16:33:01Z")

</div>

Hi @jbudd, I have assigned:

- listen\_addresses as '\*' in **postgresql.conf** file  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/9/5/95cc6e8604ae28dd81a3478ebe5f7a59b2966515.png)

- For **pg\_hba.conf** , please refer below image  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/5/f/5f7a375698c3f649924692d948d322cde4692c09.png)

---

<div class="post-metadata">

**Author:** ![jbudd](https://avatars.discourse-cdn.com/v4/letter/j/5f8ce5/32.png) [@jbudd](https://discourse.nodered.org/u/jbudd)\
**Post date:** [3 February 2024 17:22 UTC](https://discourse.nodered.org/t/cannot-able-to-query-data-into-postgresql-from-pi/85164/4 "2024-02-03T17:22:30Z")

</div>

What computer is at 172.16.14.69 ?

Does it make any difference if you change that to 172.16.14.0/24 ? (And restart Postgres)

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [3 May 2024 17:22 UTC](https://discourse.nodered.org/t/cannot-able-to-query-data-into-postgresql-from-pi/85164/5 "2024-05-03T17:22:38Z")

</div>

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