<div dir="ltr"><p dir="ltr"><p dir="ltr">On Aug 24, 2016 7:14 AM, "Durumdara" <<a href="mailto:durumdara@gmail.com"
target="_blank">durumdara@gmail.com</a>>wrote:<br /> ><br /> > Dear Developers!<br /> ><br /> > We got a
server whichuses SSL connection with "ca-verify" mode only.<br /> ><br /> > It's very funny that I didn't find
anysoftware which supports this mode except pgAdmin3.<p dir="ltr">Although i haven't tried in a long time, I was able
toget LibreOffice Base connected with client certificate authentication. And of course, the headless psql client
supportscertificate authentication and is quite reliable.<p dir="ltr"> ><br /> > I checked HeidiSQL, DBeaver, EMS
ManagerLite, and PGAdmin.<br /> ><br /> > With PGAdminIII I can connect, but it's very sensitive to network and
itcrashes randomly.<p dir="ltr">I face a similar situation. pgAdmin3 does crash especially with poor quality network
connections.<p dir="ltr"> > And it's interesting - PGA3 can't connect without defining the root crt... Why???<p
dir="ltr">Theroot ca certificate is required to verify that the client is trusted by the ca, and therefore by the
server.It is also required to verify that the server is trusted, so you know you are connecting to your server rather
thanan impostor put up by hackers with a man-in-the-middle attack, dns poisoning, etc. <br /><p dir="ltr"><br /><p
dir="ltr">><br /> > EMS only plans the SSL with certificate.<br /> ><br /> > Yesterday I installed PGA4,
butI didn't find any option for certificates... Hmmm...<p dir="ltr">The client certificate authentication mechanism has
notyet been developped for pgAdmin4. The feature has been requested, but I don't know if anyone has started working on
it.I look forward to the addition of authentication options in pgAdmin4. <p dir="ltr"><br /><p dir="ltr"> ><br />
>Is this my mistake?<br /> ><br /> > Thanks for your help!<br /> ><br /> > dd<br /> ><br />
><br/> ><br /></div>