{"id":29139,"date":"2019-10-24T13:44:46","date_gmt":"2019-10-24T18:44:46","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=29139"},"modified":"2022-12-12T08:21:34","modified_gmt":"2022-12-12T14:21:34","slug":"how-to-install-phppgadmin-on-debian-9","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/","title":{"rendered":"How to Install phpPgAdmin on Debian 9"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-32124\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9.jpg\" alt=\"\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9-300x150.jpg 300w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this tutorial, we will show you how to install phpPgAdmin on a\u00a0<a href=\"https:\/\/www.rosehosting.com\/debian-hosting.html\">Debian 9 VPS<\/a>.<\/p>\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-32125\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/setting-up-phppgadmin-postgresql-for-debian9-vps-guide.jpg\" alt=\"\" width=\"140\" height=\"144\" \/>PhpPgAdmin is an open-source web administration interface used for managing PostgreSQL databases.\u00a0PhpPgAdmin is written in PHP and it\u00a0makes the administration of PostgreSQL databases easier, not to mention the web-based GUI making everything more user-friendly and easier to use. Let&#8217;s begin with the installation process.<\/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-69f39ce2ab540\" 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-69f39ce2ab540\"  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-debian-9\/#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-debian-9\/#Step-1-Update-OS-packages\" >Step 1: Update OS packages<\/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-debian-9\/#Step-2-Install-PostgreSQL\" >Step 2: Install PostgreSQL<\/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-debian-9\/#Step-3-Install-phpPgAdmin\" >Step 3: Install phpPgAdmin<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In order to run\u00a0phpPgAdmin on your <a href=\"https:\/\/www.rosehosting.com\/debian-hosting.html\">Debian 9 VPS<\/a>, the following requirements have to be met:<\/p>\n<ul>\n<li>PostgreSQL version 8.4 or higher<\/li>\n<li>Apache2<\/li>\n<li>PHP 5 or later installed on the server.<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Update-OS-packages\"><\/span>Step 1: Update OS packages<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Before we can start with phpPgAdmin installation, we have to make sure that all Debian OS packages installed on the server are up to date. We can do this by executing the following commands:<\/p>\n<pre>sudo apt-get update\r\nsudo apt-get upgrade<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Install-PostgreSQL\"><\/span>Step 2: Install PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre>sudo apt-get install postgresql postgresql-client postgresql-client-common postgresql-common postgresql-contrib<\/pre>\n<p>You&#8217;ll now need to set a password for the default PostgreSQL superuser account.<\/p>\n<p>In order to set a password for the PostgreSQL superuser account (postgres), run the following commands:<\/p>\n<pre>sudo -u postgres psql<\/pre>\n<pre>psql (9.6.10)\r\nType \"help\" for help.<\/pre>\n<pre>postgres=#\r\npsql\r\n\\password postgres      (Enter a new password twice)\r\npsql \\q<\/pre>\n<p>Enable md5 passwords for local connections by editing the PostgreSQL configuration file (<code>\/etc\/postgresql\/9.6\/main\/pg_hba.conf<\/code>):<\/p>\n<pre>vi \/etc\/postgresql\/9.6\/main\/pg_hba.conf<\/pre>\n<p>replace:<\/p>\n<pre>local   all             postgres                                peer\r\nlocal   all             all                                     peer<\/pre>\n<p>with:<\/p>\n<pre>local   all             postgres                                md5\r\nlocal   all             all                                     md5<\/pre>\n<p>Restart the PostgreSQL service for the changes to take effect:<\/p>\n<pre>service postgresql restart<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Install-phpPgAdmin\"><\/span>Step 3: Install phpPgAdmin<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>There are two ways to install\u00a0phpPgAdmin. We can use a debian package, or\u00a0 we can install phpPgAdmin from a source file. In this tutorial, we&#8217;ll be going over both installation methods. You can choose whichever is most suitable for your use case.<\/p>\n<h3>Method 1: Installing from a Repository<\/h3>\n<p>phpPgAdmin is available in the base Debian repository, so it can be easily installed using the following command:<\/p>\n<pre>apt-get install phppgadmin<\/pre>\n<p>In order to check the\u00a0phpPgAdmin 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-2 all web-based administration tool for PostgreSQL<\/pre>\n<h3>Method 2: Compiling from Source<\/h3>\n<p>Not only can we install the latest version of phpPgAdmin from the built-in repositories, but we can also compile the source code locally for our machine. phpPgAdmin is available to be downloaded at\u00a0http:\/\/downloads.sourceforge.net.<br \/>\nDownload\u00a0phpPgAdmin and extract it to the <code>\/usr\/share\/phppgadmin\/<\/code> directory on the server:<\/p>\n<pre>cd opt\r\nwget -O phpPgAdmin.zip http:\/\/downloads.sourceforge.net\/phppgadmin\/phpPgAdmin-5.1.zip?download\r\nunzip phpPgAdmin.zip\r\nmv phpPgAdmin-5.1\/ \/usr\/share\/phppgadmin\/\r\n<\/pre>\n<p>Create a new Apache configuration file for phpPgAdmin:<\/p>\n<pre>vi \/etc\/apache2\/conf-enabled\/phppgadmin.conf<\/pre>\n<p>Add the following lines:<\/p>\n<pre>Alias \/phppgadmin \/usr\/share\/phppgadmin\r\n\r\n&lt;Directory \/usr\/share\/phppgadmin&gt;\r\n    &lt;IfModule mod_dir.c&gt;\r\n        DirectoryIndex index.php\r\n    &lt;\/IfModule&gt;\r\n    AllowOverride None\r\n\r\n    # Only allow connections from localhost:\r\n    #Require local\r\n\r\n    &lt;IfModule mod_php.c&gt;\r\n        php_flag magic_quotes_gpc Off\r\n        php_flag track_vars On\r\n        #php_value include_path .\r\n    &lt;\/IfModule&gt;\r\n    &lt;IfModule !mod_php.c&gt;\r\n        &lt;IfModule mod_actions.c&gt;\r\n            &lt;IfModule mod_cgi.c&gt;\r\n                AddType application\/x-httpd-php .php\r\n                Action application\/x-httpd-php \/cgi-bin\/php\r\n            &lt;\/IfModule&gt;\r\n            &lt;IfModule mod_cgid.c&gt;\r\n                AddType application\/x-httpd-php .php\r\n                Action application\/x-httpd-php \/cgi-bin\/php\r\n            &lt;\/IfModule&gt;\r\n        &lt;\/IfModule&gt;\r\n    &lt;\/IfModule&gt;\r\n&lt;\/Directory&gt;<\/pre>\n<p>By default,\u00a0phpPgAdmin is not accessible from a remote location, and is only accessible from <code>localhost<\/code>.<\/p>\n<p>To change this and allow phpPgAdmin to be accessible from everywhere, we need to edit the Apache configuration for phpPgAdmin (found at <code>\/etc\/apache2\/conf-enabled\/phppgadmin.conf<\/code>):<\/p>\n<pre>vi \/etc\/apache2\/conf-enabled\/phppgadmin.conf<\/pre>\n<p>and then delete the following lines:<\/p>\n<pre># Only allow connections from localhost:\r\nRequire local\r\n<\/pre>\n<p>Save and close that file, then restart the Apache service for the changes to take effect:<\/p>\n<pre>systemctl restart apache2.service<\/pre>\n<p>Also, we have to configure phpPgAdmin to allow users like the postgres user to log in via phpPgAdmin remotely. In order to do so, we have to edit the phpPgAdmin configuration file (found at <code>\/etc\/phppgadmin\/config.inc.php<\/code>):<\/p>\n<pre>vi \/etc\/phppgadmin\/config.inc.php<\/pre>\n<p>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 exit the file. You should now be able to access the phpPgAdmin web client by entering http:\/\/server_ip in your preferred web browser.<br \/>\n<img decoding=\"async\" class=\"alignnone wp-image-29141\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/phpPgAdmin-300x72.png\" alt=\"phpPgAdmin\" width=\"600\" height=\"145\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/phpPgAdmin-300x72.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/phpPgAdmin-150x36.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/phpPgAdmin-768x185.png 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/phpPgAdmin-1024x247.png 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/phpPgAdmin-1080x260.png 1080w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2018\/11\/phpPgAdmin.png 1514w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/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 that we set previously in this tutorial. If you created another database user in PostgreSQL, you can log in to the phpPgAdmin web interface using the login credentials of that particular database user.<\/p>\n<p>We can now\u00a0create, delete, and alter databases using the\u00a0phpPgAdmin web interface. To create a new PostgreSQL database via\u00a0phpPgAdmin, click on the &#8216;Create Database&#8217; link, enter a database name, select database encoding (e.g. UTF8) and click on the &#8216;Create&#8217; button. To delete a database, click on the\u00a0PostgreSQL link, select the database you want to delete, click on the &#8216;Drop&#8217; button and confirm that you want to delete that database. Those are the basics of using phpPgAdmin.<\/p>\n<p>That is everything in terms of the install process. We have successfully installed and configured phpPgAdmin.<\/p>\n<hr \/>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-32126\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/online-help-from-expert-admins-for-phppgadmin-database-debian9.jpg\" alt=\"\" width=\"140\" height=\"144\" \/>Of course, you don\u2019t have to set up and configure phpPgAdmin on Debian 9 yourself if you use one of our\u00a0<a href=\"https:\/\/www.rosehosting.com\/debian-hosting.html\">Managed Debian Hosting<\/a> solutions, in which case you can simply ask our expert Linux admins to install and configure phpPgAdmin on your Debian 9 VPS for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p>We also have a tutorial on <a href=\"https:\/\/www.rosehosting.com\/blog\/install-pgadmin-4-on-debian-10\/\" target=\"_blank\" rel=\"noopener\">how to install pgAdmin 4 on Debian 10<\/a>, so have a look at it you require assistance with setting it up and configuring it on a newer Debian version.<\/p>\n<p><span style=\"color: #ff0000;\"><strong>PS<\/strong><\/span>. If you liked this post on <strong>how to install phpPgAdmin on a Debian 9 VPS<\/strong>, or if you found it helpful, please share it with your friends on the social networks using the share shortcuts, or simply leave a comment in the comment section down below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will show you how to install phpPgAdmin on a\u00a0Debian 9 VPS. PhpPgAdmin is an open-source web &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install phpPgAdmin on Debian 9\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#more-29139\" aria-label=\"Read more about How to Install phpPgAdmin on Debian 9\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":32124,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1700,13],"tags":[1577,1347],"class_list":["post-29139","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-debian","category-tutorials","tag-debian-9","tag-phppgadmin","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.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How To Install phpPgAdmin on Debian9 | RoseHosting<\/title>\n<meta name=\"description\" content=\"Learn how to install phpPgAdmin on Debian 9. Set up and configure phpPgAdmin yourself on Debian 9 using this guide.\" \/>\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-debian-9\/\" \/>\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 Debian 9\" \/>\n<meta property=\"og:description\" content=\"How to Install phpPgAdmin on Debian 9 | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/\" \/>\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-10-24T18:44:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-12T14:21:34+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9.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=\"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-debian-9\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install phpPgAdmin on Debian 9\",\"datePublished\":\"2019-10-24T18:44:46+00:00\",\"dateModified\":\"2022-12-12T14:21:34+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/\"},\"wordCount\":770,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/how-to-install-phppgadmin-on-debian9.jpg\",\"keywords\":[\"debian 9\",\"phppgadmin\"],\"articleSection\":[\"Databases\",\"Debian\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/\",\"name\":\"How To Install phpPgAdmin on Debian9 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/how-to-install-phppgadmin-on-debian9.jpg\",\"datePublished\":\"2019-10-24T18:44:46+00:00\",\"dateModified\":\"2022-12-12T14:21:34+00:00\",\"description\":\"Learn how to install phpPgAdmin on Debian 9. Set up and configure phpPgAdmin yourself on Debian 9 using this guide.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/how-to-install-phppgadmin-on-debian9.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2019\\\/10\\\/how-to-install-phppgadmin-on-debian9.jpg\",\"width\":742,\"height\":372},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-phppgadmin-on-debian-9\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install phpPgAdmin on Debian 9\"}]},{\"@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 Debian9 | RoseHosting","description":"Learn how to install phpPgAdmin on Debian 9. Set up and configure phpPgAdmin yourself on Debian 9 using this guide.","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-debian-9\/","og_locale":"en_US","og_type":"article","og_title":"How to Install phpPgAdmin on Debian 9","og_description":"How to Install phpPgAdmin on Debian 9 | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2019-10-24T18:44:46+00:00","article_modified_time":"2022-12-12T14:21:34+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9.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":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install phpPgAdmin on Debian 9","datePublished":"2019-10-24T18:44:46+00:00","dateModified":"2022-12-12T14:21:34+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/"},"wordCount":770,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9.jpg","keywords":["debian 9","phppgadmin"],"articleSection":["Databases","Debian","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/","name":"How To Install phpPgAdmin on Debian9 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9.jpg","datePublished":"2019-10-24T18:44:46+00:00","dateModified":"2022-12-12T14:21:34+00:00","description":"Learn how to install phpPgAdmin on Debian 9. Set up and configure phpPgAdmin yourself on Debian 9 using this guide.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2019\/10\/how-to-install-phppgadmin-on-debian9.jpg","width":742,"height":372},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-phppgadmin-on-debian-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install phpPgAdmin on Debian 9"}]},{"@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\/29139","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=29139"}],"version-history":[{"count":4,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/29139\/revisions"}],"predecessor-version":[{"id":44160,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/29139\/revisions\/44160"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/32124"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=29139"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=29139"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=29139"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}