How To Install pgadmin3 on Ubuntu 20.04
Introduction
In this tutorial we learn how to install pgadmin3 on Ubuntu 20.04.
What is pgadmin3
pgadmin3 is:
pgAdmin III is a database design and management application for use with PostgreSQL. The application can be used to manage PostgreSQL 7.3 and above and has been tested with PostgreSQL 10.
pgAdmin III is designed to answer the needs of all users, from writing simple SQL queries to developing complex databases. The graphical interface supports all PostgreSQL features and makes administration easy. The application also includes a syntax highlighting SQL editor, a server-side code editor, an SQL/batch/shell job scheduling agent, support for the Slony-I replication engine and much more. Server connection may be made using TCP/IP or Unix Domain Sockets (on *nix platforms), and may be SSL encrypted for security. No additional drivers are required to communicate with the database server.
There are three methods to install pgadmin3 on Ubuntu 20.04. We can use apt-get, apt and aptitude. In the following sections we will describe each method. You can choose one of them.
Install pgadmin3 Using apt-get
Update apt database with apt-get using the following command.
sudo apt-get update
After updating apt database, We can install pgadmin3 using apt-get by running the following command:
sudo apt-get -y install pgadmin3
Install pgadmin3 Using apt
Update apt database with apt using the following command.
sudo apt update
After updating apt database, We can install pgadmin3 using apt by running the following command:
sudo apt -y install pgadmin3
Install pgadmin3 Using aptitude
If you want to follow this method, you might need to install aptitude first since aptitude is usually not installed by default on Ubuntu. Update apt database with aptitude using the following command.
sudo aptitude update
After updating apt database, We can install pgadmin3 using aptitude by running the following command:
sudo aptitude -y install pgadmin3
How To Uninstall pgadmin3 on Ubuntu 20.04
To uninstall only the pgadmin3 package we can use the following command:
sudo apt-get remove pgadmin3
Uninstall pgadmin3 And Its Dependencies
To uninstall pgadmin3 and its dependencies that are no longer needed by Ubuntu 20.04, we can use the command below:
sudo apt-get -y autoremove pgadmin3
Remove pgadmin3 Configurations and Data
To remove pgadmin3 configuration and data from Ubuntu 20.04 we can use the following command:
sudo apt-get -y purge pgadmin3
Remove pgadmin3 configuration, data, and all of its dependencies
We can use the following command to remove pgadmin3 configurations, data and all of its dependencies, we can use the following command:
sudo apt-get -y autoremove --purge pgadmin3
References
Summary
In this tutorial we learn how to install pgadmin3 package on Ubuntu 20.04 using different package management tools: apt, apt-get and aptitude.
