N8n using PostgreSQL added to BigBearCasaOS

BigBearCasaOS BigBearCasaOS Change Log
1

I’ve been seeing a lot of people who want an updated version of n8n, so I added it to BigBearCasaOS. The n8n setup uses PostgreSQL, and you need to run a script that’s in BigBearScripts before installing.

Run this script:

bash -c "$(wget -qLO - https://raw.githubusercontent.com/bigbeartechworld/big-bear-scripts/master/generate-n8n-init-data/run.sh)"

After running this script, you should be able to install it.

1180×707 190 KB

2

Any plans on update the script to support n8n Queue mode ?

3

Is this required now or just optional?

4

This is optional.

I noticed that the current setup uses PostgreSQL for n8n, and I’m wondering if there are plans to support n8n’s Queue mode in the future.

Queue mode provides several benefits, including:

  • Improved performance: It allows n8n to process tasks asynchronously, which can significantly improve performance, especially when dealing with large workloads.
  • Increased reliability: It helps prevent bottlenecks and ensures that tasks are completed even if there are temporary issues with the system.
  • Enhanced scalability: It allows n8n to handle more tasks and users without compromising performance.

I believe that adding support for Queue mode would make n8n even more powerful and flexible within BigBearCasaOS. It would be fantastic to see this feature considered for a future update.

Thank you for your consideration and for all your hard work in enhancing BigBearCasaOS.

1 Like
5

Yes, queueing helps a lot with many tasks. I use it frequently in BigBearApps. I’ll look into it further.

1 Like
6

hello,

in my setup i see this message in every second at db-n8n log:

2024-07-15 19:45:34.735 UTC [7262] FATAL:  role "bigbearcasaos" does not exist

i’m using different db username. app works just fine. how can I prevent this error from occurring?

7

How do I run this script?

8

You will need to SSH into your server and then run it.

9

hello, thanks for the tutorial. i managed to install it. however i cant get the n8n sql credential part to work.. i connect via http://casaosipv4:5678 to n8n

could you show how to setup the credentials in n8n please?

10

Hi @Se_Je and welcome here!

I have n8n working in my homelab without problems.

Could You please share what error msg is shown?

11

This happens because of helthcheck configuration that is hidden in Zima/Casa UI. You might change DB user in env variables. But in health check it is hardcoded. Just ubdate it manually to match one in the env variables

healthcheck:
test:
- CMD-SHELL
- pg_isready -h localhost -U bigbearcasaos -d n8n

1 Like