{"id":19889,"date":"2016-08-24T07:56:46","date_gmt":"2016-08-24T12:56:46","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=19889"},"modified":"2022-06-03T03:42:42","modified_gmt":"2022-06-03T08:42:42","slug":"install-postgresql-with-phppgadmin-on-ubuntu","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/","title":{"rendered":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-23753\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg\" alt=\"Install PostgreSQL with phpPgAdmin on Ubuntu\" width=\"1200\" height=\"600\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg 1200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-150x75.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-768x384.jpg 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-1024x512.jpg 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-860x430.jpg 860w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-680x340.jpg 680w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-500x250.jpg 500w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-400x200.jpg 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-200x100.jpg 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu-50x25.jpg 50w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p>We&#8217;ll show you, how to Install PostgreSQL with phpPgAdmin on Ubuntu 16.04. PostgreSQL is an object-relational database management system (ORDBMS) that is suited for large databases and has many advanced features. Its emphasis is on extensibility and standards-compliance. PostgreSQL can handle workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.\u00a0Installing PostgreSQL with phpPgAdmin on Ubuntu 16.04, is an easy and doesn&#8217;t take much time, follow the steps in this tutorial and you will be able to create and manage databases in PostgreSQL on Ubuntu 16.04, in few minutes.\u00a0PostgreSQL is available for many operating systems few of which are <a href=\"https:\/\/www.linux.com\/\">Linux<\/a>, <a href=\"https:\/\/www.oracle.com\/solaris\">Solaris<\/a>, <a href=\"https:\/\/www.freebsd.org\">FreeBSD<\/a> and <a href=\"https:\/\/www.microsoft.com\/en-us\/windows\/\">Microsoft Windows.<\/a><!--more--><\/p>\n<p>What happens if you want to manage the PostgreSQL databases from a graphical interface and not the command line?<\/p>\n<p>You can install phpPgAdmin on Ubuntu 16.04, which is a is a web-based administration tool for PostgreSQL. It is perfect for users that don&#8217;t have experience in managing PostgreSQL from the command line. phpPgAdmin is the PostgreSQL equivalent of MySQL&#8217;s phpMyAdmin and provides a convenient way for users to create databases, create tables, alter tables and query their own data using industry-standard SQL.<\/p>\n<p>So in today&#8217;s article, we will install PostgreSQL and phpPgAdmin on Ubuntu 16.04<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24752\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-on-Ubuntu-16.04.jpg\" alt=\"Install PostgreSQL on Ubuntu 16.04\" width=\"600\" height=\"89\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-on-Ubuntu-16.04.jpg 600w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-on-Ubuntu-16.04-150x22.jpg 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-on-Ubuntu-16.04-300x45.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-on-Ubuntu-16.04-500x74.jpg 500w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-on-Ubuntu-16.04-400x59.jpg 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-on-Ubuntu-16.04-200x30.jpg 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-on-Ubuntu-16.04-50x7.jpg 50w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/p>\n<h4>REQUIREMENTS<\/h4>\n<p>We will be using our SSD 1 Linux VPS hosting plan for this tutorial.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_65 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-662df6c0c1ab1\" 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-662df6c0c1ab1\"  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\/install-postgresql-with-phppgadmin-on-ubuntu\/#1-Log-in-to-your-server-via-SSH\" title=\"1. Log in to your server via SSH\">1. Log in to your server via SSH<\/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\/install-postgresql-with-phppgadmin-on-ubuntu\/#2-Update-the-system\" title=\"2. Update the system\">2. 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\/install-postgresql-with-phppgadmin-on-ubuntu\/#3-Install-PostgreSQL-and-phpPgAdmin-on-Uubntu-1604\" title=\"3.\u00a0Install PostgreSQL and phpPgAdmin on Uubntu 16.04\">3.\u00a0Install PostgreSQL and phpPgAdmin on Uubntu 16.04<\/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\/install-postgresql-with-phppgadmin-on-ubuntu\/#4-Log-into-the-Postgrees-System-Account\" title=\"4. Log into the Postgrees System Account\">4. Log into the Postgrees System Account<\/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\/install-postgresql-with-phppgadmin-on-ubuntu\/#5-Configure-Apache\" title=\"5. Configure Apache\">5. Configure Apache<\/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\/install-postgresql-with-phppgadmin-on-ubuntu\/#6-Restart-PostgreSQL-and-Apache\" title=\"6. Restart PostgreSQL and Apache\">6. Restart PostgreSQL and Apache<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#7-Verify-phpPgAdmin-Installation-on-Ubuntu-1604\" title=\"7. Verify phpPgAdmin Installation on Ubuntu 16.04\">7. Verify phpPgAdmin Installation on Ubuntu 16.04<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"1-Log-in-to-your-server-via-SSH\"><\/span>1. Log in to your server via SSH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<pre># ssh root@server_ip<\/pre>\n<p>You can check whether you have the proper Ubuntu version installed on your server with the following command:<\/p>\n<pre># lsb_release -a<\/pre>\n<p>You should get this output:<\/p>\n<pre>Distributor ID: Ubuntu\r\nDescription:    Ubuntu 16.04.1 LTS\r\nRelease:        16.04\r\nCodename:       xenial<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"2-Update-the-system\"><\/span>2. Update the system<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Make sure your server is fully up to date using:<\/p>\n<pre># apt-get update &amp;&amp; apt-get upgrade\r\n\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"3-Install-PostgreSQL-and-phpPgAdmin-on-Uubntu-1604\"><\/span>3.\u00a0Install PostgreSQL and phpPgAdmin on Uubntu 16.04<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now install PostgreSQL and phpPgAdmin using the below command:<\/p>\n<pre># apt-get install postgresql postgresql-contrib phppgadmin<\/pre>\n<p>This command will install all the necessary packages needed by PostgreSQL and phpPgAdmin such as Apache, PHP etc&#8230; so don&#8217;t worry if you don&#8217;t have Apache or PHP installed on your server.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"4-Log-into-the-Postgrees-System-Account\"><\/span>4. Log into the Postgrees System Account<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Once the installation is completed, log into the &#8216;<strong>postgres<\/strong>&#8216; system account so you can access PostgreSQL. Type:<\/p>\n<pre># su - postgres<\/pre>\n<p>Now you can access PostgreSQL using:<\/p>\n<pre>postgres@vps:~$ psql<\/pre>\n<p>Change your &#8216;<strong>postgres<\/strong>&#8216; role password to match your needs:<\/p>\n<pre>postgres=# \\password postgres<\/pre>\n<p>Enter the new password when prompted.<\/p>\n<p>Quit the <strong>psql<\/strong> command line:<\/p>\n<pre>postgres=# \\q<\/pre>\n<p>Exit the <strong>postgres<\/strong> user:<\/p>\n<pre>postgres=# exit<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"5-Configure-Apache\"><\/span>5. Configure Apache<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In order to access phpPgAdmin via your browser, the Apache web server needs to be configured. Therefore open the <strong>phppgadmin.conf<\/strong> file:<\/p>\n<pre># nano \/etc\/apache2\/conf-available\/phppgadmin.conf<\/pre>\n<p>Comment the &#8216;<strong>Require local<\/strong>&#8216; line by adding &#8216;#&#8217; in front of the line. Then under that very line, add &#8216;<strong>Allow From all<\/strong>&#8216;. Save and close the file. After editing the section should look like this:<\/p>\n<pre># Only allow connections from localhost:\r\n#Require local\r\nAllow From all<\/pre>\n<p>Now tweak some settings for phpPgAdmin. Open the <strong>config.inc.php<\/strong> file:<\/p>\n<pre># nano \/etc\/phppgadmin\/config.inc.php<\/pre>\n<p>Locate the &#8216;<strong>$conf[&#8216;extra_login_security&#8217;] = true;<\/strong>&#8216; and change the value from <strong>true<\/strong> to <strong>false<\/strong> so you can log in to phpPgAdmin as the <strong>postgres<\/strong> user.<\/p>\n<p>Save and close the file.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"6-Restart-PostgreSQL-and-Apache\"><\/span>6. Restart PostgreSQL and Apache<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now restart PostgreSQL and Apache. Then enable them to start on boot. All of this can be done using the below 4 commands:<\/p>\n<pre># systemctl restart postgresql\r\n\r\n# systemctl restart apache2\r\n\r\n# systemctl enable postgresql\r\n\r\n# systemctl enable apache2<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"7-Verify-phpPgAdmin-Installation-on-Ubuntu-1604\"><\/span>7. Verify phpPgAdmin Installation on Ubuntu 16.04<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Now open your favorite web browser and access phpPgAdmin by navigating to http:\/\/your_server_IP\/phppgadmin\/. You will be welcomed by a page as shown in the image below:<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-24750\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04.png\" alt=\"Install phpPgAdmin on Ubuntu 16.04\" width=\"768\" height=\"173\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04.png 768w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04-150x34.png 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04-300x68.png 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04-680x153.png 680w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04-500x113.png 500w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04-400x90.png 400w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04-200x45.png 200w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-phpPgAdmin-on-Ubuntu-16.04-50x11.png 50w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p>You can log in using the <strong>postgres<\/strong> user and the password you&#8217;ve configured previously. Now use this great tool to create and manage databases in PostgreSQL.<\/p>\n<p>Of course you don\u2019t have to install PostgreSQL with phpPgAdmin on Ubuntu 16.04, if you use one of our <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\">Ubuntu VPS Hosting services<\/a>, in which case you can simply ask our expert Linux admins to install PostgreSQL and phpPgAdmin on Ubuntu 16.04 for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p><span style=\"color: #ff0000;\">PS.<\/span> If you liked this post on Install PostgreSQL with phpPgAdmin on Ubuntu 16.04, please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We&#8217;ll show you, how to Install PostgreSQL with phpPgAdmin on Ubuntu 16.04. PostgreSQL is an object-relational database management system (ORDBMS) &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#more-19889\" aria-label=\"Read more about Install PostgreSQL with phpPgAdmin on Ubuntu 16.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":23753,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1708,1702,13,1698],"tags":[1347,434,59],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting<\/title>\n<meta name=\"description\" content=\"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting\" \/>\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\/install-postgresql-with-phppgadmin-on-ubuntu\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting\" \/>\n<meta property=\"og:description\" content=\"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/\" \/>\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=\"2016-08-24T12:56:46+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:42:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"600\" \/>\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=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04\",\"datePublished\":\"2016-08-24T12:56:46+00:00\",\"dateModified\":\"2022-06-03T08:42:42+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/\"},\"wordCount\":646,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg\",\"keywords\":[\"phppgadmin\",\"PostgreSQL\",\"ubuntu\"],\"articleSection\":[\"Control Panels\",\"Databases\",\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/\",\"name\":\"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting\",\"isPartOf\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg\",\"datePublished\":\"2016-08-24T12:56:46+00:00\",\"dateModified\":\"2022-06-03T08:42:42+00:00\",\"description\":\"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting\",\"breadcrumb\":{\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#primaryimage\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg\",\"contentUrl\":\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg\",\"width\":1200,\"height\":600,\"caption\":\"Install PostgreSQL with phpPgAdmin on Ubuntu\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.rosehosting.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#website\",\"url\":\"https:\/\/www.rosehosting.com\/blog\/\",\"name\":\"RoseHosting\",\"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\":\"required name=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\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?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 plugin. -->","yoast_head_json":{"title":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting","description":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting","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\/install-postgresql-with-phppgadmin-on-ubuntu\/","og_locale":"en_US","og_type":"article","og_title":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting","og_description":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2016-08-24T12:56:46+00:00","article_modified_time":"2022-06-03T08:42:42+00:00","og_image":[{"width":1200,"height":600,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04","datePublished":"2016-08-24T12:56:46+00:00","dateModified":"2022-06-03T08:42:42+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/"},"wordCount":646,"commentCount":4,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg","keywords":["phppgadmin","PostgreSQL","ubuntu"],"articleSection":["Control Panels","Databases","Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/","url":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/","name":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg","datePublished":"2016-08-24T12:56:46+00:00","dateModified":"2022-06-03T08:42:42+00:00","description":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04 - RoseHosting","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2016\/08\/Install-PostgreSQL-with-phpPgAdmin-on-Ubuntu.jpg","width":1200,"height":600,"caption":"Install PostgreSQL with phpPgAdmin on Ubuntu"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/install-postgresql-with-phppgadmin-on-ubuntu\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Install PostgreSQL with phpPgAdmin on Ubuntu 16.04"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting","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":"required name=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\/"]},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/09271207587f897ab46faaed9b355252?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\/19889"}],"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=19889"}],"version-history":[{"count":1,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/19889\/revisions"}],"predecessor-version":[{"id":41940,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/19889\/revisions\/41940"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/23753"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=19889"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=19889"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=19889"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}