{"id":38549,"date":"2021-09-22T12:30:00","date_gmt":"2021-09-22T17:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=38549"},"modified":"2022-06-03T03:31:32","modified_gmt":"2022-06-03T08:31:32","slug":"how-to-install-postgresql-9-6-on-ubuntu-20-04","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/","title":{"rendered":"How to Install PostgreSQL 9.6 on Ubuntu 20.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\r\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"742\" height=\"372\" class=\"wp-image-38781\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg\" alt=\"How to Install PostgreSQL 9.6 on Ubuntu 20.04\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04-300x150.jpg 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04-150x75.jpg 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/figure>\r\n\r\n\r\n\r\n<p>In this tutorial, we are going to show you how to <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\">install PostgreSQL 9.6 on Ubuntu 20.04<\/a>. We will explain what PostgreSQL stands for and the steps of its installation, configuration, and use.<\/p>\r\n\r\n<p>Postgres or PostgreSQL is an object-relational database management system that stores and retrieves information. This system is suitable for storing a big amount of data, it is open source and is very powerful and reliable.<\/p>\r\n<p><!-- \/wp:post-content --><\/p>\r\n<p><!-- wp:paragraph --><\/p>\r\n<p>The installation will take no more than 5 minutes. Let&#8217;s Start!<\/p>\r\n<p><!--more--><\/p>\r\n<p><!-- \/wp:paragraph --><\/p>\r\n<p><!-- wp:paragraph --><\/p>\r\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-69f27399f24c9\" 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-69f27399f24c9\"  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-postgresql-9-6-on-ubuntu-20-04\/#Prerequisites\" >Prerequisites<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#Step-1-Update-the-System\" >Step 1. 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-postgresql-9-6-on-ubuntu-20-04\/#Step-2-Import-PostgreSQL-96-GPG-public-key\" >Step 2. Import PostgreSQL 9.6 GPG public key<\/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-postgresql-9-6-on-ubuntu-20-04\/#Step-3-Add-PostgreSQL-96-repository\" >Step 3. Add PostgreSQL 9.6 repository<\/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-postgresql-9-6-on-ubuntu-20-04\/#Step-4-Install-PostgreSQL-96\" >Step 4. Install PostgreSQL 9.6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#Step-5-Check-and-verify-the-Installation\" >Step 5. Check and verify the Installation<\/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\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#Step-6-Manage-PostgreSQL-96-service-on-Ubuntu-2004\" >Step 6. Manage PostgreSQL 9.6 service on Ubuntu 20.04<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#Step-7-Configuration-of-PostgreSQL-96-and-console\" >Step 7. Configuration of PostgreSQL 9.6 and console<\/a><\/li><\/ul><\/nav><\/div>\n<h2 id=\"h-prerequisites\"><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p><!-- \/wp:paragraph --><\/p>\r\n<p><!-- \/wp:paragraph --><\/p>\r\n<ul>\r\n<li>Fresh install of Ubuntu 20.04<\/li>\r\n<li>User privileges: root or non-root user with <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-create-users-and-manage-their-sudo-privileges-on-ubuntu\/\">sudo privileges<\/a><\/li>\r\n<\/ul>\r\n<h2><span class=\"ez-toc-section\" id=\"Step-1-Update-the-System\"><\/span>Step 1. Update the System<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>Since this is a fresh install of Ubuntu 20.04 we need to update the system to its latest version and be sure the software is up to date.<\/p>\r\n<pre>sudo apt-get update -y &amp;&amp; sudo apt-get upgrade -y<\/pre>\r\n<p>After executing the command it will take some time for the system to get the latest information.<\/p>\r\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Import-PostgreSQL-96-GPG-public-key\"><\/span>Step 2. Import PostgreSQL 9.6 GPG public key<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>The signing GPG key can be added with the following command:<\/p>\r\n<pre>wget --quiet -O - https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo apt-key add -<\/pre>\r\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Add-PostgreSQL-96-repository\"><\/span>Step 3. Add PostgreSQL 9.6 repository<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>By default, Ubuntu 20.04 does not have the PostgreSQL repo and we need to add it manually so we can install it later.<\/p>\r\n<pre>echo \"deb http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ $(lsb_release -cs)-pgdg main\" | sudo tee \/etc\/apt\/sources.list.d\/postgresql-pgdg.list &gt; \/dev\/null<\/pre>\r\n<p>Once the repository is added update the system.<\/p>\r\n<pre>sudo apt-get update -y<\/pre>\r\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Install-PostgreSQL-96\"><\/span>Step 4. Install PostgreSQL 9.6<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>Now the GPG key and the repo are added and we are ready to install PostgreSQL 9.6 on our Ubuntu 20.04<\/p>\r\n<pre>sudo apt-get install postgresql-9.6<\/pre>\r\n<p>The command above will completely install the PostgreSQL database server and other required database modules and tools.<\/p>\r\n<h2><span class=\"ez-toc-section\" id=\"Step-5-Check-and-verify-the-Installation\"><\/span>Step 5. Check and verify the Installation<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>First of all, you need to know that PostgreSQL is working on port 5432.<\/p>\r\n<p>To check this you can execute the command below:<\/p>\r\n<pre>sudo netstat -tunlp | grep 5432<\/pre>\r\n<p>The output should be:<\/p>\r\n<pre>root@vps:~# sudo netstat -tunlp | grep 5432<br \/>\r\ntcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      31266\/postgres<\/pre>\r\n<p>We can see that the Postgres service is running on port 5432 successfully.<\/p>\r\n<p>If you want to check and verify that the correct version is installed, please execute:<\/p>\r\n<pre>sudo psql --version<\/pre>\r\n<p>The output should be:<\/p>\r\n<pre>root@vps:~# sudo psql --version<br \/>\r\npsql (PostgreSQL) 9.6.22<\/pre>\r\n<p>Once everything is installed and prepared we can go to the next step, and that step is how to manage the PostgreSQL service.<\/p>\r\n<h2><span class=\"ez-toc-section\" id=\"Step-6-Manage-PostgreSQL-96-service-on-Ubuntu-2004\"><\/span>Step 6. Manage PostgreSQL 9.6 service on Ubuntu 20.04<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>Here are some basic commands on how to manage the PostgreSQL services like status, starting, stopping, and restarting.<\/p>\r\n<p>To check the status of the PostgreSQL service:<\/p>\r\n<pre>sudo service postgresql status<\/pre>\r\n<p>The output should be similar to the output below:<\/p>\r\n<pre>#sudo service postgresql status<br \/>\r\n\u25cf postgresql.service - PostgreSQL RDBMS<br \/>\r\n     Loaded: loaded (\/lib\/systemd\/system\/postgresql.service; enabled; vendor preset: enabled)<br \/>\r\n     Active: active (exited) since Sun 2021-08-08 12:59:50 UTC; 1min 5s ago<br \/>\r\n    Process: 793 ExecStart=\/bin\/true (code=exited, status=0\/SUCCESS)<br \/>\r\n   Main PID: 793 (code=exited, status=0\/SUCCESS)<\/pre>\r\n<p>&nbsp;<\/p>\r\n<pre>Aug 08 12:59:50 vps systemd[1]: Starting PostgreSQL RDBMS...<br \/>\r\nAug 08 12:59:50 vps systemd[1]: Finished PostgreSQL RDBMS.<\/pre>\r\n<p>To stop the PostgreSQL service.<\/p>\r\n<pre>sudo service postgresql stop<\/pre>\r\n<p>There will be no output but if you check the status of the service there will be minor changes from the previous output.<\/p>\r\n<pre>sudo service postgresql status<\/pre>\r\n<pre>#sudo service postgresql status\r\n\u25cf postgresql.service - PostgreSQL RDBMS<br \/>\r\n     Loaded: loaded (\/lib\/systemd\/system\/postgresql.service; enabled; vendor preset: enabled)<br \/>\r\n     Active: inactive (dead) since Sun 2021-08-08 13:03:18 UTC; 24s ago<br \/>\r\n    Process: 793 ExecStart=\/bin\/true (code=exited, status=0\/SUCCESS)<br \/>\r\n   Main PID: 793 (code=exited, status=0\/SUCCESS)<br \/>\r\nAug 08 12:59:50 vps systemd[1]: Starting PostgreSQL RDBMS...<br \/>\r\nAug 08 12:59:50 vps systemd[1]: Finished PostgreSQL RDBMS.<br \/>\r\nAug 08 13:03:18 test.vps systemd[1]: postgresql.service: Succeeded.<br \/>\r\nAug 08 13:03:18 test.vps systemd[1]: Stopped PostgreSQL RDBMS.<\/pre>\r\n<p>To start the PostgreSQL service:<\/p>\r\n<pre>sudo service postgresql start<\/pre>\r\n<p>To restart the PostgreSQL service:<\/p>\r\n<pre>sudo service postgresql restart<\/pre>\r\n<p>If you want the PostgreSQL service to run on system boot you need to enable it and it can be done with the following command:<\/p>\r\n<pre>sudo service postgresql enable<\/pre>\r\n<h2><span class=\"ez-toc-section\" id=\"Step-7-Configuration-of-PostgreSQL-96-and-console\"><\/span>Step 7. Configuration of PostgreSQL 9.6 and console<span class=\"ez-toc-section-end\"><\/span><\/h2>\r\n<p>If you want to make any changes in the configuration file of Postgres services like accessibility, authentication, connectivity, or resource usage then you need to open the &#8220;<b>\/etc\/postgresql\/9.6\/main\/postgresql.conf<\/b>&#8221; with some editor and make the necessary changes.<\/p>\r\n<p>To access the console of the PostgreSQL service you need to log in as &#8220;postgres&#8221; user and execute the following commands:<\/p>\r\n<pre>sudo su - postgres<br \/>\r\npsql<\/pre>\r\n<p>The output should be:<\/p>\r\n<pre>#psql<br \/>\r\npsql (9.6.22)<br \/>\r\nType \"help\" for help.<br \/>\r\npostgres=#<\/pre>\r\n<p>Now, you can list the default databases with the &#8220;<b>\\l<\/b>&#8221; command and the output will be similar to the output below:<\/p>\r\n<pre> postgres=#  \\l<br \/>\r\n  List of databases<br \/>\r\n   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges<br \/>\r\n-----------+----------+----------+-------------+-------------+-----------------------<br \/>\r\n postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |<br \/>\r\n template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +<br \/>\r\n           |          |          |             |             | postgres=CTc\/postgres<br \/>\r\n template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +<br \/>\r\n           |          |          |             |             | postgres=CTc\/postgres<\/pre>\r\n<p>&nbsp;<\/p>\r\n<p>To quit from the PostgreSQL shell just type &#8220;<b>\\q<\/b>&#8220;.<\/p>\r\n<p>Done. You successfully installed and managed the PostgreSQL 9.6 service on Ubuntu 20.04.<\/p>\r\n<p><img decoding=\"async\" class=\"alignright size-full wp-image-4176\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2014\/08\/postgresql.png\" alt=\"postgresql\" width=\"252\" height=\"280\" \/>Of course, you don\u2019t have to <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting.html\">install PostgreSQL 9.6 on Ubuntu 20.04<\/a>, if you use one of our PostgreSQL VPS Hosting plans, in which case you can simply ask our expert Linux admins to install PostgreSQL 9.6 on Ubuntu 20.04 for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\r\n<p>If you liked this post on how to install PostgreSQL 9.6 on Ubuntu 20.04, please share it with your friends on the social networks using the buttons on the left or simply leave a reply below. Also, feel free to check out our post on <a href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-9\/\">how to install PostgreSQL on Debian 9<\/a>. Thanks.<\/p>","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we are going to show you how to install PostgreSQL 9.6 on Ubuntu 20.04. We will explain &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install PostgreSQL 9.6 on Ubuntu 20.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#more-38549\" aria-label=\"Read more about How to Install PostgreSQL 9.6 on Ubuntu 20.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":38781,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,1698],"tags":[172,434,1839],"class_list":["post-38549","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","category-ubuntu","tag-install","tag-postgresql","tag-ubuntu-20-04","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.5 (Yoast SEO v27.5) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install PostgreSQL 9.6 on Ubuntu 20.04 | RoseHosting<\/title>\n<meta name=\"description\" content=\"Wondering how to install PostgresSQL 9.6 on Ubuntu 20.04? Take a look at our step-by-step tutorial and learn more.\" \/>\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-postgresql-9-6-on-ubuntu-20-04\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Install PostgreSQL 9.6 on Ubuntu 20.04\" \/>\n<meta property=\"og:description\" content=\"Wondering how to install PostgresSQL 9.6 on Ubuntu 20.04? Take a look at our step-by-step tutorial and learn more.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/\" \/>\n<meta property=\"og:site_name\" content=\"RoseHosting\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/RoseHosting\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/rosehosting.helpdesk\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-22T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-06-03T08:31:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg?v=1629790782\" \/>\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:description\" content=\"Wondering how to install PostgresSQL 9.6 on Ubuntu 20.04? Take a look at our step-by-step tutorial and learn more.\" \/>\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-postgresql-9-6-on-ubuntu-20-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install PostgreSQL 9.6 on Ubuntu 20.04\",\"datePublished\":\"2021-09-22T17:30:00+00:00\",\"dateModified\":\"2022-06-03T08:31:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/\"},\"wordCount\":639,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg\",\"keywords\":[\"install\",\"PostgreSQL\",\"Ubuntu 20.04\"],\"articleSection\":[\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/\",\"name\":\"How to Install PostgreSQL 9.6 on Ubuntu 20.04 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg\",\"datePublished\":\"2021-09-22T17:30:00+00:00\",\"dateModified\":\"2022-06-03T08:31:32+00:00\",\"description\":\"Wondering how to install PostgresSQL 9.6 on Ubuntu 20.04? Take a look at our step-by-step tutorial and learn more.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/08\\\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg\",\"width\":742,\"height\":372,\"caption\":\"How to Install PostgreSQL 9.6 on Ubuntu 20.04\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-9-6-on-ubuntu-20-04\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install PostgreSQL 9.6 on Ubuntu 20.04\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"name\":\"RoseHosting.com\",\"description\":\"Premium Linux Tutorials Since 2001\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\",\"name\":\"RoseHosting\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/03\\\/android-chrome-192x192-1.png\",\"width\":192,\"height\":192,\"caption\":\"RoseHosting\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/RoseHosting\",\"https:\\\/\\\/x.com\\\/rosehosting\",\"https:\\\/\\\/www.linkedin.com\\\/in\\\/rosehosting\\\/\"],\"description\":\"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.\",\"email\":\"info@rosehosting.com\",\"telephone\":\"(314) 275-0414\",\"legalName\":\"Rose Web Services LLC\",\"foundingDate\":\"2001-04-02\",\"numberOfEmployees\":{\"@type\":\"QuantitativeValue\",\"minValue\":\"11\",\"maxValue\":\"50\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\",\"name\":\"Jeff Wilson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g\",\"caption\":\"Jeff Wilson\"},\"description\":\"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.\",\"sameAs\":[\"https:\\\/\\\/www.rosehosting.com\",\"https:\\\/\\\/www.facebook.com\\\/rosehosting.helpdesk\"],\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/author\\\/jwilson\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Install PostgreSQL 9.6 on Ubuntu 20.04 | RoseHosting","description":"Wondering how to install PostgresSQL 9.6 on Ubuntu 20.04? Take a look at our step-by-step tutorial and learn more.","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-postgresql-9-6-on-ubuntu-20-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL 9.6 on Ubuntu 20.04","og_description":"Wondering how to install PostgresSQL 9.6 on Ubuntu 20.04? Take a look at our step-by-step tutorial and learn more.","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2021-09-22T17:30:00+00:00","article_modified_time":"2022-06-03T08:31:32+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg?v=1629790782","type":"image\/jpeg"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_description":"Wondering how to install PostgresSQL 9.6 on Ubuntu 20.04? Take a look at our step-by-step tutorial and learn more.","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-postgresql-9-6-on-ubuntu-20-04\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install PostgreSQL 9.6 on Ubuntu 20.04","datePublished":"2021-09-22T17:30:00+00:00","dateModified":"2022-06-03T08:31:32+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/"},"wordCount":639,"commentCount":1,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg","keywords":["install","PostgreSQL","Ubuntu 20.04"],"articleSection":["Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/","name":"How to Install PostgreSQL 9.6 on Ubuntu 20.04 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg","datePublished":"2021-09-22T17:30:00+00:00","dateModified":"2022-06-03T08:31:32+00:00","description":"Wondering how to install PostgresSQL 9.6 on Ubuntu 20.04? Take a look at our step-by-step tutorial and learn more.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2021\/08\/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg","width":742,"height":372,"caption":"How to Install PostgreSQL 9.6 on Ubuntu 20.04"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-9-6-on-ubuntu-20-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install PostgreSQL 9.6 on Ubuntu 20.04"}]},{"@type":"WebSite","@id":"https:\/\/www.rosehosting.com\/blog\/#website","url":"https:\/\/www.rosehosting.com\/blog\/","name":"RoseHosting.com","description":"Premium Linux Tutorials Since 2001","publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.rosehosting.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.rosehosting.com\/blog\/#organization","name":"RoseHosting","url":"https:\/\/www.rosehosting.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/03\/android-chrome-192x192-1.png","width":192,"height":192,"caption":"RoseHosting"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/RoseHosting","https:\/\/x.com\/rosehosting","https:\/\/www.linkedin.com\/in\/rosehosting\/"],"description":"RoseHosting is a leading Linux hosting provider, serving thousands of clients world-wide since 2001.","email":"info@rosehosting.com","telephone":"(314) 275-0414","legalName":"Rose Web Services LLC","foundingDate":"2001-04-02","numberOfEmployees":{"@type":"QuantitativeValue","minValue":"11","maxValue":"50"}},{"@type":"Person","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713","name":"Jeff Wilson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/0985fed6af04cc60703d2ecf27c65dfa373e0ca00eb21c0b03477e099ea3f99f?s=96&r=g","caption":"Jeff Wilson"},"description":"An experienced Linux veteran with many years of experience. Helping other Linux admins with frequent Linux and business-related blog posts on the RoseHosting blog. Techie by choice. Loving nature and travel. Happily married and father of two lovely children.","sameAs":["https:\/\/www.rosehosting.com","https:\/\/www.facebook.com\/rosehosting.helpdesk"],"url":"https:\/\/www.rosehosting.com\/blog\/author\/jwilson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/38549","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=38549"}],"version-history":[{"count":24,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/38549\/revisions"}],"predecessor-version":[{"id":41051,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/38549\/revisions\/41051"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/38781"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=38549"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=38549"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=38549"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}