N8n cloud SSL connection with postgress

Questions
1

Describe the problem/error/question

I’m trying to add a postgres connection to use with the AI Agent/SQL agent to query against. Would like to have SSL connection, but don’t see a way to add my certificate information and the only help info I’m seeing available is for self hosted.

What is the error message (if any)?

Error: self-signed certificate in certificate chain

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.34.2
  • Database (default: SQLite): n/a but connection is to postgres db in supabase
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via ** n8n cloud
  • Operating system: n/a
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hello @Philip_Wiggins
You can’t add a self-signed certificate to the cloud n8n instance. Actually thats really strange that your postgres database does not have a proper certificate while it is exposed to the internet. You have two options:

  1. configure a lets encrypt certificate (free) for the postgres
  2. use a load balancer with proper ssl certificate that will forward traffic to the postgres db