# Postgrestor node does not give any output msg

**URL:** <https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840>\
**Category:** General\
**Created:** [8 June 2021 06:59 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840 "2021-06-08T06:59:29Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![esalles](https://avatars.discourse-cdn.com/v4/letter/e/ac8455/32.png) [@esalles](https://discourse.nodered.org/u/esalles)\
**Post date:** [8 June 2021 06:59 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/1 "2021-06-08T06:59:29Z")

</div>

Guys,

I'm facing a strange issue on a new Node-Red setup.  
It used to use postgrestor many times on many setup, but on that new one, postgrestor node does not give any output msg.

What I've already checked:

- Downgrade Node-Red to match a version a already use and whoch works fine this Postgrestor, but nothing change
- Complete uninstall of Node-Red and porject files, then steup again with only Inject + Postgrestor + debug node, but nothing change
- I tested by PostgreSQL DB access, and it works with local commands, remote PGAdmin and even remote Node-Red with Postgrestor

Now I try to find a way to trace what happens into the node, but I don't get anything.  
Does somebody have to feedback about such an issue, and a way to proceed?

Thanks by advance.

---

<div class="post-metadata">

**Author:** ![esalles](https://avatars.discourse-cdn.com/v4/letter/e/ac8455/32.png) [@esalles](https://discourse.nodered.org/u/esalles)\
**Post date:** [8 June 2021 07:43 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/2 "2021-06-08T07:43:21Z")

</div>

Update:  
I also tried using node-red-contrib-re-postgres, and the result is the same...  
Does it means taht the problem is deep into a common sub-node?

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [8 June 2021 07:54 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/3 "2021-06-08T07:54:02Z")

</div>

FWIW, I have no issues with `node-red-contrib-postgrestor-next` and `@digitaloak/node-red-contrib-digitaloak-postgresql` contrib nodes.

---

<div class="post-metadata">

**Author:** ![esalles](https://avatars.discourse-cdn.com/v4/letter/e/ac8455/32.png) [@esalles](https://discourse.nodered.org/u/esalles)\
**Post date:** [8 June 2021 07:56 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/4 "2021-06-08T07:56:30Z")

</div>

Hi Steve-Mcl,

Thanks for the feedback.  
Same for me on other machines. And even same to connect that machine BD from another machine running Node-Red.  
This makes me crazy..!

---

<div class="post-metadata">

**Author:** ![esalles](https://avatars.discourse-cdn.com/v4/letter/e/ac8455/32.png) [@esalles](https://discourse.nodered.org/u/esalles)\
**Post date:** [9 June 2021 07:29 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/5 "2021-06-09T07:29:38Z")

</div>

So I continue investigating this blocking use.

All my tests confirm that the PostgreSQM BD is OK since I can access it locally (command line) and remotely (PG-Admin and even another Node-Red instance using postgrestor).

That means the problem is located in that deployment, into Postgrestor and its dependencies.  
As a reminder, the symptom is that Postgrestor node does not retrun any msg, whatever the BDD credentials ares (correct or not).

In addition, I've tested several other PostgreSQL nodes like node-red-contrib-postgrestor, node-red-contrib-postgrestor\_next, node-red-contrib-postgrestor-variable and node-red-contrib-digitaloak-postgresql, but nothing change at all.

I'm far from a skilled nodejs developer, but looking at hte postgrestor node files shows me that they all use the same dependencies.  
And I'm not able to get traces of what happens into them.

Is there some Node-red Prophet like @knolleary or @dceejay (I see that you are very active 🙂 ) to help me about how to get info from the route cause?

Many thanks by advance...

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [9 June 2021 08:37 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/6 "2021-06-09T08:37:37Z")

</div>

sorry - I don't use postgres at all

---

<div class="post-metadata">

**Author:** ![esalles](https://avatars.discourse-cdn.com/v4/letter/e/ac8455/32.png) [@esalles](https://discourse.nodered.org/u/esalles)\
**Post date:** [9 June 2021 09:30 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/7 "2021-06-09T09:30:12Z")

</div>

Thanks, @dceejay, for taking time to answer me.  
I understand that you do not use this particular feature, but I'm also looking for tricks to get logs of what the nodes (and dependencies) are doing. But even if I config log level to the maximum (from settings.js), I get nothing more neither in syslog nor journal.

Any advice is welcome 🙂

---

<div class="post-metadata">

**Author:** ![esalles](https://avatars.discourse-cdn.com/v4/letter/e/ac8455/32.png) [@esalles](https://discourse.nodered.org/u/esalles)\
**Post date:** [9 June 2021 10:11 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/8 "2021-06-09T10:11:03Z")

</div>

Well,

I've found a by-pass solution: since the only difference was nodejs version, I tried to downgrade it to a known compatible one, and it works... !

As I remember, the faulty nodejs version was 14.3.0.

Thanks again anyway.

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [9 June 2021 11:28 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/9 "2021-06-09T11:28:53Z")

</div>

Have you tried [node-red-contrib-flogger (node) - Node-RED](https://flows.nodered.org/node/node-red-contrib-flogger)

---

<div class="post-metadata">

**Author:** ![esalles](https://avatars.discourse-cdn.com/v4/letter/e/ac8455/32.png) [@esalles](https://discourse.nodered.org/u/esalles)\
**Post date:** [9 June 2021 12:14 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/10 "2021-06-09T12:14:00Z")

</div>

Yes, I tried it a couple of minutes but I was just able to log data between nodes (like I saw in right side debug window), not into the nodes.

I said in my solution post above, it seem that postreSQl dependency nodes present an incompatibility with nodejs.  
No time and no skills to to have a deeper look, I will satiffy myself to dowgrade it.

---

<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:** [23 June 2021 12:14 UTC](https://discourse.nodered.org/t/postgrestor-node-does-not-give-any-output-msg/46840/11 "2021-06-23T12:14:28Z")

</div>

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