SQL Agent node error - self-signed certificate in certificate chain

[viktorbezdek]

Bug Description

I am using postgres via supabase. Connecting via session pooler for IPv4 compatibility. Everything works fine using Postgres node. SQL agent node fails with self-signed certificate error.

Recording:

Stack trace:

Error: self-signed certificate in certificate chain at TLSSocket.onConnectSecure (node:_tls_wrap:1677:34) at TLSSocket.emit (node:events:518:28) at TLSSocket._finishInit (node:_tls_wrap:1076:8) at TLSWrap.ssl.onhandshakedone (node:_tls_wrap:862:12)

N8N version: 1.74.3 (Self Hosted)

To Reproduce

Expected behavior

SQL agent is expected to connect to postgres successfully.

Operating System

OSX 15.2 (24C101) via docke-compose (Docker 4.37.2 (179585))

n8n Version

1.74.3

Node.js Version

v20.18.1

Database

PostgreSQL

Execution mode

main (default)

[Joffcom]

Hey @viktorbezdek,

We have created an internal ticket to look into this which we will be tracking as "N8N-8146"