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

Announcements
Join us in NYC Sept 4th 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