Postgres Node SSL Certificate

Questions
,
1

Describe the problem/error/question

How do I include a custom SSL certificate to my postgres node? My postgres database requires an SSL certificate in addition to username and password to connect.

I see the MySQL node has an option, but the same fields don’t appear on postgres node. Is there another way to accomplish this?

All the existing questions I see are related to connecting to the underlying postgres database that powers self hosting n8n. I don’t see anything for the postgres node.

What is the error message (if any)?

When attempting to connect the connection stalls and timesout. No error is given.

Information on your n8n setup

  • n8n version: Version 1.62.4
  • Database (default: SQLite): postgres
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • Operating system: Kubernetes
2

Welcome to the community @Adam_Casted !

Tip for sharing information

Pasting your n8n workflow

Ensure to copy your n8n workflow and paste it in the code block, that is in between the pairs of triple backticks, which also could be achieved by clicking </> (preformatted text) in the editor and pasting in your workflow.

```
<your workflow>
```

That implies to any JSON output you would like to share with us.

Make sure that you have removed any sensitive information from your workflow and include dummy or pinned data with it!

I don’t think there is such an option in Postgres node unless you use HTTP Request node to connect to the API, which is enabled from node’s Settings tab.