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?
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>
Hello - would you be able to specify the correct format of the parameters? I tried entering as an example:
But I am still receiving the same error message.