PostgreSQL is a robust database system that comes with so many features. It is a great solution for both personal and enterprise users. A great and complex database system requires a robust and powerful management tool. There are many PostgreSQL Client software for Linux you can choose. But today, I got a chance to review the new DBeaver 6.2.4. I have installed the PostgreSQL 12 on my Ubuntu 19.10 previously.
I am installing DBeaver on my Ubuntu 19.10 desktop. Basically, this tool supports Windows, Mac as well as Linux. The developer provides binary installation file for some major Linux distribution such as Ubuntu, Debian, CentOS, RedHat and almost any Linux distribution actually. You can obtain the installation file for your specific operating system using this official link.
Install DBeaver in Ubuntu 19.10
If you are using Ubuntu, choose the DEB file from the download link above. Save it to your local directory. To install DBeaver, simply right-click the DEB file and choose Open with Software Install. In few moments, it should be ready for use.
As you know, DBeaver supports various database system and not limited to PostgreSQL. You can use it to manage MySQL, SQL Server, MariaDB, Oracle and many others. But I will focus on the PostgreSQL server only.
Connect DBeaver to PostgreSQL
To create the first database connection, go to Database >> New Database Connection. Choose PostgreSQL from the list and then click Next button. Enter the PostgreSQL server credentials.
If this is your first PostgreSQL connection, likely you will see the following window that tells us to download/install additional driver.
Click Download button and this will automatically install the required files. Confirm the connection using the Test Connection button. Make sure it works as shown below.
Now you should connected to the database
I think that’s it for now. Thank you for reading this article. I hope you enjoy it.