Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
_AnonymousUser
Specialist III
Specialist III

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
Labels (4)
1 Reply
Anonymous
Not applicable

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