DBeaver on Ubuntu for PostgreSQL - Evanto/qna GitHub Wiki

Why DBeaver

Recently I was looking for a simple free database viewer for PostgreSQL/Ubutu 16.04. I failed to catch up on PgAdmin3, but came across a topic on HN where various GUI tools for PostgreSQL were discussed: Postage – A fast replacement for pgAdmin

These 2 options looked good: DBeaver and Valentina DB.

After checking out DBeaver vs Valentina Studio my conclusion was that DBeaver is a bit better, so I went for it. Seems a decent GUI to answer "What are the best Ubuntu GUIs for PostgreSQL?". This post contributed as well: You should be using DBeaver For more options, one can also read through good GUI tool for PostgreSQL?

Installing DBeaver

I used the Debian package - Linux Debian package 64 bit (installer). Take it here: DBeaver Downloads

  1. Make sure to download the correct installer according to your operating system architecture (32 or 64-bit)
  2. Download the installer from this page
  3. Once the download is complete, launch your terminal, go to the download location, here run: sudo dpkg -i dbeaver-ce_4.1.3_amd64.deb (sudo dpkg -i yourdbeaverversionhere)
  4. Once the installation process is complete, launch it from the Applications menu

Fixing error

Actually, here I've got an error at this step (after clicking DBeaver's icon from the menu):

A Java Runtime Environment (JRE) or Java Development Kit (JDK) must be available in order to run Dbeaver. No Java virtual machine was found after searching the following locations: /usr/share/dbeaver/jre/bin/java java in your current PATH

Also, in the terminal:

The following packages have unmet dependencies: 
Dbeaver-ce: Depends: openjdk-8-jre-headless but it is not installed or java-runtime-headless
E: Unmet dependencies. Try using -f.

A java runtime environment jre or java development kit jdk must be available in order to run DBeaver. This answer helped: Error while installing DBeaver On Ubuntu 14.04 As recommended, I've done 1 more command and got DBeaver up and running: sudo apt-get -f install So the full trace of DBeaver installation could look like this:

cd yourfolder
wget http://dbeaver.jkiss.org/files/dbeaver-ce_latest_amd64.deb
sudo dpkg -i dbeaver-ce_latest_amd64.deb
sudo apt-get -f install

Useful links: