{"id":1444,"date":"2021-12-16T12:42:12","date_gmt":"2021-12-16T09:42:12","guid":{"rendered":"https:\/\/files2.tojikon.net\/files-cloud\/2021\/07\/14\/how-to-install-pgadmin-on-linux\/https:\/\/files2.tojikon.net\/files-cloud\/2021\/07\/14\/how-to-install-pgadmin-on-linux\/"},"modified":"2021-12-16T12:42:12","modified_gmt":"2021-12-16T09:42:12","slug":"how-to-install-pgadmin-on-linux","status":"publish","type":"post","link":"https:\/\/tojikon.net\/en\/1444-how-to-install-pgadmin-on-linux\/","title":{"rendered":"How to install Pgadmin on Linux"},"content":{"rendered":"
\n
\n

Related Articles<\/h3>\n<\/div>\n<\/section>\n

Pgadmin is an open-source administration and development tool for PostgreSQL, the open database software. This tool is essential for those who work heavily with PostgreSQL. Here\u2019s how to install the app on Linux.<\/p>\n

\"Pgadmin<\/p>\n

How to install Pgadmin on Ubuntu<\/h2>\n

PGAdmin is available for Ubuntu users via an Apt software repository. To start the installation, you\u2019ll first need to open up a terminal window. To open up a terminal window on the Ubuntu desktop, press the Ctrl + Alt + T\u00a0<\/strong>on the keyboard. Or, search for \u201cTerminal\u201d in the app menu and launch it that way.<\/p>\n

When the terminal window is open, use the\u00a0apt install\u00a0<\/strong>command to install the \u201cCurl\u201d program. This program will need to be installed to grab the Pgadmin key.\u00a0<\/p>\n

\nsudo apt install curl\n<\/pre>\n
Once the Curl app is installed, use it on Ubuntu to download the Pgadmin public key for the repository. This key is required to interact with installations in the repo.\u00a0<\/p>\n
\nsudo curl https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo apt-key add\n<\/pre>\n
Now that the key is added to your Ubuntu system, you will need to add the Pgadmin repository line to your software sources. The easiest way to do this is with the command below. It will automatically write the repo to a file so you can use it on Ubuntu with ease.<\/p>\n
\nsudo sh -c 'echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/$(lsb_release -cs) pgadmin4 main\" > \/etc\/apt\/sources.list.d\/pgadmin4.list\"\n<\/pre>\n
You\u2019ll need to update your system to finish setting up the repo.<\/p>\n
\nsudo apt update\n<\/pre>\n
Once the repo is set up on your Ubuntu system, the installation of Pgadmin can begin. Using the\u00a0apt install\u00a0<\/strong>command below, install the software.\u00a0<\/p>\n
For all Pgadmin software, execute the following command:<\/p>\n
\nsudo apt install pgadmin4\n<\/pre>\n
If you need the Desktop version of the application to Ubuntu, install the \u201cpgadmin4-desktop\u201d package onto your computer with the command below.<\/p>\n
\nsudo apt install pgadmin4-desktop\n<\/pre>\n
Lastly, if you only need the web version of Pgadmin on your Ubuntu system, use the command below to install the \u201cpgadmin4-web\u201d package using the command below.<\/p>\n
\nsudo apt install pgadmin4-web\n<\/pre>\n
How to install Pgadmin on Debian<\/h2>\n
\"\"<\/p>\n
The Pgadmin website has an Ubuntu logo, followed by the word \u201capt\u201d in the download section. However, it isn\u2019t just for Ubuntu, but every Linux OS that uses Apt as a package manager. For this reason, we know it will work on Debian.<\/p>\n
To get Pgadmin working on your Debian PC, you\u2019ll first need to open up a terminal window. To do that, press\u00a0Ctrl + Alt + T\u00a0<\/strong>on the keyboard. Or, search for \u201cTerminal\u201d in the app menu.<\/p>\n
With the terminal window open, use the\u00a0apt-get install\u00a0<\/strong>command to install the Curl tool. This tool is required to download the Pgadmin repo key.<\/p>\n
\nsudo apt-get install curl\n<\/pre>\n
Next, you must download the Pgadmin repository key to Debian. This key makes it possible to use the Pgadmin repo, so do not skip this step.<\/p>\n
sudo curl https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo apt-key add<\/p>\n
You\u2019ll now need to use the\u00a0sudo sh\u00a0<\/strong>command below to write out the Pgadmin repository to your Debian system.\u00a0<\/p>\n
\nsudo sh -c 'echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/$(lsb_release -cs) pgadmin4 main\" > \/etc\/apt\/sources.list.d\/pgadmin4.list'\n<\/pre>\n
Run the update command to refresh Debian\u2019s software sources. To do that, use the apt-get update\u00a0<\/strong>command.<\/p>\n
\nsudo apt-get update\n<\/pre>\n
How to install Pgadmin on Arch Linux<\/h2>\n
Pgadmin isn\u2019t officially supported on the Pgadmin website download page. However, Arch Linux officially packages this program in the Arch Linux repos, and users can install it and get updates regularly, just like any other Linux OS.<\/p>\n
To start the installation, open up a terminal window on the Arch Linux desktop. When the terminal window is open, use the\u00a0pacman\u00a0<\/strong>command below to install Pgadmin on your system.<\/p>\n
\nsudo pacman -S pgadmin\n<\/pre>\n
How to install Pgadmin on Fedora<\/h2>\n
Pgadmin3 is available in the Fedora Linux official software repos. However, this release is outdated, and while it works well, the official website has Pgadmin4 for Fedora and other RPM-based distributions.\u00a0<\/p>\n
To start the installation process, you must add the official repo to Fedora. To do that, download the official repo RPM using the command below.<\/p>\n
\nsudo rpm -i https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/yum\/pgadmin4-fedora-repo-2-1.noarch.rpm\n<\/pre>\n
When the package is installed, you\u2019ll be able to install the Pgadmin program onto Fedora.\u00a0<\/p>\n
For the desktop mode for Fedora, install the \u201cpgadmin4\u201d package using the\u00a0dnf\u00a0<\/strong>command below.<\/p>\n
\nsudo dnf install pgadmin4-desktop\n<\/pre>\n
For the web version of Pgadmin, install the \u201cpgadmin4-web\u201d package.\u00a0<\/p>\n
How to install Pgadmin on OpenSUSE<\/h2>\n
The latest release of Pgadmin (version 4) is available for installation in the OpenSUSE repos. To get it working, you can simply enter the following\u00a0zypper install\u00a0<\/strong>command down below.<\/p>\n
\nsudo zypper install pgadmin4\n<\/pre>\n
You\u2019ll have set up both the web and desktop mode on OpenSUSE Linux by installing the package above.<\/p>\n","protected":false},"excerpt":{"rendered":"
Related Articles Pgadmin is an open-source administration and development tool for PostgreSQL, the open database software. This tool is essential for those who work heavily with PostgreSQL. Here\u2019s how to install the app on Linux. How to install Pgadmin on Ubuntu PGAdmin is available for Ubuntu users via an Apt software repository. To start the …<\/p>\n","protected":false},"author":1,"featured_media":1445,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[21],"tags":[33],"_links":{"self":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1444"}],"collection":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/comments?post=1444"}],"version-history":[{"count":0,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/posts\/1444\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media\/1445"}],"wp:attachment":[{"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/media?parent=1444"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/categories?post=1444"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tojikon.net\/en\/wp-json\/wp\/v2\/tags?post=1444"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}