{"id":4941,"date":"2023-05-04T15:41:32","date_gmt":"2023-05-04T15:41:32","guid":{"rendered":"https:\/\/www.webhi.com\/how-to\/?p=4941"},"modified":"2023-05-04T15:43:05","modified_gmt":"2023-05-04T15:43:05","slug":"how-to-install-pgadmin4-on-ubuntu-18-04-20-04-22-04","status":"publish","type":"post","link":"https:\/\/www.webhi.com\/how-to\/how-to-install-pgadmin4-on-ubuntu-18-04-20-04-22-04\/","title":{"rendered":"How to Install PgAdmin4 on Ubuntu 18.04 \/ 20.04 \/ 22.04"},"content":{"rendered":"\n
\"Installing<\/figure>\n\n\n\n

PgAdmin4 is an open-source administration and management tool for PostgreSQL, and it can be installed on Ubuntu in just a few easy steps. In this article, we will provide you with a step-by-step guide on how to install PgAdmin4 on Ubuntu.<\/p>\n\n\n\n

Step 1: Update your Ubuntu system<\/h2>\n\n\n\n

Before you begin installing PgAdmin4, it is recommended to update your Ubuntu system to ensure that you have the latest security patches and bug fixes.<\/p>\n\n\n\n

To update your Ubuntu system, open a terminal and enter the following command:<\/p>\n\n\n\n

$ sudo apt update && sudo apt upgrade -y<\/span><\/code><\/pre>\n\n\n\n
This will update your system and install any available upgrades.<\/p>\n\n\n\n
Step 2: Install PostgreSQL<\/h2>\n\n\n\n
PgAdmin4 is a management tool for PostgreSQL, so you need to have PostgreSQL installed on your system. To install PostgreSQL, enter the following command:<\/p>\n\n\n\n
$ sudo apt install postgresql postgresql-contrib -y<\/span><\/code><\/pre>\n\n\n\n
This command will install the PostgreSQL server and some additional utilities that you may find useful.<\/p>\n\n\n\n
For a detailed tutorial, visit our guide on How to Install PostgreSQL in Ubuntu 18.04\/ 20.4\/ 22.04.<\/a><\/p>\n\n\n\n
Step 3: Install PgAdmin4<\/h2>\n\n\n\n
To install PgAdmin4, you need to add the repository for the latest version of PgAdmin4 to your system. To do this, enter the following commands in your terminal:<\/p>\n\n\n\n
$ sudo curl https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo apt-key add<\/span><\/code><\/pre>\n\n\n\n
This command adds the public key for the PgAdmin4 repository to your system.<\/p>\n\n\n\n
Next, add the repository to your system’s sources.list file by running the following command:<\/p>\n\n\n\n
$ echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/$(lsb_release -cs) pgadmin4 main\" | sudo tee \/etc\/apt\/sources.list.d\/pgadmin4.list<\/span><\/code><\/pre>\n\n\n\n
This command adds the repository for the latest version of PgAdmin4 to your system’s sources.list file.<\/p>\n\n\n\n
Now update your system’s package list:<\/p>\n\n\n\n
$ sudo apt update<\/span><\/code><\/pre>\n\n\n\n
And finally, install PgAdmin4 by running the following command:<\/p>\n\n\n\n
$ sudo apt install pgadmin4<\/code><\/pre>\n\n\n\n
This command installs PgAdmin4 and all its dependencies.<\/p>\n\n\n\n
Step 4: Access PgAdmin4<\/h2>\n\n\n\n
After installation, you can access PgAdmin4 by opening your web browser and entering the following URL:<\/p>\n\n\n\n
http:\/\/localhost\/pgadmin4<\/pre>\n\n\n\n
This will open the PgAdmin4 login page. Enter your login credentials (default username is “pgadmin4@pgadmin.org<\/a>” and default password is “admin”) and click the “Sign in” button to access the PgAdmin4 web interface.<\/p>\n\n\n\n
Step 5: Configure PgAdmin4<\/h2>\n\n\n\n
Once you have logged in to PgAdmin4, you may want to configure it to suit your needs. You can do this by clicking on the “File” menu and selecting “Preferences”.<\/p>\n\n\n\n
Here you can configure various settings such as the default server group, the default language, and the default font size. You can also configure advanced settings such as SSL certificates, email notifications, and backup options.<\/p>\n\n\n\n
Step 6: Create a Server<\/h2>\n\n\n\n
To start managing your PostgreSQL databases using PgAdmin4, you need to create a server. To do this, click on the “Servers” menu and select “Create Server”.<\/p>\n\n\n\n
In the “Create – Server” dialog box, enter the following details:<\/p>\n\n\n\n