{"id":31233,"date":"2019-06-29T09:59:25","date_gmt":"2019-06-29T14:59:25","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=31233"},"modified":"2022-06-03T03:33:41","modified_gmt":"2022-06-03T08:33:41","slug":"how-to-install-phppgadmin-on-ubuntu-18-04","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/","title":{"rendered":"How to Install phpPgAdmin on Ubuntu 18.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-31258\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04.jpg\" alt=\"\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04-300x150.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this article, we will show you how to install phpPgAdmin on an <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu 18.04 VPS<\/a>.<\/p>\n<p>PhpPgAdmin is an open source web administration interface written in PHP. It is used to manage PostgreSQL databases through <img decoding=\"async\" class=\"alignright size-full wp-image-31259\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/phppgadmin-ubuntu-managed-vps.jpg\" alt=\"\" width=\"100\" height=\"100\">a web interface. This guide should work on other Debian based servers as well, but it was tested and written for an Ubuntu 18.04 VPS.<\/p>\n<p><!--more--><\/p>\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-69e9c0ffe5e62\" 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-69e9c0ffe5e62\"  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-18-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-18-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-18-04\/#Step-2-Apache-Web-Server-Installation\" >Step 2: Apache Web Server Installation<\/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-18-04\/#Step-3-Install-PostgreSQL\" >Step 3: Install 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-18-04\/#Step-4-Install-phpPgAdmin\" >Step 4: Install phpPgAdmin<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span><strong>Prerequisites<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>For the purposes of this tutorial, we will use an&nbsp;<a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Ubuntu 18.04 virtual server<\/a>.<\/li>\n<li>PostgreSQL version 8.4 or higher.<\/li>\n<li>Apache2 web server.<\/li>\n<li>PHP 5 or higher installed on the server.<\/li>\n<li>Full SSH root access (or a user with sudo privileges) is also required.<\/li>\n<\/ul>\n<h2><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<p>Log in to your server via SSH, as shown in our example:<\/p>\n<pre>ssh root@<span style=\"color: #ff0000;\">IP_Address<\/span> -p <span style=\"color: #ff0000;\">Port_number<\/span><\/pre>\n<p>Make sure to replace \u201c<span style=\"color: #ff0000;\">IP_Address<\/span>\u201d and \u201c<span style=\"color: #ff0000;\">Port_number<\/span>\u201d with your server&#8217;s actual IP address and SSH port number.<\/p>\n<p>Once logged in, make sure that the server OS&#8217; packages are up-to-date. We can do this by running the following commands:<\/p>\n<pre>apt-get update &amp;&amp; apt-get upgrade<\/pre>\n<p>This will update the package index as well as update the software packages currently installed on the server to their latest versions that are available in the Ubuntu repositories (defined in \/etc\/apt\/sources.list).<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Apache-Web-Server-Installation\"><\/span>Step 2: Apache Web Server Installation<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Apache is the web server of choice for this tutorial. It&#8217;s one of the most popular web servers in the world, and that&#8217;s what will be serving our web interface. Let&#8217;s install it now.<\/p>\n<p>First, check if Apache is already installed and running on the server:<\/p>\n<pre>dpkg -l | grep -i apache2\nps aux | grep apache2<\/pre>\n<p>If it is not installed, run the following command to install the Apache web server:<\/p>\n<pre>apt-get install apache2<\/pre>\n<p>Enable Apache service to start automatically upon server boot with:<\/p>\n<pre>systemctl enable apache2<\/pre>\n<p>We can also check the status of the Apache service with the following command:<\/p>\n<pre>systemctl status apache2<\/pre>\n<p>Output:<\/p>\n<p>\u25cf apache2.service &#8211; The Apache HTTP Server<br \/>\nLoaded: loaded (\/lib\/systemd\/system\/apache2.service; enabled; vendor preset: enabled)<br \/>\nDrop-In: \/lib\/systemd\/system\/apache2.service.d<br \/>\n\u2514\u2500apache2-systemd.conf<br \/>\nActive: active (running) since Fri 2019-06-14 10:13:06 CDT; 1min 4s ago<br \/>\nMain PID: 9723 (apache2)<br \/>\nTasks: 6 (limit: 2321)<br \/>\nCGroup: \/system.slice\/apache2.service<br \/>\n\u251c\u25009723 \/usr\/sbin\/apache2 -k start<br \/>\n\u251c\u25009726 \/usr\/sbin\/apache2 -k start<br \/>\n\u251c\u25009727 \/usr\/sbin\/apache2 -k start<br \/>\n\u251c\u25009728 \/usr\/sbin\/apache2 -k start<br \/>\n\u251c\u25009729 \/usr\/sbin\/apache2 -k start<br \/>\n\u2514\u25009730 \/usr\/sbin\/apache2 -k start<\/p>\n<p>We can now install PostgreSQL.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Install-PostgreSQL\"><\/span>Step 3: Install PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Run the following command to install PostgreSQL 10.8, the latest version available in the official Ubuntu repositories, along with some required PostgreSQL packages:<\/p>\n<pre>sudo apt-get install postgresql postgresql-client postgresql-client-common postgresql-common postgresql-contrib<\/pre>\n<p>Once this is done, set a password for the PostgreSQL superuser account (postgres), using the following commands:<\/p>\n<pre>sudo -u postgres psql<\/pre>\n<pre>psql (10.8 (Ubuntu 10.8-0ubuntu0.18.04.1))\nType \"help\" for help.<\/pre>\n<pre>postgres=# psql\npostgres-# \\password postgres      (Enter a new password twice)\npostgres-# \\q<\/pre>\n<p>Edit the PostgreSQL configuration file (<code>pg_hba.conf<\/code>) and enable md5 passwords for local connections:<\/p>\n<pre>vi \/etc\/postgresql\/10\/main\/pg_hba.conf<\/pre>\n<p>Replace the following text:<\/p>\n<pre>local   all             postgres                                peer\nlocal   all             all                                     peer<\/pre>\n<p>With this text instead:<\/p>\n<pre>local   all             postgres                                md5\nlocal   all             all                                     md5<\/pre>\n<p>Restart the PostgreSQL service by executing this line:<\/p>\n<pre>service postgresql restart<\/pre>\n<p>It is now time to install phpPgAdmin.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Install-phpPgAdmin\"><\/span>Step 4: Install phpPgAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are two ways to install phpPgAdmin . We can use a debian package, or we can install phpPgAdmin from a source file. Since phpPgAdmin is available in the base Ubuntu repository, it can be easily installed using the following command instead of compiling from source, which saves us a lot of time:<\/p>\n<pre>apt-get install phppgadmin<\/pre>\n<p>In order to check the&nbsp;phppgadmin version installed using this method, run the following command:<\/p>\n<pre>dpkg -l | grep phppgadmin<\/pre>\n<p>The output should be similar to this:<\/p>\n<pre>ii  phppgadmin                            5.1+ds-3                                   all          web-based administration tool for PostgreSQL<\/pre>\n<p>Edit the Apache configuration file for phpPgAdmin:<\/p>\n<pre>vi \/etc\/apache2\/conf-enabled\/phppgadmin.conf<\/pre>\n<p>The configuration file should contain the following lines:<\/p>\n<pre>Alias \/phppgadmin \/usr\/share\/phppgadmin\n\n&lt;Directory \/usr\/share\/phppgadmin&gt;\n\n&lt;IfModule mod_dir.c&gt;\nDirectoryIndex index.php\n&lt;\/IfModule&gt;\nAllowOverride None\n\n# Only allow connections from localhost:\nRequire local\n\n&lt;IfModule mod_php.c&gt;\nphp_flag magic_quotes_gpc Off\nphp_flag track_vars On\n#php_value include_path .\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;\nAddType application\/x-httpd-php .php\nAction application\/x-httpd-php \/cgi-bin\/php\n&lt;\/IfModule&gt;\n&lt;IfModule mod_cgid.c&gt;\nAddType application\/x-httpd-php .php\nAction application\/x-httpd-php \/cgi-bin\/php\n&lt;\/IfModule&gt;\n&lt;\/IfModule&gt;\n&lt;\/IfModule&gt;\n\n&lt;\/Directory&gt;<\/pre>\n<p>phpPgAdmin is not accessible from a remote location, meaning that it is only accessible from localhost.<\/p>\n<p>To change this and allow phpPgAdmin to be accessible from everywhere, edit the Apache configuration for phpPgAdmin (<code>phppgadmin.conf<\/code>) and enable access to the phpPgAdmin web interface from remote locations. Open the file using your preferred text editor:<\/p>\n<pre>vi \/etc\/apache2\/conf-enabled\/phppgadmin.conf<\/pre>\n<p>Then delete the following lines:<\/p>\n<pre># Only allow connections from localhost:\nRequire local\n<\/pre>\n<p>Then save and close the file.<br \/>\nRestart the Apache service:<\/p>\n<pre>systemctl restart apache2.service<\/pre>\n<p>We can now configure phpPgAdmin to allow users like the postgres user to log in to the phpPgAdmin web interface remotely.<\/p>\n<p>Edit the phpPgAdmin configuration file (<code>\/etc\/phppgadmin\/config.inc.php<\/code>) and replace:<\/p>\n<pre>$conf['extra_login_security'] = true;<\/pre>\n<p>with:<\/p>\n<pre>$conf['extra_login_security'] = false;<\/pre>\n<p>Save and quit the file, then open&nbsp;<code>http:\/\/your-server-IP\/phppgadmin<\/code> in your preferred web browser.<\/p>\n<p>In order to log in to phpPgAdmin, we need to click on the &#8216;Servers&#8217; button, then click on the &#8216;PostgreSQL&#8217; link and enter postgres as username and the password of the postgres user we set previously in this tutorial.<\/p>\n<p><img decoding=\"async\" class=\"size-full wp-image-31234 alignnone\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/phppgadmin-back-end-ubuntu.png\" alt=\"phppgadmin back-end ubuntu\" width=\"1312\" height=\"279\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/phppgadmin-back-end-ubuntu.png 1312w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/phppgadmin-back-end-ubuntu-150x32.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/phppgadmin-back-end-ubuntu-300x64.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/phppgadmin-back-end-ubuntu-768x163.png 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/phppgadmin-back-end-ubuntu-1024x218.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/phppgadmin-back-end-ubuntu-1080x230.png 1080w\" sizes=\"(max-width: 1312px) 100vw, 1312px\" \/><\/p>\n<p>That is it. We successfully installed and configured phpPgAdmin on Ubuntu 18.04.<\/p>\n<hr>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-31260\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/set-up-phppgadmin-on-ubuntu-vps.jpg\" alt=\"\" width=\"150\" height=\"48\">Of course, you don\u2019t have to set up and configure phpPgAdmin on Ubuntu 18.04 if you use one of our <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\" target=\"_blank\" rel=\"noopener noreferrer\">Managed Ubuntu Hosting<\/a> solutions, in which case you can simply ask our expert Linux admins to install and configure phpPgAdmin on Ubuntu 18.04 for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS<\/strong><\/span>. If you liked this post on <strong>how to install phpPgAdmin on an Ubuntu 18.04 VPS<\/strong>, please share it with your friends on the social networks by using the share shortcuts below, or simply leave a comment down in the comments section. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this article, we will show you how to install phpPgAdmin on an Ubuntu 18.04 VPS. PhpPgAdmin is an open &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install phpPgAdmin on Ubuntu 18.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/#more-31233\" aria-label=\"Read more about How to Install phpPgAdmin on Ubuntu 18.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":31258,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,13,1698],"tags":[1347,1779],"class_list":["post-31233","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-tutorials","category-ubuntu","tag-phppgadmin","tag-ubuntu-18-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.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install phpPgAdmin on Ubuntu 18.04 | RoseHosting<\/title>\n<meta name=\"description\" content=\"Learn how to install phpPgAdmin on Ubuntu 18.04 using this step by step tutorial. It&#039;s easy to set up and configure phpPgAdmin on an 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-18-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 18.04\" \/>\n<meta property=\"og:description\" content=\"How to Install phpPgAdmin on Ubuntu 18.04 | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-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=\"2019-06-29T14:59:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:33:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04.jpg\" \/>\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: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=\"6 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-18-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install phpPgAdmin on Ubuntu 18.04\",\"datePublished\":\"2019-06-29T14:59:25+00:00\",\"dateModified\":\"2022-06-03T08:33:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/\"},\"wordCount\":807,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/how-to-install-phppgadmin-on-ubuntu18.04.jpg\",\"keywords\":[\"phppgadmin\",\"Ubuntu 18.04\"],\"articleSection\":[\"Databases\",\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/\",\"name\":\"How to Install phpPgAdmin on Ubuntu 18.04 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/how-to-install-phppgadmin-on-ubuntu18.04.jpg\",\"datePublished\":\"2019-06-29T14:59:25+00:00\",\"dateModified\":\"2022-06-03T08:33:41+00:00\",\"description\":\"Learn how to install phpPgAdmin on Ubuntu 18.04 using this step by step tutorial. It's easy to set up and configure phpPgAdmin on an Ubuntu.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/how-to-install-phppgadmin-on-ubuntu18.04.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/06\\\/how-to-install-phppgadmin-on-ubuntu18.04.jpg\",\"width\":742,\"height\":372},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-ubuntu-18-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 18.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 18.04 | RoseHosting","description":"Learn how to install phpPgAdmin on Ubuntu 18.04 using this step by step tutorial. It's easy to set up and configure phpPgAdmin on an 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-18-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install phpPgAdmin on Ubuntu 18.04","og_description":"How to Install phpPgAdmin on Ubuntu 18.04 | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2019-06-29T14:59:25+00:00","article_modified_time":"2022-06-03T08:33:41+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04.jpg","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install phpPgAdmin on Ubuntu 18.04","datePublished":"2019-06-29T14:59:25+00:00","dateModified":"2022-06-03T08:33:41+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/"},"wordCount":807,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04.jpg","keywords":["phppgadmin","Ubuntu 18.04"],"articleSection":["Databases","Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/","name":"How to Install phpPgAdmin on Ubuntu 18.04 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04.jpg","datePublished":"2019-06-29T14:59:25+00:00","dateModified":"2022-06-03T08:33:41+00:00","description":"Learn how to install phpPgAdmin on Ubuntu 18.04 using this step by step tutorial. It's easy to set up and configure phpPgAdmin on an Ubuntu.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-04\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/06\/how-to-install-phppgadmin-on-ubuntu18.04.jpg","width":742,"height":372},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-ubuntu-18-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 18.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\/31233","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=31233"}],"version-history":[{"count":1,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31233\/revisions"}],"predecessor-version":[{"id":38395,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/31233\/revisions\/38395"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/31258"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=31233"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=31233"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=31233"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}