Postgres Trigger is broken

Questions
1

Hello,

The Postgres trigger is not working properly. None of the three events (insert, update, delete) does not output any results.

I’ve tried to execute insert, update and delete operations while trigger is listening. I have also tried to activate workflow and do these operations afterwards – nothing worked.

I’ve seen that some people faced issues with this before but it doesn’t seem to be ever resolved.

Has anyone is using this trigger in production and how is everything working on your side?

Information on your n8n setup

  • n8n version: 1.123.5
  • Database: Postgres (via Supabase)
  • n8n EXECUTIONS_PROCESS setting (default: own, main): not sure
  • Running n8n via: Docker
  • Operating system: Linux (Render)
2

Have you tried using a schedule trigger node ?

3

No, I haven’t tried that.

I did some research and I think the main issue is hosting on Render as it doesn’t support IPv4 and therefore I need to use a transaction pooler, which is not so stable.

So I just created a webhook with a POST method and it seems to work fine.

4

Okay that’s great @Illia_Adov , if you have any other questions kindly let me know.

1 Like