Supabase Postgres cant connect to my local hosted n8n

Questions
1

Describe the problem/error/question

my n8n is locally hosted but is tunneled by cloudflare

Im connecting n8n i tried downloading the cloudflare certificate and modifying my docker compose yml i tried toggle off the suapbase ssl enforce
i tried ignore ssl certificate in n8n

but it still getting this error
self-signed certificate in certificate chain

image
image1919×870 54.3 KB

What is the error message (if any)?

self-signed certificate in certificate chain

Please share your workflow

d

Share the output returned by the last node

d

Information on your n8n setup

  • n8n version: 1.98.1,
  • Database (default: SQLite): postgres supabase
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: windows 11
2

This is because the managed postgres instance behind supabase is using a self-signed certificate, which is trusted by supabase.

3

but not trusted by n8n?

4

Exactly! You got it.

5

any workaround with this since its working in cloud version of n8n

6

If I recall correctly from the last time a similar question was asked, we ended up discovering that even though you can download the certificate, you cannot provide it to the postgres node (unlike mysql, for instance).

You can read up on this conversation here.

7

his n8n is cloud based mine is locally hosted and then tunneled by cloudflare
but still, I think its the same problem