How to Install PostgreSQL 9.6 on Ubuntu 20.04

link管理

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

豁达的圣诞树 · PostgreSQL ...· 1 月前 ·

奔跑的创口贴 · 无需添加引号使PostgreSQL标识符区分 ...· 3 周前 ·

不拘小节的毛衣 · PostgreSQL操作-psql基本命令 ...· 1 周前 ·

曾深爱过的沙滩裤 · API(湖仓版)有哪些公共错误码_云原生数据 ...· 1 年前 ·

彷徨的青蛙 · 烧脑：docker多容器中的mongodb多 ...· 1 年前 ·

逼格高的打火机 · yarn 更新指定版本-掘金· 2 年前 ·

怕老婆的沙发 · 效益:NPM5.0完整性检查和moderni ...· 2 年前 ·

</noscript><a class="screen-reader-text skip-link" href="#content" title="Skip to content">Skip to content</a><nav class="has-branding main-navigation nav-align-center has-menu-bar-items sub-menu-right" id="site-navigation" aria-label="Primary" itemtype="https://schema.org/SiteNavigationElement" itemscope=""><div class="inside-navigation"><div class="navigation-branding"><div class="site-logo"><a href="https://www.rosehosting.com" title="RoseHosting" rel="home"><img class="header-image is-logo-image" alt="RoseHosting" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20360%2094'%3E%3C/svg%3E" title="RoseHosting" width="360" height="94" data-lazy-src="https://www.rosehosting.com/blog/wp-content/uploads/2023/05/rosehosting-logo.webp"/><noscript><img class="header-image is-logo-image" alt="RoseHosting" src="https://www.rosehosting.com/blog/wp-content/uploads/2023/05/rosehosting-logo.webp" title="RoseHosting" width="360" height="94"/></noscript></a></div></div><button class="menu-toggle" aria-controls="primary-menu" aria-expanded="false"><span class="gp-icon icon-menu-bars"><svg viewbox="0 0 512 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path d="M0 96c0-13.255 10.745-24 24-24h464c13.255 0 24 10.745 24 24s-10.745 24-24 24H24c-13.255 0-24-10.745-24-24zm0 160c0-13.255 10.745-24 24-24h464c13.255 0 24 10.745 24 24s-10.745 24-24 24H24c-13.255 0-24-10.745-24-24zm0 160c0-13.255 10.745-24 24-24h464c13.255 0 24 10.745 24 24s-10.745 24-24 24H24c-13.255 0-24-10.745-24-24z"/></svg><svg viewbox="0 0 512 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path d="M71.029 71.029c9.373-9.372 24.569-9.372 33.942 0L256 222.059l151.029-151.03c9.373-9.372 24.569-9.372 33.942 0 9.372 9.373 9.372 24.569 0 33.942L289.941 256l151.03 151.029c9.372 9.373 9.372 24.569 0 33.942-9.373 9.372-24.569 9.372-33.942 0L256 289.941l-151.029 151.03c-9.373 9.372-24.569 9.372-33.942 0-9.372-9.373-9.372-24.569 0-33.942L222.059 256 71.029 104.971c-9.372-9.373-9.372-24.569 0-33.942z"/></svg></span><span class="mobile-menu">Menu</span></button><div id="primary-menu" class="main-nav"><ul id="menu-header-menu" class=" menu sf-menu"><li id="menu-item-45820" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-45820"><a href="#">Managed Hosting<span role="presentation" class="dropdown-menu-toggle"><span class="gp-icon icon-arrow"><svg viewbox="0 0 330 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path d="M305.913 197.085c0 2.266-1.133 4.815-2.833 6.514L171.087 335.593c-1.7 1.7-4.249 2.832-6.515 2.832s-4.815-1.133-6.515-2.832L26.064 203.599c-1.7-1.7-2.832-4.248-2.832-6.514s1.132-4.816 2.832-6.515l14.162-14.163c1.7-1.699 3.966-2.832 6.515-2.832 2.266 0 4.815 1.133 6.515 2.832l111.316 111.317 111.316-111.317c1.7-1.699 4.249-2.832 6.515-2.832s4.815 1.133 6.515 2.832l14.162 14.163c1.7 1.7 2.833 4.249 2.833 6.515z"/></svg></span></span></a><ul class="sub-menu"><li id="menu-item-45821" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45821"><a href="https://www.rosehosting.com/linux-vps-hosting/">Linux VPS Hosting</a></li><li id="menu-item-45822" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45822"><a href="https://www.rosehosting.com/dedicated-servers/">Dedicated Hosting</a></li><li id="menu-item-45823" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45823"><a href="https://www.rosehosting.com/wordpress-hosting/">WordPress Hosting</a></li><li id="menu-item-45824" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45824"><a href="https://secure.rosehosting.com/clientarea/?cmd=cart&amp;action=add&amp;id=82">Custom VPS</a></li><li id="menu-item-45825" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45825"><a href="https://www.rosehosting.com/agency-hosting/">Agency Hosting</a></li><li id="menu-item-45826" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45826"><a href="https://www.rosehosting.com/magento-hosting/">Magento Hosting</a></li><li id="menu-item-45827" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45827"><a href="https://www.rosehosting.com/odoo-hosting/">Odoo Hosting</a></li><li id="menu-item-45828" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45828"><a href="https://www.rosehosting.com/nextcloud-hosting/">Nextcloud Hosting</a></li><li id="menu-item-45829" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45829"><a href="https://www.rosehosting.com/woocommerce-hosting/">WooCommerce Hosting</a></li><li id="menu-item-45830" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45830"><a href="https://www.rosehosting.com/prestashop-hosting/">PrestaShop Hosting</a></li><li id="menu-item-45831" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45831"><a href="https://www.rosehosting.com/hosting-solutions/">Hosting Solutions</a></li></ul></li><li id="menu-item-45832" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-45832"><a href="#">SSL / Domains<span role="presentation" class="dropdown-menu-toggle"><span class="gp-icon icon-arrow"><svg viewbox="0 0 330 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path d="M305.913 197.085c0 2.266-1.133 4.815-2.833 6.514L171.087 335.593c-1.7 1.7-4.249 2.832-6.515 2.832s-4.815-1.133-6.515-2.832L26.064 203.599c-1.7-1.7-2.832-4.248-2.832-6.514s1.132-4.816 2.832-6.515l14.162-14.163c1.7-1.699 3.966-2.832 6.515-2.832 2.266 0 4.815 1.133 6.515 2.832l111.316 111.317 111.316-111.317c1.7-1.699 4.249-2.832 6.515-2.832s4.815 1.133 6.515 2.832l14.162 14.163c1.7 1.7 2.833 4.249 2.833 6.515z"/></svg></span></span></a><ul class="sub-menu"><li id="menu-item-45833" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45833"><a href="https://www.rosehosting.com/ssl-certificate-brands/">Grouped By Brand</a></li><li id="menu-item-45834" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45834"><a href="https://www.rosehosting.com/ssl-certificate-types/">Grouped By Type</a></li><li id="menu-item-45835" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45835"><a href="https://secure.rosehosting.com/clientarea/index.php?/checkdomain/domain-registration/">Register Domains</a></li><li id="menu-item-45836" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45836"><a href="https://secure.rosehosting.com/clientarea/index.php?/checkdomain/domain-registration/#transfer">Transfer Domains</a></li></ul></li><li id="menu-item-45837" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-45837"><a href="#">Support<span role="presentation" class="dropdown-menu-toggle"><span class="gp-icon icon-arrow"><svg viewbox="0 0 330 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path d="M305.913 197.085c0 2.266-1.133 4.815-2.833 6.514L171.087 335.593c-1.7 1.7-4.249 2.832-6.515 2.832s-4.815-1.133-6.515-2.832L26.064 203.599c-1.7-1.7-2.832-4.248-2.832-6.514s1.132-4.816 2.832-6.515l14.162-14.163c1.7-1.699 3.966-2.832 6.515-2.832 2.266 0 4.815 1.133 6.515 2.832l111.316 111.317 111.316-111.317c1.7-1.699 4.249-2.832 6.515-2.832s4.815 1.133 6.515 2.832l14.162 14.163c1.7 1.7 2.833 4.249 2.833 6.515z"/></svg></span></span></a><ul class="sub-menu"><li id="menu-item-45838" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45838"><a href="https://www.rosehosting.com/support/">24/7 Managed Support</a></li><li id="menu-item-45839" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45839"><a href="https://www.rosehosting.com/support/server-migration/">Managed Migrations</a></li><li id="menu-item-45840" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45840"><a href="https://www.rosehosting.com/support/managed-hosting/">Fully-Managed Hosting</a></li><li id="menu-item-45841" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45841"><a href="https://status.rosehosting.com/">System Status</a></li></ul></li><li id="menu-item-45842" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-45842"><a href="#">About Us<span role="presentation" class="dropdown-menu-toggle"><span class="gp-icon icon-arrow"><svg viewbox="0 0 330 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path d="M305.913 197.085c0 2.266-1.133 4.815-2.833 6.514L171.087 335.593c-1.7 1.7-4.249 2.832-6.515 2.832s-4.815-1.133-6.515-2.832L26.064 203.599c-1.7-1.7-2.832-4.248-2.832-6.514s1.132-4.816 2.832-6.515l14.162-14.163c1.7-1.699 3.966-2.832 6.515-2.832 2.266 0 4.815 1.133 6.515 2.832l111.316 111.317 111.316-111.317c1.7-1.699 4.249-2.832 6.515-2.832s4.815 1.133 6.515 2.832l14.162 14.163c1.7 1.7 2.833 4.249 2.833 6.515z"/></svg></span></span></a><ul class="sub-menu"><li id="menu-item-45843" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45843"><a href="https://www.rosehosting.com/about-us/">Our Company</a></li><li id="menu-item-45844" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45844"><a href="https://www.rosehosting.com/about-us/contact-us/">Contact Us</a></li><li id="menu-item-45845" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45845"><a href="https://www.rosehosting.com/about-us/awards-and-recognition/">Awards &amp; Recognition</a></li><li id="menu-item-45846" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45846"><a href="https://www.rosehosting.com/about-us/hosting-customer-reviews/">Customer Reviews</a></li><li id="menu-item-45847" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45847"><a href="https://www.rosehosting.com/legal/">Our Policies</a></li><li id="menu-item-45848" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45848"><a href="https://www.rosehosting.com/about-us/why-choose-rosehosting/">Why RoseHosting</a></li><li id="menu-item-45849" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45849"><a href="https://www.rosehosting.com/about-us/compare-rosehosting/">Compare Us</a></li></ul></li><li id="menu-item-45850" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-has-children menu-item-45850"><a href="#">Affiliates<span role="presentation" class="dropdown-menu-toggle"><span class="gp-icon icon-arrow"><svg viewbox="0 0 330 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path d="M305.913 197.085c0 2.266-1.133 4.815-2.833 6.514L171.087 335.593c-1.7 1.7-4.249 2.832-6.515 2.832s-4.815-1.133-6.515-2.832L26.064 203.599c-1.7-1.7-2.832-4.248-2.832-6.514s1.132-4.816 2.832-6.515l14.162-14.163c1.7-1.699 3.966-2.832 6.515-2.832 2.266 0 4.815 1.133 6.515 2.832l111.316 111.317 111.316-111.317c1.7-1.699 4.249-2.832 6.515-2.832s4.815 1.133 6.515 2.832l14.162 14.163c1.7 1.7 2.833 4.249 2.833 6.515z"/></svg></span></span></a><ul class="sub-menu"><li id="menu-item-45851" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45851"><a href="https://www.rosehosting.com/affiliate-program/">Affiiliate Program</a></li><li id="menu-item-45852" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-45852"><a href="https://secure.rosehosting.com/clientarea/index.php?/clientarea/">Affiliate Login</a></li></ul></li><li id="menu-item-45854" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-home menu-item-45854"><a href="https://www.rosehosting.com/blog/">Blog</a></li></ul></div><div class="menu-bar-items"><span class="menu-bar-item"><a href="#" role="button" aria-label="Open search" data-gpmodal-trigger="gp-search"><span class="gp-icon icon-search"><svg viewbox="0 0 512 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path fill-rule="evenodd" clip-rule="evenodd" d="M208 48c-88.366 0-160 71.634-160 160s71.634 160 160 160 160-71.634 160-160S296.366 48 208 48zM0 208C0 93.125 93.125 0 208 0s208 93.125 208 208c0 48.741-16.765 93.566-44.843 129.024l133.826 134.018c9.366 9.379 9.355 24.575-.025 33.941-9.379 9.366-24.575 9.355-33.941-.025L337.238 370.987C301.747 399.167 256.839 416 208 416 93.125 416 0 322.875 0 208z"/></svg><svg viewbox="0 0 512 512" aria-hidden="true" xmlns="http://www.w3.org/2000/svg" width="1em" height="1em"><path d="M71.029 71.029c9.373-9.372 24.569-9.372 33.942 0L256 222.059l151.029-151.03c9.373-9.372 24.569-9.372 33.942 0 9.372 9.373 9.372 24.569 0 33.942L289.941 256l151.03 151.029c9.372 9.373 9.372 24.569 0 33.942-9.373 9.372-24.569 9.372-33.942 0L256 289.941l-151.029 151.03c-9.373 9.372-24.569 9.372-33.942 0-9.372-9.373-9.372-24.569 0-33.942L222.059 256 71.029 104.971c-9.372-9.373-9.372-24.569 0-33.942z"/></svg></span></a></span></div></div></nav><div class="rhbl-f5004e56656b38274cb0eb9a6b6fcf68 rhbl-below-menu" id="rhbl-f5004e56656b38274cb0eb9a6b6fcf68"/><div class="site grid-container container hfeed" id="page"><div class="site-content" id="content"><div class="content-area" id="primary"><main class="site-main" id="main"><article id="post-38549" class="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" itemtype="https://schema.org/CreativeWork" itemscope=""><div class="inside-article"><header class="entry-header" aria-label="Content"><h1 class="entry-title" itemprop="headline">How to Install PostgreSQL 9.6 on Ubuntu 20.04</h1><div class="entry-meta"><span class="posted-on"><time class="updated" datetime="2022-06-03T03:31:32-05:00" itemprop="dateModified">June 3, 2022</time><time class="entry-date published" datetime="2021-09-22T12:30:00-05:00" itemprop="datePublished">September 22, 2021</time></span> <span class="byline">by <span class="author vcard" itemprop="author" itemtype="https://schema.org/Person" itemscope=""><a class="url fn n" href="https://www.rosehosting.com/blog/author/jwilson/" title="View all posts by Jeff Wilson" rel="author" itemprop="url"><span class="author-name" itemprop="name">Jeff Wilson</span></a></span></span> </div></header><div class="entry-content" itemprop="text"><figure class="wp-block-image size-full"><img decoding="async" fetchpriority="high" width="742" height="372" class="wp-image-38781" src="data:image/svg+xml,%3Csvg%20xmlns='http://www.w3.org/2000/svg'%20viewBox='0%200%20742%20372'%3E%3C/svg%3E" alt="How to Install PostgreSQL 9.6 on Ubuntu 20.04" data-lazy-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" data-lazy-sizes="(max-width: 742px) 100vw, 742px" data-lazy-src="https://www.rosehosting.com/blog/wp-content/uploads/2021/08/how-to-install-postgreSQL-9.6-on-ubuntu-20.04.jpg"/><noscript><img decoding="async" fetchpriority="high" 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"/></noscript></figure><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><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><p/><p/><p>The installation will take no more than 5 minutes. Let’s Start!</p><p><span id="more-38549"/></p><p/><p/><div id="ez-toc-container" class="ez-toc-v2_0_55 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction"><p class="ez-toc-title">Table of Contents</p><label for="ez-toc-cssicon-toggle-item-64ff572152b9c"><span class="ez-toc-cssicon"><span style=";">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"/></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-64ff572152b9c" 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="#Prerequisites" title="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="#Step-1-Update-the-System" title="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="#Step-2-Import-PostgreSQL-96-GPG-public-key" title="Step 2. Import PostgreSQL 9.6 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="#Step-3-Add-PostgreSQL-96-repository" title="Step 3. Add PostgreSQL 9.6 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="#Step-4-Install-PostgreSQL-96" title="Step 4. Install PostgreSQL 9.6">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="#Step-5-Check-and-verify-the-Installation" title="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="#Step-6-Manage-PostgreSQL-96-service-on-Ubuntu-2004" title="Step 6. Manage PostgreSQL 9.6 service on Ubuntu 20.04">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="#Step-7-Configuration-of-PostgreSQL-96-and-console" title="Step 7. Configuration of PostgreSQL 9.6 and console">Step 7. Configuration of PostgreSQL 9.6 and console</a></li></ul></nav></div><h2 id="h-prerequisites"><span class="ez-toc-section" id="Prerequisites"/>Prerequisites<span class="ez-toc-section-end"/></h2><p/><p/><ul><li>Fresh install of Ubuntu 20.04</li><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></ul><h2><span class="ez-toc-section" id="Step-1-Update-the-System"/>Step 1. Update the System<span class="ez-toc-section-end"/></h2><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><pre>sudo apt-get update -y &amp;&amp; sudo apt-get upgrade -y</pre><p>After executing the command it will take some time for the system to get the latest information.</p><h2><span class="ez-toc-section" id="Step-2-Import-PostgreSQL-96-GPG-public-key"/>Step 2. Import PostgreSQL 9.6 GPG public key<span class="ez-toc-section-end"/></h2><p>The signing GPG key can be added with the following command:</p><pre>wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | sudo apt-key add -</pre><h2><span class="ez-toc-section" id="Step-3-Add-PostgreSQL-96-repository"/>Step 3. Add PostgreSQL 9.6 repository<span class="ez-toc-section-end"/></h2><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><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><p>Once the repository is added update the system.</p><pre>sudo apt-get update -y</pre><h2><span class="ez-toc-section" id="Step-4-Install-PostgreSQL-96"/>Step 4. Install PostgreSQL 9.6<span class="ez-toc-section-end"/></h2><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><pre>sudo apt-get install postgresql-9.6</pre><p>The command above will completely install the PostgreSQL database server and other required database modules and tools.</p><h2><span class="ez-toc-section" id="Step-5-Check-and-verify-the-Installation"/>Step 5. Check and verify the Installation<span class="ez-toc-section-end"/></h2><p>First of all, you need to know that PostgreSQL is working on port 5432.</p><p>To check this you can execute the command below:</p><pre>sudo netstat -tunlp | grep 5432</pre><p>The output should be:</p><pre>root@vps:~# sudo netstat -tunlp | grep 5432<br/> tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN 31266/postgres</pre><p>We can see that the Postgres service is running on port 5432 successfully.</p><p>If you want to check and verify that the correct version is installed, please execute:</p><pre>sudo psql --version</pre><p>The output should be:</p><pre>root@vps:~# sudo psql --version<br/> psql (PostgreSQL) 9.6.22</pre><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><h2><span class="ez-toc-section" id="Step-6-Manage-PostgreSQL-96-service-on-Ubuntu-2004"/>Step 6. Manage PostgreSQL 9.6 service on Ubuntu 20.04<span class="ez-toc-section-end"/></h2><p>Here are some basic commands on how to manage the PostgreSQL services like status, starting, stopping, and restarting.</p><p>To check the status of the PostgreSQL service:</p><pre>sudo service postgresql status</pre><p>The output should be similar to the output below:</p><pre>#sudo service postgresql status<br/> ● postgresql.service - PostgreSQL RDBMS<br/> Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)<br/> Active: active (exited) since Sun 2021-08-08 12:59:50 UTC; 1min 5s ago<br/> Process: 793 ExecStart=/bin/true (code=exited, status=0/SUCCESS)<br/> Main PID: 793 (code=exited, status=0/SUCCESS)</pre><p> </p><pre>Aug 08 12:59:50 vps systemd[1]: Starting PostgreSQL RDBMS...<br/> Aug 08 12:59:50 vps systemd[1]: Finished PostgreSQL RDBMS.</pre><p>To stop the PostgreSQL service.</p><pre>sudo service postgresql stop</pre><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><pre>sudo service postgresql status</pre> <pre>#sudo service postgresql status ● postgresql.service - PostgreSQL RDBMS<br/> Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)<br/> Active: inactive (dead) since Sun 2021-08-08 13:03:18 UTC; 24s ago<br/> Process: 793 ExecStart=/bin/true (code=exited, status=0/SUCCESS)<br/> Main PID: 793 (code=exited, status=0/SUCCESS)<br/> Aug 08 12:59:50 vps systemd[1]: Starting PostgreSQL RDBMS...<br/> Aug 08 12:59:50 vps systemd[1]: Finished PostgreSQL RDBMS.<br/> Aug 08 13:03:18 test.vps systemd[1]: postgresql.service: Succeeded.<br/> Aug 08 13:03:18 test.vps systemd[1]: Stopped PostgreSQL RDBMS.</pre><p>To start the PostgreSQL service:</p><pre>sudo service postgresql start</pre><p>To restart the PostgreSQL service:</p><pre>sudo service postgresql restart</pre><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><pre>sudo service postgresql enable</pre><h2><span class="ez-toc-section" id="Step-7-Configuration-of-PostgreSQL-96-and-console"/>Step 7. Configuration of PostgreSQL 9.6 and console<span class="ez-toc-section-end"/></h2><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 “<b>/etc/postgresql/9.6/main/postgresql.conf</b>” with some editor and make the necessary changes.</p><div class="rhbl-content" style="margin-left: auto; margin-right: auto; text-align: center; " id="rhbl-1595713699"><style> .btn-orange2{font-size:clamp(1rem,calc(2rem + ((1vw - 0.32rem) * 0.3571)),1.5rem);font-weight:bold;color:#ffffff !important;text-transform:uppercase;background-color:#ff5700;transition-duration:0.15s;transition-timing-function:ease-in-out;text-align:center;letter-spacing:1px;line-height:1;border-radius:4px;border-color:#ff5700;border-style:solid;padding:10px 10px 10px 10px;margin-bottom:10px;font-family:Mulish,sans-serif}.btn-orange2:hover{transform:scale3d(1.04,1.04,1.04);color:#ff5700;background-color:#ffffff;color:#FF5700 !important}.line{float:left;height:100px;width:1px;background-color:lightgrey;margin-top:auto;margin-bottom:auto}#pricebox{background-clip:content-box;background-color:rgb(243,244,255);min-width:300px;display:flex;flex-direction:column;align-items:center;justify-content:space-between;width:49%;text-align:center;margin-top:0px;padding:10px}.checkbox{font-weight:400;font-size:15px;color:#000000;font-family:Mulish,sans-serif}@media (max-width:992px){#pricebox{background-clip:content-box;background-color:rgb(243,244,255);display:flex;flex-direction:column;align-items:center;justify-content:space-between;width:100%;text-align:center;margin-top:0px;padding:10px}}</style><div style="display: flex; flex-direction: row; flex-wrap: wrap; justify-content: center; font-family: 'Inter'; border-radius: 4px; border: 3px solid rgba(0,87,212,0.3); white-space: nowrap; margin-bottom: 20px;"> <div style="min-width: 300px; align-items: center; width: 49%; text-align: center; margin-top: 0px; padding-bottom: 0px;"> <div style="font-weight: 600; line-height: 1; font-size: clamp(1.2rem, calc(1.4rem + ((1vw - 0.32rem) * 0.3571)), 1.8rem); width: 100%; color: #0057d4; margin-bottom: 0px; padding: 15px 0px 15px 0px; font-family: Mulish, sans-serif;">Need a fast and easy fix?</div> <div style="display: flex; flex-direction: column; align-items: flex-start; width: auto; margin-top:5px; margin: 25px;"> <div class="checkbox">✔ Unlimited Managed Support</div> <div class="checkbox">✔ Supports Your Software</div> <div class="checkbox">✔ 2 CPU Cores</div> <div class="checkbox">✔ 2 GB RAM</div> <div class="checkbox">✔ 50 GB PCIe4 NVMe Disk</div> <div class="checkbox">✔ 1854 GeekBench Score</div> <div class="checkbox">✔ Unmetered Data Transfer</div> </div> </div> <div id="pricebox"> <div style="text-transform: uppercase; font-weight: 600; line-height: 1; font-size: clamp(1.2rem, calc(1.4rem + ((1vw - 0.32rem) * 0.3571)), 1.8rem); width: 100%; color: #0057d4; margin-bottom: 0px; padding: 15px 0px 15px 0px; font-family: Mulish, sans-serif;">NVME 2 VPS</div> <p style="font-size: 35px; font-weight: 600; display: flex; flex-direction: row; align-items: center; padding: 0px; margin-bottom: 30px; font-family: Mulish, sans-serif;">Now just <span style="font-size: 24px; display: inline-block; text-decoration: inherit;">$</span>43 <span style="font-size: 16px; line-height: 1.1;">.99<br/>/mo </span> </p> <a class="btn-orange2" href="https://secure.rosehosting.com/clientarea/?cmd=cart&amp;action=add&amp;id=567" target="_blank" rel="noopener">GET YOUR VPS</a> </div></div></div><p>To access the console of the PostgreSQL service you need to log in as “postgres” user and execute the following commands:</p><pre>sudo su - postgres<br/> psql</pre><p>The output should be:</p><pre>#psql<br/> psql (9.6.22)<br/> Type "help" for help.<br/> postgres=#</pre><p>Now, you can list the default databases with the “<b>\l</b>” command and the output will be similar to the output below:</p><pre> postgres=# \l<br/> List of databases<br/> Name | Owner | Encoding | Collate | Ctype | Access privileges<br/> -----------+----------+----------+-------------+-------------+-----------------------<br/>