Search
StarWind is a hyperconverged (HCI) vendor with focus on Enterprise ROBO, SMB & Edge

How to install and use DBeaver in Linux

  • September 21, 2021
  • 8 min read
IT Engineer and Technical Author. Karim is specializing in Linux, he is a prolific blogger who writes for various websites.
IT Engineer and Technical Author. Karim is specializing in Linux, he is a prolific blogger who writes for various websites.

In this article we are going to install and setup a Database management tool which is DBeaver. DBeaver is available for the cross platforms to support multiple databases including MySQL, Postgresql and GreenPlum. DBeaver can be used as an alternative of MySQL-Workbench and PGAdmin. It has a user-friendly interface that makes it more useful for its new users. Using DBeaver, you can create local databases and also configure the maximum result size to avoid session hanging issues in case the query results take time to process big queries.

DBeaver comes with a community edition which is free to use as well as with an enterprise edition that supports NoSQL Databases. We will be using its latest available community edition on a Linux CentOS 7 Desktop and LinuxMint Desktop.

Prerequisites:

The prerequisite for this article is to have a Linux System running with Linux based GUI system with user having sudo rights.

Login to your system and update with the latest available security updates using yum command as below.

For RHEL/CentOS:

For Ubuntu/LinuxMint:

Downloading DBeaver Community:

You can get the DBeaver Community edition download installer from their official web link https://dbeaver.io/download/ where you can choose the installer for your system.

Let’s get the RPM package for your RHEL/CentOS based system and DEBIAN in case you are using Ubuntu or LinuxMint.

Downloading DBeaver Community

Get it downloaded on your system and then upload on the server you have to make its setup or simply use the ‘wget’ command as below on your system.

On Ubuntu/LinuxMint:

Setup DBeaver

Installing DBeaver in Linux:

Once you have got your Dbeaver package uploaded, let install it using the command below.

On RHEL/CentOS:

On Debian/LinuxMint:

Installing DBeaver in Linux

Using DBeaver in Linux:

Now, as we have installed DBeaver, let’s open it from the menu or search it in the application finder.

Using DBeaver in Linux

You will be prompted with an option to create the sample database or start with a new connection.

Start work in DBeaver

Point to the Database tab and select to create a new connection by choosing your desired Database as shown below.

Point to the Database tab

Moving next to the database connection settings, give the details of your database server you want to connect with and click to finish.

Connection settings

As we have mentioned earlier, DBeaver supports multiple ranges of database engines, so in some cases, you may need to upload its jar files.

Just like in the image below, you can see that while loading the Greenplum DB it asks to load the required drivers that you can directly download.

Greenplum Database

In case if you don’t have internet access available on your system, you can take the offline jars required for your database and upload using the DBeaver Driver Manager.

DBeaver Driver Manager

Here, when you have successfully uploaded the jars, you can delete the old one which is not required for your db connection.

 

Setting JVM Parameters for DBeaver:

In case you have multiple databases and high workloads that may impact the performance of dbeaver. In that case you can also tweak its JVM parameters by editing the file below with its XMS and XMX values.

Conclusion:

At the end of this article, you should be familiar with the DBeaver, its installation setup on Linux and use of making DB Connections of your choice. It has many features that many other database managers don’t have like its support for multiple databases, OpenSource edition, SQL query execution and SSH tunneling etc. Hope you have found this article much helpful while working on DBeaver or while searching for a best Database manager solution.

Found Karim’s article helpful? Looking for a reliable, high-performance, and cost-effective shared storage solution for your production cluster?
Dmytro Malynka
Dmytro Malynka StarWind Virtual SAN Product Manager
We’ve got you covered! StarWind Virtual SAN (VSAN) is specifically designed to provide highly-available shared storage for Hyper-V, vSphere, and KVM clusters. With StarWind VSAN, simplicity is key: utilize the local disks of your hypervisor hosts and create shared HA storage for your VMs. Interested in learning more? Book a short StarWind VSAN demo now and see it in action!