dbeaver error when connecting to postgresql

so i happened to experience error when trying to connect to postgresql via dbeaver.

after lurking on the internet there are three steps need to do:

  • install jdbc driver for postgresql here https://jdbc.postgresql.org/
  • check if java already installed:
    by opening command prompt and type this:

where java

if error then java is not installed, you need to install java.

  • after that then you need to copy the ca sertificate from java to dbeaver installation directory.
    from java installation go to lib/security folder, there you’ll see cacert file, copy and paste it to the same lib/security inside dbeaver installation folder, just overwrite the current cacerts file.
  • then go to dbeaver installation folder llok for dbeaver.ini file, erase this line:

-Djavax.net.ssl.trustStoreType=WINDOWS-ROOT

try closing the dbeaver apps if open, the try opening the app again and try to connect to progresql db, it should be working right now and auto download necesary files.