{"id":22713,"date":"2023-10-28T08:31:59","date_gmt":"2023-10-28T08:31:59","guid":{"rendered":"https:\/\/linuxways.net\/?p=22713"},"modified":"2023-10-28T08:31:59","modified_gmt":"2023-10-28T08:31:59","slug":"how-to-install-pgadmin-in-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/linuxways.net\/de\/ubuntu\/how-to-install-pgadmin-in-ubuntu-22-04\/","title":{"rendered":"How to Install pgAdmin in Ubuntu 22.04?"},"content":{"rendered":"

pgAdmin <\/strong>is the widely used and most popular GUI-based management Tool for PostgreSQL. \u201cpgAdmin\u201d is an advanced open-source tool that offers a better Graphical User Interface, and a simplified schema, and it also simplifies the use and creation of Database Objects. \u201cpgAdmin\u201d interacts with the PostgreSQL determined to Develop, Test and Maintain Databases.<\/p>\n

This article explains how you can install \u201cpgAdmin\u201d in Ubuntu 22.04.<\/p>\n

How to Install pgAdmin in Ubuntu 22.04?<\/strong><\/h2>\n

pgAdmin is Installed from the pgAdmin Repository. While installing pgAdmin, you can either install both the web mode and desktop mode together, which the \u201capt install pgadmin4<\/strong>\u201d command does by default, or you can install pgAdmin Web Mode and pgAdmin Desktop Mode individually as well. Below are the steps that demonstrate how you can install pgAdmin in your Ubuntu System.<\/p>\n

Step 1: Update Packages<\/strong><\/h3>\n

Before installing \u201cpgAdmin\u201d, update the existing Ubuntu Repository to look for any packages that require upgrades. Use the \u201capt update\u201d command with sudo privileges:<\/p>\n

sudo<\/span> apt update<\/div><\/div>\n

Enter the sudo user password to look for updates in the packages:<\/p>\n

<\/p>\n

Once the Terminal completes updating, upgrade your Ubuntu Repository now with the \u201cupgrade\u201d command. Use the \u201capt upgrade\u201d command with sudo privileges to upgrade any packages that require to be upgraded to the latest version:<\/p>\n

sudo<\/span> apt upgrade<\/div><\/div>\n

Enter \u201cY\u201d during the upgradation to continue the process:<\/p>\n

<\/p>\n

Step 2: Install \u201ccurl\u201d<\/strong><\/h3>\n

Once the existing packages are updated, install \u201ccurl\u201d before you download \u201cpgAdmin\u201d. The \u201ccurl\u201d command downloads any packages from a server. With curl, not only can you Download packages, but you can also use it to transfer data to a server and retrieve data from a server. In most Ubuntu Systems, curl is pre-installed. If your system is missing curl, use the \u201capt install\u201d command to install curl:<\/p>\n

sudo<\/span> apt install<\/span> curl<\/div><\/div>\n

In our case, it was already installed:<\/p>\n

<\/p>\n

Step 3: Download \u201cpgAdmin\u201d<\/strong><\/h3>\n

Now once \u201ccurl\u201d is installed, Open any Web Browser to download \u201cpgAdmin\u201d. In our case, we opened the Firefox Browser:<\/p>\n

<\/p>\n

\u201cpgAdmin\u201d should be downloaded from the official \u201cpgAdmin\u201d Website. Either search for the \u201cpgAdmin\u201d website or Download pgAdmin<\/a> directly by visiting the web page.<\/p>\n

<\/p>\n

On the official web page of \u201cpgAdmin\u201d, click on the Download option in the Navigation Bar:<\/p>\n

<\/p>\n

The Download page will appear which will consist of Operating System Options for \u201cpgAdmin\u201d packages. As you are using Ubuntu, click on the \u201cAPT\u201d option for the \u201cpgAdmin 4\u201d:<\/p>\n

<\/p>\n

The various Ubuntu Versions that are available for the pgAdmin APT Repository will be listed. Choose the APT repository for Ubuntu 22.04 Version:<\/p>\n

<\/p>\n

Scroll Down and you will see the \u201cpgAdmin\u201d repository setup commands for Ubuntu:<\/p>\n

<\/p>\n

Download the Public Key for the \u201cpgAdmin\u201d Repository using the \u201ccurl\u201d command:<\/p>\n

curl -fsS<\/span> https:\/\/<\/span>www.pgadmin.org\/<\/span>static\/<\/span>packages_pgadmin_org.pub |<\/span> sudo<\/span> gpg --dearmor<\/span> -o<\/span> \/<\/span>usr\/<\/span>share\/<\/span>keyrings\/<\/span>packages-pgadmin-org.gpg<\/div><\/div>\n

The cursor moves to the next line in the Terminal indicating the Public Key was added:<\/p>\n

<\/p>\n

Now, Set up the Repository for the \u201cpgAdmin\u201d Configuration File using the command:<\/p>\n

sudo<\/span> sh<\/span> -c<\/span> 'echo "deb [signed-by=\/usr\/share\/keyrings\/packages-pgadmin-org.gpg] https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/$(lsb_release -cs) pgadmin4 main" > \/etc\/apt\/sources.list.d\/pgadmin4.list && apt update'<\/span><\/div><\/div>\n

The repository will be added to the Configuration File:<\/p>\n

<\/p>\n

Step 4: Install \u201cpgAdmin\u201d<\/strong><\/h3>\n

Once the Public Key and the Packages are added to the Configuration File, install \u201cpgAdmin\u201d with the \u201capt install\u201d command:<\/p>\n

sudo<\/span> apt install<\/span> pgadmin4<\/div><\/div>\n

The Terminal will start installing the packages, and wait for the installation process to complete:<\/p>\n

<\/p>\n

Step 5: Configure Web Interface<\/strong><\/h3>\n

After the packages are added and \u201cpgAdmin\u201d is installed, you have to configure the \u201cpgAdmin\u201d interface to start working with it. The first step in the configuration includes setting up the \u201cpgAdmin 4\u201d for web mode and then configuring the \u201cpgAdmin\u201d user account. Run the \u201csetup-web.sh\u201d script which will set up the pgAdmin 4 in Web Mode with the \u201csudo\u201d command:<\/p>\n

sudo<\/span> \/<\/span>usr\/<\/span>pgadmin4\/<\/span>bin\/<\/span>setup-web.sh<\/div><\/div>\n

Once the Web Mode Configuration for \u201cpgAdmin\u201d is completed, the Terminal will ask for the initial \u201cpgAdmin\u201d user account details:<\/p>\n

<\/p>\n

Enter the email and password for the initial \u201cpgAdmin 4\u201d user:<\/p>\n

<\/p>\n

Once you Retype the password and hit \u201cEnter\u201d, the \u201cpgAdmin\u201d application will ask for the Apache Web Server configuration and mount the \u201cpgAdmin 4\u201d at \u201c\/pgadmin4\u201d:<\/p>\n

<\/p>\n

Enter \u201cy\u201d to continue configuring Apache Server and mounting the pgAdmin Application. As soon as the Apache Server is Configured, it will ask for the Server Restart. Enter \u201cy\u201d again to complete the pgAdmin installation. After the Apache Server restarts, the Terminal will show the local host URL where you can use the \u201cpgAdmin 4\u201d Application:<\/p>\n

<\/p>\n

Starting pgAdmin in Web Mode<\/strong><\/h2>\n

You can use the pgAdmin application once it is initialized. Once you\u2019ve installed and configured pgAdmin, the Terminal displays the local host link which can be used in the URL of a browser to access pgAdmin. Usually, the pgAdmin Web Application runs on the \u201c127.0.0.1\/pgadmin4\u201d URL:<\/p>\n

<\/p>\n

Clicking on the URL will redirect you to the Web page on the Default Web Browser and open the pgAdmin Web Page:<\/p>\n

<\/p>\n

In the Email and Password Input boxes, enter the email and password of the user that you created while configuring the pgAdmin Web Mode in the Terminal:<\/p>\n

<\/p>\n

Once the email and password are entered, click on the Login button to access the pgAdmin Account:<\/p>\n

<\/p>\n

Wait for the pgAdmin User Page to load:<\/p>\n

<\/p>\n

The pgAdmin User Account Dashboard will open where you can Add a New Server, Configure Your Account, and do much more:<\/p>\n

<\/p>\n

This is one way of starting the pgAdmin Application through Web Mode.<\/p>\n

Starting pgAdmin in Desktop Mode<\/strong><\/h2>\n

The pgAdmin Application can also be used as an Ubuntu Application on the Desktop instead of using the Web browser and then accessing the pgAdmin through the URL. While installing the pgAdmin Application through the Repository, both the Desktop and the Web Mode for the pgAdmin Application are installed.<\/p>\n

If the pgAdmin Desktop Mode is not installed on your Ubuntu System, use the \u201capt install\u201d command to install pgAdmin:<\/p>\n

sudo<\/span> apt install<\/span> pgadmin4-desktop<\/div><\/div>\n

The \u201cpgAdmin4-desktop\u201d command only installs the Desktop Version of pgAdmin. Once installed, open the Applications Menu from your Ubuntu Home Screen:<\/p>\n

In the Applications Menu, click on the Search Bar to type the Application you want to search:<\/p>\n

<\/p>\n

As we want to open pgAdmin, type pgAdmin in the Search Box. The pgAdmin Application icon will appear. Click on the application icon to start the application:<\/p>\n

<\/p>\n

Wait for the application to initialize:<\/p>\n

<\/p>\n

Once the pgAdmin Application starts, you will see the pgAdmin Home Screen where you can add a New Server and make changes to your pgAdmin account as well:<\/p>\n

<\/p>\n

Registering a Server in \u201cpgAdmin\u201d<\/strong><\/h2>\n

A new Server can be added to the pgAdmin Application. To Register a New Server, right-click on the Servers option in the left panel of the Application:<\/p>\n

<\/p>\n

A drop-down menu will appear where you can register, create, refresh, and remove server groups. Click on the Register to expand it. In the additional expanded Register Option, click on the \u201cServer\u201d to Register your own Server:<\/p>\n

<\/p>\n

The Server Registration Menu will appear:<\/p>\n

<\/p>\n

Enter the Name of your Server in the \u201cName\u201d Field:<\/p>\n

<\/p>\n

In our case, we added the name \u201clocalhost\u201d. Once you have added the name click on the Connection option from the Menu Options:<\/p>\n

<\/p>\n

Now in the Connection Menu, the Port, maintenance Database, and username are pre-added. Add the Host Name only if you want to continue with the custom default settings:<\/p>\n

<\/p>\n

Once the Hostname, username, and password are added for the new Server, click on the \u201cSave\u201d button:<\/p>\n

<\/p>\n

The connections will be made successfully. If the connection fails, you have to set a password for your Postgres account as during the Creation of the Postgres Account, the password is not required:<\/p>\n

<\/p>\n

To set the password for the User, Switch to the Postgres User with the command:<\/p>\n

sudo<\/span> -i<\/span> -u<\/span> <<\/span>userName><\/span><\/div><\/div>\n

In our case, the user name is \u201cdarren\u201d. Thus, to switch to the \u201cdarren\u201d Postgres User, the \u201csudo\u201d command will be:<\/p>\n

sudo<\/span> -i<\/span> -u<\/span> darren<\/div><\/div>\n

This will change the Command line to the Postgres Account for darren:<\/p>\n

<\/p>\n

Now, you have to Access the PostgreSQL Prompt with the following command:<\/p>\n

psql<\/div><\/div>\n

Once you have accessed the User PostgreSQL Prompt, you can run commands and queries. The \u201c=#<\/strong>\u201d indicates the PostgreSQL Prompt is currently being used:<\/p>\n

<\/p>\n

You can now set the password for the Postgres User with the command \u201cpassword\u201d followed by the username of the User:<\/p>\n

\\password <<<\/span>strong><\/span>userName<\/<\/span>strong>><\/span><\/div><\/div>\n

In our case, the user is \u201cdarren\u201d. Thus to set the password for \u201cdarren\u201d, the command will be:<\/p>\n

\\password darren<\/div><\/div>\n

The Command Line will ask you to Enter the New Password and then Retype the Password for confirmation:<\/p>\n

<\/p>\n

Once the Password is set for the User \u201cdarren\u201d, open the pgAdmin Connection Menu again and retype the new password. Click on the \u201cSave\u201d button as soon as you are done with the configuration:<\/p>\n

<\/p>\n

After the connection is set, you will see the server activity on the pgAdmin Dashboard:<\/p>\n

<\/p>\n

Moreover, you can expand the Servers and look for the \u201clocalhost\u201d server that you created earlier:<\/p>\n

<\/p>\n

Expanding the \u201clocalhost\u201d server will list the options for Databases, Tablespaces, and User Roles:<\/p>\n

<\/p>\n

At this point, you are all set to use pgAdmin to perform any specific Postgres tasks.<\/p>\n

Conclusion<\/strong><\/h2>\n

pgAdmin <\/strong>can be installed with the \u201capt install pgadmin4\u201d command, but before the installation, the Public Key should be added and the configuration file for the pgAdmin Repository should be set up. Once pgAdmin is installed, we can either use the Web Mode or the Desktop Mode. Each step is discussed in detail in this article.<\/p>","protected":false},"excerpt":{"rendered":"

To install pgAdmin on Ubuntu 22.04, first, add the public key, set up the repository configuration file, and then run the \u201capt install pgadmin4\u201d command. <\/p>","protected":false},"author":110,"featured_media":22753,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-22713","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu"],"_links":{"self":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/22713","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/users\/110"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/comments?post=22713"}],"version-history":[{"count":0,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/posts\/22713\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media\/22753"}],"wp:attachment":[{"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/media?parent=22713"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/categories?post=22713"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxways.net\/de\/wp-json\/wp\/v2\/tags?post=22713"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}