PostgreSQL Graphical User Interface (GUI) tools allow to easily interact with the workspace database from the VM. These graphical database management tools help users manipulate, visualize, and manage the data stored in the database.
Installing database GUIs
1. Download drivers
Database drivers are needed to connect the GUIs with the workspace database. A driver is a computer program that will connect a generic interface to a specific database implementation.
Most database GUIs require a JDBC (Java Database Connectivity) driver. Please download the PostgreSQL JDBC driver from here.
2. Download GUI
DBeaver and DBVisualizer are examples of database GUIs that you can install in your workspace in either a Windows or Linux VM in your workspace.
First, download the installation files of a preferred database GUI for your VM operating system on your local computer:
Then, upload them to the workspace together with the previously downloaded JDBC driver.
3. Install GUI
If you are working in a Windows VM, simply run the installation file and follow the installation instructions.
To run the installation in a Linux VM, move to the same folder as the installation file and run:
sudo dpkg -i <installation_file>.deb
Once installed, you can start it by typing
dbvis for DBeaver and DBVisualizer, respectively.
4. Configure the database connection
The credentials of the database are needed to connect the GUI with the workspace database. For security reasons, please contact the Service Desk to finish the configuration.
Working with database GUIs
Once the connection is set up, you can explore the workspace database using the database navigator found in the left-hand sidebar in both of the GUIs.
You can also easily view the table data, create and run SQL queries, and view Entity-Relationship diagrams using these tools. To find out how to do this, please visit the DBeaver and DBVisualizer documentation sites.