# Postgres Notify

**URL:** <https://discourse.nodered.org/t/postgres-notify/87655>\
**Category:** General\
**Tags:** database\
**Created:** [2 May 2024 15:16 UTC](https://discourse.nodered.org/t/postgres-notify/87655 "2024-05-02T15:16:13Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![warby78](https://avatars.discourse-cdn.com/v4/letter/w/858c86/32.png) [@warby78](https://discourse.nodered.org/u/warby78)\
**Post date:** [2 May 2024 15:16 UTC](https://discourse.nodered.org/t/postgres-notify/87655/1 "2024-05-02T15:16:13Z")

</div>

I have installed the PG Listen node pg-listen-new

There are three parameters on the UI, the node name, the channel to listen to ( this I understand fine), and a text entry "Server" into which I have put the full postgres connection string

The node is throwing an error

02/05/2024, 16:06:11[node: Listen to Scheduler Channel](https://my-server-address/#)msg : string[30]  
"missing postgres configuration"

Should there be some way to link this node to the postgressql connection config node? I am stuck.

As it stands the node is showing disconnected.

---

<div class="post-metadata">

**Author:** ![homeplayer](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/homeplayer/32/12388_2.png) [@homeplayer](https://discourse.nodered.org/u/homeplayer)\
**Post date:** [3 May 2024 07:17 UTC](https://discourse.nodered.org/t/postgres-notify/87655/2 "2024-05-03T07:17:29Z")

</div>

> [@warby78](#):
>
> The node is throwing an error
> 
> 02/05/2024, 16:06:11[node: Listen to Scheduler Channel](https://my-server-address/#)msg : string[30]  
> "missing postgres configuration"

If you did a copy past of the error,  
then [https://my-server-address/#](https://my-server-address/#) \<--- you still need to put server ip

---

<div class="post-metadata">

**Author:** ![warby78](https://avatars.discourse-cdn.com/v4/letter/w/858c86/32.png) [@warby78](https://discourse.nodered.org/u/warby78)\
**Post date:** [3 May 2024 09:43 UTC](https://discourse.nodered.org/t/postgres-notify/87655/3 "2024-05-03T09:43:30Z")

</div>

That's not it, I just didn't want to paste my server details into a public forum

---

<div class="post-metadata">

**Author:** ![warby78](https://avatars.discourse-cdn.com/v4/letter/w/858c86/32.png) [@warby78](https://discourse.nodered.org/u/warby78)\
**Post date:** [3 May 2024 11:19 UTC](https://discourse.nodered.org/t/postgres-notify/87655/4 "2024-05-03T11:19:47Z")

</div>

I rebooted everything emptied my caches and when I went back into nodered, the text entry field for postgres db was now showing as a callout to a set of fields for putting in server details. It is connected and working.

---

<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:** [17 May 2024 11:20 UTC](https://discourse.nodered.org/t/postgres-notify/87655/5 "2024-05-17T11:20:42Z")

</div>

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