Connect to GCP Cloud SQL Postgres

Feature Requests
,
1

The idea is:

Allow uploading a custom CA certificate for Postgres credentials

My use case:

I’m using Cloud n8n, and I have a Postgres hosted on GCP Cloud SQL that I’d like nodes to interact with. By default, every Cloud SQL instance has its own CA, so that it doesn’t have to be added to DNS. To establish secure SSL connections, the client has to have the certificate for the CA, and use verify-ca mode.

I think it would be beneficial to add this because:

Supporting nodes connecting to GCP Cloud SQL would be very useful.

Any resources to support this?

Are you willing to work on this?

:person_shrugging:

2

Briefly looking into how it might be implemented, NodePropertyTypes doesn’t have a value for INodeProperties’s type that would allow for a pem file upload or similar. It’d have to be a string field, which should work if it can handle over-1000-character strings, but would be awkward to use.

3

I have opened a PR: feat(Postgres Node): Add support for connecting with SSL certificates by devnev · Pull Request #14132 · n8n-io/n8n · GitHub

1 Like