Postgres self-signed cert

dmr · May 7, 2021, 3:39pm

Trying a workflow connecting to postgres and receive the following error:

Error: self signed certificate
at TLSSocket.onConnectSecure (_tls_wrap.js:1497:34)
at TLSSocket.emit (events.js:315:20)
at TLSSocket._finishInit (_tls_wrap.js:932:8)
at TLSWrap.ssl.onhandshakedone (_tls_wrap.js:706:12)

Any way to accept self-signed certs from postgres?

RicardoE105 · May 7, 2021, 9:16pm

Welcome to the community.

Is that using the Postgres node or using Postgres as the n8n database?

dmr · May 7, 2021, 9:48pm

The Postgres Node.

RicardoE105 · May 7, 2021, 9:54pm

In the credential set the parameter ignore SSL issues to true.

dmr · May 7, 2021, 10:22pm

That worked, thanks.

For some reason that wording makes me think that it will ignore ssl if any issue comes up. I’m fine with it accepting a self-signed cert (obviously), but do want it to enforce ssl otherwise for the encryption value.