![]() So, it must be pre-installed on Ubuntu in order to install pgAdmin. “curl” is a command line utility and it is a prerequisite for the pgAdmin installation. To install pgAdmin on Ubuntu, add the public key using Curl, add the pgAdmin repository using sudo, and execute the “sudo apt install pgAdmin4” command. The output shows that the “PostgreSQL 14.7” is running on our Ubuntu machine. ![]() Use the “VERSION()” function to check the currently installed Postgres version on Ubuntu: The above snippet depicts that the new server has been successfully added.Įxpand the “Databases” tab, select a database, right-click on it, and select the “Query Tool”: under the “Connection” tab and hit the “Save” button:Ĭlicking on the save button will show you the following window: Specify the details like hostname, password, etc. Specify the server’s name and navigate to the “Connection” tab: To add a new server, you must click on the “Add New Server” button, as shown in the following snippet: Specify the master password and hit the “OK” button. Now click on the “Show Applications” button, type “pgAdmin” in the search bar, and left-click on the “pgAdmin4” application to launch it:Ĭlicking on the “pgAmin4” will lead you to the following window: Type “y” and press the “ENTER” button to proceed the further installation:įinally, the pgAdmin4 has been successfully installed on Ubuntu 22.04. Now execute the following “sudo” command to install pgAdmin on your system: sudo apt install pgadmin4 Step 2: Add pgAdmin Repository and Update Server’s PackagesĮxecuting the below-provided command will add the pgAdmin repository and update the server’s packages: sudo sh -c 'echo "deb $(lsb_release -cs) pgadmin4 main" > /etc/apt//pgadmin4.list & apt update' Therefore, first, we need to add the public key for the repository using the following command: sudo curl | sudo apt-key add PgAdmin cannot be installed without the public key, because it isn't available/listed in the Ubuntu repositories. Once the “curl” is successfully installed on your Ubuntu machine, you can install pgAdmin without any obstacles. Execute the following command if curl isn't yet installed on your system: sudo apt install curl The “curl” utility must be pre-installed on Ubuntu in order to install pgAdmin. ![]() “curl” is a command line utility that helps us transfer data from one server to another. You must follow the below-given step-by-step instructions to install pgAdmin on the ubuntu operating system: This post presents a practical demonstration of how to install pgAdmin on Ubuntu. However, in Ubuntu, you have to install it manually. When you install Postgres on the Windows operating system, " pgAdmin" is installed by default. It provides numerous features, such as a user-friendly graphical interface, local and remote session management, compatibility with all Postgres versions, etc.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |