# Postgres Trigger node

**URL:** <https://community.n8n.io/t/postgres-trigger-node/27770>\
**Category:** Questions\
**Tags:** postgres, n8n-node\
**Created:** [July 4, 2023, 5:56pm UTC](https://community.n8n.io/t/postgres-trigger-node/27770 "2023-07-04T17:56:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![gariva](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/gariva/32/17889_2.png) [@gariva](https://community.n8n.io/u/gariva)\
**Post date:** [July 4, 2023, 5:56pm UTC](https://community.n8n.io/t/postgres-trigger-node/27770/1 "2023-07-04T17:56:29Z")

</div>

Hi @agobrecht and @marcus I was wondering if you can point me to more detailed instruction and / examples of the Postgres Trigger Node. if you check my comments in this post ([Postgres node and postgres trigger node - #4 by gariva](http://community.n8n.io/t/postgres-node-and-postgres-trigger-node/27564/4)) you will see what kind of difficulties I have encountered.

Regards  
Gariva

---

<div class="post-metadata">

**Author:** ![marcus](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/marcus/32/15989_2.png) [@marcus](https://community.n8n.io/u/marcus)\
**Post date:** [July 19, 2023, 3:11pm UTC](https://community.n8n.io/t/postgres-trigger-node/27770/4 "2023-07-19T15:11:55Z")

</div>

Hi @gariva,  
when using the Postgres Trigger Node to listen for events on a table it will automatically create a postgres trigger and function to listen to events. Both will be created if you manually run your workflow or if you activate your workflow. Also both will be deleted once a manuel execution finished or you deactivate you workflow. If n8n restarts it will reuse the previously created postgres trigger and function. Each Trigger node will create their own postgres trigger and function.

In regards to your problems mentioned [here](http://community.n8n.io/t/postgres-node-and-postgres-trigger-node/27564/4) I am surprised to hear that the trigger worked once and than didn’t work a second time giving an error “_must be owner of relation alertas\_rastreo_”.

- Are you sure that your postgres user also has access to “alertas\_rastreo”?
- Did you try activating your workflow and checking the executions view to see if multiple events were fired (workflow setting _Save successful production executions_ must be enabled)?

---

<div class="post-metadata">

**Author:** ![gariva](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/gariva/32/17889_2.png) [@gariva](https://community.n8n.io/u/gariva)\
**Post date:** [July 20, 2023, 8:40pm UTC](https://community.n8n.io/t/postgres-trigger-node/27770/5 "2023-07-20T20:40:37Z")

</div>

> [@marcus](#):
>
> ow setting _Save successfu_

HI @marcus I tried the node again… I am sad to say I could not make it work. I made sure the n8n user has all the permits in alertas\_rastreo. I deleted all previous trace of n8n trigger and trigger functions. Tried it by pushing Listen to event and by activating the workflow. It worked fine two times with the listen to event button. When swiched to active it never registered a workflow execution with the active workflow. I also bumped a couple of times with the “must be owner…” error but I learned to avoid it by deleting the n8n created triggers and trigger functions. Thanks for your support, regards,  
garive

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [October 18, 2023, 8:41pm UTC](https://community.n8n.io/t/postgres-trigger-node/27770/6 "2023-10-18T20:41:06Z")

</div>

Closed on October 18, 2023, 8:41pm UTC

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