https://community.qlik.com/t5/Talend-Studio/Use-client-certificate-with-jdbc-driver-and-postgresql/m-p/2345209#M112768 Hi,<BR />I am deploying a job made with talend but it can't connect to a postgres database.<BR />the reason returned by the serveur: FATAL: connection requires a valid client certificate<BR />I have this client certificate, it is stored in ~/.postgresql folder of the user. <BR />I copied it in the keytool: sudo keytool -keystore $JAVA_HOME/lib/security/cacerts -alias postgresql -import -file ~/certifs/postgresql.crt<BR /> actually I also copied it in the directory of the sh of my job.<BR />I tried executing with or without sudo but jdbc still can't find this certificate.<BR />What should I do for jdbc to use the certificate?<BR />Regards Tue, 30 Jul 2013 16:36:51 GMT _AnonymousUser 2013-07-30T16:36:51Z https://community.qlik.com/t5/Talend-Studio/Use-client-certificate-with-jdbc-driver-and-postgresql/m-p/2345209#M112768 Hi,<BR />I am deploying a job made with talend but it can't connect to a postgres database.<BR />the reason returned by the serveur: FATAL: connection requires a valid client certificate<BR />I have this client certificate, it is stored in ~/.postgresql folder of the user. <BR />I copied it in the keytool: sudo keytool -keystore $JAVA_HOME/lib/security/cacerts -alias postgresql -import -file ~/certifs/postgresql.crt<BR /> actually I also copied it in the directory of the sh of my job.<BR />I tried executing with or without sudo but jdbc still can't find this certificate.<BR />What should I do for jdbc to use the certificate?<BR />Regards Tue, 30 Jul 2013 16:36:51 GMT https://community.qlik.com/t5/Talend-Studio/Use-client-certificate-with-jdbc-driver-and-postgresql/m-p/2345209#M112768 _AnonymousUser 2013-07-30T16:36:51Z https://community.qlik.com/t5/Talend-Studio/Use-client-certificate-with-jdbc-driver-and-postgresql/m-p/2345210#M112769 Hi <BR />Just search this issue on google and found a similar topic: <BR /> <A href="http://postgresql.1045698.n5.nabble.com/JDBC-with-SSL-td5046625.html" rel="nofollow noopener noreferrer">http://postgresql.1045698.n5.nabble.com/JDBC-with-SSL-td5046625.html</A> <BR />Hope it will help you! <BR />Shong Wed, 31 Jul 2013 12:38:08 GMT https://community.qlik.com/t5/Talend-Studio/Use-client-certificate-with-jdbc-driver-and-postgresql/m-p/2345210#M112769 Anonymous 2013-07-31T12:38:08Z