Connect to PostgreSQL on Google Cloud Platform

Hello - I am trying to connect to a PostgreSQL database hosted on GCP. I am using the PostgreSQL Connector and have entered the Hostname, Database name, username and password as well as the following JDBC parameters: ssl=true, sslfactory=org.postgresql.ssl.NonValidatingFactory. However, I am receiving the following error message: Execute failed: FATAL: connection requires a valid client certificate. Do you know how I connect my client certificate?

Hi @kizuka

Welcome to the KNIME Forum! You should be able to pass the SSL Certificates on the JDBC parameters as well by adding the parameters

sslcert=<path to .crt>
sslkey=<path to .pk8>

Regards,
Wali

3 Likes

Hello - would you be able to specify the correct format of the parameters? I tried entering as an example:

C:\Users\username\Documents\client-cert.pem
C:\Users\username\Documents\client-key.pem

But I am still receiving the same error message.

Thanks!
Karen

1 Like