Use client certificate with jdbc driver and postgresql

One Star

Use client certificate with jdbc driver and postgresql

Hi,
I am deploying a job made with talend but it can't connect to a postgres database.
the reason returned by the serveur: FATAL: connection requires a valid client certificate
I have this client certificate, it is stored in ~/.postgresql folder of the user.
I copied it in the keytool: sudo keytool -keystore $JAVA_HOME/lib/security/cacerts -alias postgresql -import -file ~/certifs/postgresql.crt
actually I also copied it in the directory of the sh of my job.
I tried executing with or without sudo but jdbc still can't find this certificate.
What should I do for jdbc to use the certificate?
Regards
Community Manager

Re: Use client certificate with jdbc driver and postgresql

Hi
Just search this issue on google and found a similar topic:
http://postgresql.1045698.n5.nabble.com/JDBC-with-SSL-td5046625.html
Hope it will help you!
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business