{"id":32662,"date":"2021-07-14T12:30:00","date_gmt":"2021-07-14T17:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=32662"},"modified":"2022-06-03T03:31:37","modified_gmt":"2022-06-03T08:31:37","slug":"how-to-install-phppgadmin-on-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/","title":{"rendered":"How To Install phpPgAdmin On Ubuntu 20.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" width=\"742\" height=\"372\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg\" alt=\"how to install phppgadmin on ubuntu 20.04\" class=\"wp-image-37619\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04-150x75.jpg 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/figure><\/div>\n\n\n\n<p>PostgreSQL is one of many powerful and famous object-relational database systems. It is a free and open-source database management system. Usually, people manage their PostgreSQL databases through a command-line interface, which might give some difficulties to novice users.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" width=\"200\" height=\"200\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/07\/install-phppgadmin-on-ubuntu-20.04.png\" alt=\"install phppgadmin on ubuntu 20.04\" class=\"wp-image-37755\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/07\/install-phppgadmin-on-ubuntu-20.04.png 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/07\/install-phppgadmin-on-ubuntu-20.04-150x150.png 150w\" sizes=\"(max-width: 200px) 100vw, 200px\" \/><\/figure><\/div>\n\n\n\n<p>PhpPgAdmin is an open-source web administration interface for PostgreSQL written in PHP. It is used to manage PostgreSQL databases through a web interface.<\/p>\n\n\n\n<p>In this tutorial, we will show you how to install PhpPgAdmin on an <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\">Ubuntu 20.04 VPS<\/a>.<\/p>\n\n\n\n<!--more-->\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69cb082149b63\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"ez-toc-cssicon\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-69cb082149b63\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#Prerequisites\" >Prerequisites<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#Step-1-Log-in-via-SSH-and-update-the-system\" >Step 1. Log in via SSH and update the system<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#Step-2-Install-PostgreSQL-server\" >Step 2. Install PostgreSQL server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#Step-3-Configure-PostgreSQL\" >Step 3. Configure PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#Step-4-Install-PhpPgAdmin\" >Step 4. Install PhpPgAdmin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#Step-5-Install-Apache-and-PHP\" >Step 5. Install Apache and PHP<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-prerequisites\"><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Ubuntu 20.04<\/li><li>SSH root access or a non-root user with sudo privileges<\/li><li>Apache and PHP<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-1-log-in-via-ssh-and-update-the-system\"><span class=\"ez-toc-section\" id=\"Step-1-Log-in-via-SSH-and-update-the-system\"><\/span>Step 1. Log in via SSH and update the system<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Log in to your Ubuntu 20.04 VPS<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">ssh root@IP_Address -p Port_number<\/pre>\n\n\n\n<p>Make sure to replace \u201cIP_Address\u201d and \u201cPort_number\u201d with your server\u2019s actual IP address and SSH port number.<\/p>\n\n\n\n<p>Once logged in, you can check whether you have the proper Ubuntu version installed on your server with the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># lsb_release -a<\/pre>\n\n\n\n<p>You should get this output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Distributor ID: Ubuntu\nDescription: Ubuntu 20.04 LTS\nRelease: 20.04\nCodename: focal<\/pre>\n\n\n\n<p>Then, run the following command to make sure that all installed packages on the server are updated to the latest available version.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># apt update &amp;&amp; apt upgrade -y<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-2-install-postgresql-server\"><span class=\"ez-toc-section\" id=\"Step-2-Install-PostgreSQL-server\"><\/span>Step 2. Install PostgreSQL server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>When writing this tutorial, the default PostgreSQL version in the repository is PostgreSQL 12.&nbsp; Let&#8217;s run the following command to install PostgreSQL server.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># apt install postgresql postgresql-client postgresql-client-common postgresql-common postgresql-contrib -y<\/pre>\n\n\n\n<p>Once installed, the service will automatically be started, you can check the status with this command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\"># systemctl status postgresql<\/pre>\n\n\n\n<p>It will show you the status<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">root@ubuntu-20:~# systemctl status postgresql\n\n\u25cf postgresql.service - PostgreSQL RDBMS\n Loaded: loaded (\/lib\/systemd\/system\/postgresql.service; enabled; vendor preset: enabled)\n Active: active (exited) since Tue 2020-05-19 04:39:03 CEST; 25 minutes ago\n\nMain PID: 137654 (code=exited, status=0\/SUCCESS)\nTasks: 0 (limit: 2286)\nMemory: 0B\nCGroup: \/system.slice\/postgresql.service\nMay 19 04:39:03 ubuntu-20 systemd[1]: Starting PostgreSQL RDBMS...\nMay 19 04:39:03 ubuntu-20 systemd[1]: Finished PostgreSQL RDBMS.<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-3-configure-postgresql\"><span class=\"ez-toc-section\" id=\"Step-3-Configure-PostgreSQL\"><\/span>Step 3. Configure PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By default, the PostgreSQL server will listen on localhost. If you want to access from another network, we need to modify the configuration file to listen on all addresses or a specific address, this time we will make it listen on all addresses.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># nano \/etc\/postgresql\/12\/main\/postgresql.conf<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>listen_addresses = '*'\n<\/code><\/pre>\n\n\n\n<p>Edit the PostgreSQL configuration file (<code>pg_hba.conf<\/code>) and enable md5 passwords for local connections to enable password authentication.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># nano \/etc\/postgresql\/12\/main\/pg_hba.conf<\/code><\/pre>\n\n\n\n<p>Replace the following:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>local   all             postgres                                peer\nlocal   all             all                                     peer\n<\/code><\/pre>\n\n\n\n<p>With this one:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>local   all             postgres                                md5\nlocal   all             all                                     md5\n<\/code><\/pre>\n\n\n\n<p>Restart the PostgreSQL service to apply the changes with the following command<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># systemctl restart postgresql \n<\/code><\/pre>\n\n\n\n<p>Now, if you want to access the PostgreSQL shell using user &#8216;postgres&#8217;, you will be asked for the password you created earlier.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>root@ubuntu-20:~# su - postgres\npostgres@ubuntu-20:~$ psql\nPassword for user postgres:\npsql (12.2 (Ubuntu 12.2-4))\nType \"help\" for help.\npostgres=#<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-4-install-phppgadmin\"><span class=\"ez-toc-section\" id=\"Step-4-Install-PhpPgAdmin\"><\/span>Step 4. Install PhpPgAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>In this tutorial, we will install PhpPgAdmin from the Ubuntu repository, although you can also install it from the source or the deb package.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># apt install phppgadmin php-pgsql -y\n<\/code><\/pre>\n\n\n\n<p>To allow login using user root or postgres, we need to modify the phpPgAdmin configuration.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># nano \/etc\/phppgadmin\/config.inc.php\n<\/code><\/pre>\n\n\n\n<p>Find the following value<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&nbsp;$conf&#91;'extraloginsecurity'] = false;\n<\/code><\/pre>\n\n\n\n<p>and replace with<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&nbsp;$conf&#91;'extraloginsecurity'] = true;\n<\/code><\/pre>\n\n\n\n<p>We can also configure phpPgAdmin to only show databases owned by the logged-in user, modify this line.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$conf&#91;'owned_only'] = false;\n<\/code><\/pre>\n\n\n\n<p>and change the value to:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$conf&#91;'owned_only'] = true;\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-5-install-apache-and-php\"><span class=\"ez-toc-section\" id=\"Step-5-Install-Apache-and-PHP\"><\/span>Step 5. Install Apache and PHP<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>If you already have Apache and PHP installed, you can skip this step.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># apt install apache2 php libapache2-mod-php -y\n<\/code><\/pre>\n\n\n\n<p>Now, let&#8217;s create an Apache configuration file for phpPgAdmin<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># nano \/etc\/apache2\/sites-enabled\/phppgadmin.conf<code><\/code><\/code><\/pre>\n\n\n\n<p>We are going to create an Apache configuration for phpPgAdmin, and it will be an alias.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Alias \/phppgadmin \/usr\/share\/phppgadmin\n&lt;Directory \/usr\/share\/phppgadmin&gt;\n   &lt;IfModule mod_dir.c&gt;\n       DirectoryIndex index.php\n   &lt;\/IfModule&gt;\nAllowOverride None\n   &lt;IfModule mod_php.c&gt;\n      php_flag magicquotes_gpc Off\n      php_flag trackvars On\n   &lt;\/IfModule&gt;\n   &lt;IfModule !mod_php.c&gt;\n     &lt;IfModule mod_actions.c&gt;\n       &lt;IfModule mod_cgi.c&gt;\n          AddType application\/x-httpd-php .php\n          Action application\/x-httpd-php \/cgi-bin\/php\n       &lt;\/IfModule&gt;\n       &lt;IfModule mod_cgid.c&gt;\n          AddType application\/x-httpd-php .php\n          Action application\/x-httpd-php \/cgi-bin\/php\n       &lt;\/IfModule&gt;\n     &lt;\/IfModule&gt;\n   &lt;\/IfModule&gt;\n&lt;\/Directory&gt;<\/code><\/pre>\n\n\n\n<p>Save and quit the file, then restart Apache and open <code>http:\/\/your-server-IP\/phppgadmin<\/code> in your preferred web browser.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large\"><img decoding=\"async\" width=\"1024\" height=\"332\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/install-and-configure-phppgadmin-on-ubuntu-20.04.png\" alt=\"install and configure phppgadmin on ubuntu 20.04\" class=\"wp-image-37853\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/install-and-configure-phppgadmin-on-ubuntu-20.04.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/install-and-configure-phppgadmin-on-ubuntu-20.04-300x97.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/install-and-configure-phppgadmin-on-ubuntu-20.04-150x49.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/install-and-configure-phppgadmin-on-ubuntu-20.04-768x249.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>In order to log in to phpPgAdmin, we need to click on the \u2018Servers\u2019 button, then click on the \u2018PostgreSQL\u2019 link and enter postgres as username and the password of the postgres user we set previously in this tutorial.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large\"><img decoding=\"async\" width=\"1024\" height=\"284\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/installing-phpphadmin-on-ubuntu-20.04.png\" alt=\"installing phpphadmin on ubuntu 20.04\" class=\"wp-image-37854\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/installing-phpphadmin-on-ubuntu-20.04.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/installing-phpphadmin-on-ubuntu-20.04-300x83.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/installing-phpphadmin-on-ubuntu-20.04-150x42.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/installing-phpphadmin-on-ubuntu-20.04-768x213.png 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure><\/div>\n\n\n\n<p>That\u2019s it, you should be able to access your phpPgAdmin at <code>http:\/\/your-server-IP\/phppgadmin<\/code> or <code>http:\/\/yourdomain.com\/phppgadmin<\/code> now.<\/p>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright\"><img decoding=\"async\" width=\"256\" height=\"256\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/setting-up-phppgamin-on-ubuntu-20.04.png\" alt=\"setting up phppgamin on ubuntu 20.04\" class=\"wp-image-37615\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/setting-up-phppgamin-on-ubuntu-20.04.png 256w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/setting-up-phppgamin-on-ubuntu-20.04-150x150.png 150w\" sizes=\"(max-width: 256px) 100vw, 256px\" \/><\/figure><\/div>\n\n\n\n<p>Of course, you don\u2019t have to install phpPgAdmin on Ubuntu 20.04 if you use one of our <a href=\"https:\/\/www.rosehosting.com\/linux-vps-hosting\/\" target=\"_blank\" rel=\"noopener\">VPS Hosting services<\/a>, in which case you can simply ask our expert Linux admins to install phpPgAdmin on your Ubuntu VPS for you. They are available 24\/7 and will take care of your request immediately.<\/p>\n\n\n\n<p><span style=\"color: #ff0000;\"><strong>PS<\/strong><\/span>. If you liked this post on how to install phpPgAdmin on Ubuntu 20.04, please share it with your friends on the social networks using the buttons below or simply leave a reply in the comments sections. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is one of many powerful and famous object-relational database systems. It is a free and open-source database management system. &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How To Install phpPgAdmin On Ubuntu 20.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#more-32662\" aria-label=\"Read more about How To Install phpPgAdmin On Ubuntu 20.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":37619,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1700,13,1698],"tags":[172,1347,1839],"class_list":["post-32662","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-debian","category-tutorials","category-ubuntu","tag-install","tag-phppgadmin","tag-ubuntu-20-04","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How To Install phpPgAdmin On Ubuntu 20.04 | RoseHosting<\/title>\n<meta name=\"description\" content=\"Learn how to install phpPgAdmin on Ubuntu 20.04 with this tutorial. Find all steps to install phpPgAdmin on Ubuntu.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To Install phpPgAdmin On Ubuntu 20.04 | RoseHosting\" \/>\n<meta property=\"og:description\" content=\"Learn how to install phpPgAdmin on Ubuntu 20.04 with this tutorial. Find all steps to install phpPgAdmin on Ubuntu.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-14T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:31:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg?v=1623846290\" \/>\n\t<meta property=\"og:image:width\" content=\"742\" \/>\n\t<meta property=\"og:image:height\" content=\"372\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How To Install phpPgAdmin On Ubuntu 20.04 | RoseHosting\" \/>\n<meta name=\"twitter:description\" content=\"Learn how to install phpPgAdmin on Ubuntu 20.04 with this tutorial. Find all steps to install phpPgAdmin on Ubuntu.\" \/>\n<meta name=\"twitter:creator\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:site\" content=\"@rosehosting\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jeff Wilson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How To Install phpPgAdmin On Ubuntu 20.04\",\"datePublished\":\"2021-07-14T17:30:00+00:00\",\"dateModified\":\"2022-06-03T08:31:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/\"},\"wordCount\":603,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg\",\"keywords\":[\"install\",\"phppgadmin\",\"Ubuntu 20.04\"],\"articleSection\":[\"Databases\",\"Debian\",\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/\",\"name\":\"How To Install phpPgAdmin On Ubuntu 20.04 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg\",\"datePublished\":\"2021-07-14T17:30:00+00:00\",\"dateModified\":\"2022-06-03T08:31:37+00:00\",\"description\":\"Learn how to install phpPgAdmin on Ubuntu 20.04 with this tutorial. Find all steps to install phpPgAdmin on Ubuntu.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg\",\"width\":742,\"height\":372,\"caption\":\"how to install phppgadmin on ubuntu 20.04\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Install phpPgAdmin On Ubuntu 20.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/RoseHosting\",\"https:\/\/x.com\/rosehosting\",\"https:\/\/www.linkedin.com\/in\/rosehosting\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\/\/www.rosehosting.com\",\"https:\/\/www.facebook.com\/rosehosting.helpdesk\"],\"url\":\"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How To Install phpPgAdmin On Ubuntu 20.04 | RoseHosting","description":"Learn how to install phpPgAdmin on Ubuntu 20.04 with this tutorial. Find all steps to install phpPgAdmin on Ubuntu.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/","og_locale":"en_US","og_type":"article","og_title":"How To Install phpPgAdmin On Ubuntu 20.04 | RoseHosting","og_description":"Learn how to install phpPgAdmin on Ubuntu 20.04 with this tutorial. Find all steps to install phpPgAdmin on Ubuntu.","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2021-07-14T17:30:00+00:00","article_modified_time":"2022-06-03T08:31:37+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg?v=1623846290","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_title":"How To Install phpPgAdmin On Ubuntu 20.04 | RoseHosting","twitter_description":"Learn how to install phpPgAdmin on Ubuntu 20.04 with this tutorial. Find all steps to install phpPgAdmin on Ubuntu.","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How To Install phpPgAdmin On Ubuntu 20.04","datePublished":"2021-07-14T17:30:00+00:00","dateModified":"2022-06-03T08:31:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/"},"wordCount":603,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg","keywords":["install","phppgadmin","Ubuntu 20.04"],"articleSection":["Databases","Debian","Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/","name":"How To Install phpPgAdmin On Ubuntu 20.04 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg","datePublished":"2021-07-14T17:30:00+00:00","dateModified":"2022-06-03T08:31:37+00:00","description":"Learn how to install phpPgAdmin on Ubuntu 20.04 with this tutorial. Find all steps to install phpPgAdmin on Ubuntu.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/06\/how-to-install-phppgadmin-on-ubuntu-20.04.jpg","width":742,"height":372,"caption":"how to install phppgadmin on ubuntu 20.04"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-20-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To Install phpPgAdmin On Ubuntu 20.04"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/32662","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/comments?post=32662"}],"version-history":[{"count":5,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/32662\/revisions"}],"predecessor-version":[{"id":37855,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/32662\/revisions\/37855"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/37619"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=32662"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=32662"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=32662"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}