Postgres with SSL

[ricop]

Dear Beaver Team,

I am not able to connect to a Postgres database using SSL at all.

There are 2 different problems:

I did enable ssl on the 'Driver properties' tab of the JDBC Connection window.
For this I just put a 'true' in the value field.
But when I am clicking on 'Test connection' an error occurs:

"The connection attempt failed.
sun.security.validator.ValidatorException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target
"
Since in other tools its working well I guess its a problem somewhere in DBeaver.

The second problem is, when you put a value in the ssl field on the 'Driver properties' tab of the JDBC Connection window even if you remove it afterwards it will be consistent.
So you need to delete the connection to reset the field. Otherwise its keeping on trying to connect via SSL.


Thanks
Best regards

Rico

[Serge]

Currently DBeaver doesn't support SSL connections out of the box.
You could try to configure it manually if you are familiar with Java (instructions are at https://jdbc.postgresql.org/documentati ... lient.html).

Easy SSL support is in TODO and will be added in one of next versions.

[moktpy]

Not sure if this post is still relevant but I'm running into the same problem. Are there any updates on this?