{"id":42359,"date":"2022-08-08T12:30:51","date_gmt":"2022-08-08T17:30:51","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=42359"},"modified":"2022-10-05T01:23:46","modified_gmt":"2022-10-05T06:23:46","slug":"how-to-install-postgresql-on-ubuntu-22-04","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/","title":{"rendered":"How to Install PostgreSQL on Ubuntu 22.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"alignnone size-full wp-image-42739\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04.webp\" alt=\"how to install postgresql on ubuntu 22.04\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04.webp 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04-300x150.webp 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04-150x75.webp 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this blog post, we are going to show you how to install PostgreSQL on Ubuntu 22.04 OS.<\/p>\n<p>PostgreSQL is a very powerful object-relational database management system written in C and C++ and used for storing and retrieving information. PostgreSQL is a highly compliant and extensible database that can handle multiple tasks at the same time. Learn about the <a href=\"https:\/\/www.rosehosting.com\/blog\/mysql-vs-sqlite-vs-postgresql\/\">differences between PostgreSQL, MySQL, and SQLite<\/a>.<\/p>\n<p>Installing PostgreSQL on Ubuntu 22.04 is a very easy task and can take up to 10 minutes. Let&#8217;s get started!<\/p>\n<p><!--more--><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-69f01dd281507\" 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-69f01dd281507\"  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-on-ubuntu-22-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-on-ubuntu-22-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-on-ubuntu-22-04\/#Step-2-Install-PostgreSQL\" >Step 2. Install PostgreSQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#Step-3-Configure-PostgreSQL\" >Step 3. Configure PostgreSQL<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<ul>\n<li>A server with Ubuntu 22.04 as OS<\/li>\n<li>User privileges: root or non-root user with sudo privileges<\/li>\n<\/ul>\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>\n<p>We need to update the system packages to the latest versions available.<\/p>\n<pre>sudo apt-get update -y &amp;&amp; sudo apt-get upgrade -y<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-2-Install-PostgreSQL\"><\/span>Step 2. Install PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The latest PostgreSQL version 14 is available in the default repository of Ubuntu 22.04, so we just need to execute the command below:<\/p>\n<pre>sudo apt install postgresql postgresql-client<\/pre>\n<p>Once, installed start and enable the PostgreSQL service.<\/p>\n<pre>sudo systemctl enable postgresql.service &amp;&amp; sudo systemctl start postgresql.service<\/pre>\n<p>Check if the service is up and running:<\/p>\n<pre>sudo systemctl status postgresql.service<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>root@vps:~# sudo systemctl status postgresql.service\r\n\u25cf postgresql.service - PostgreSQL RDBMS\r\n     Loaded: loaded (\/lib\/systemd\/system\/postgresql.service; enabled; vendor preset: enabled)\r\n     Active: active (exited) since Fri 2022-06-17 12:42:57 UTC; 1min 27s ago\r\n   Main PID: 370897 (code=exited, status=0\/SUCCESS)\r\n        CPU: 27ms\r\n\r\nJun 17 12:42:56 host.test.vps systemd[1]: Starting PostgreSQL RDBMS...\r\nJun 17 12:42:57 host.test.vps systemd[1]: Finished PostgreSQL RDBMS.\r\n<\/pre>\n<p>Another way to check about the PostgreSQL service and port is to run the command below:<\/p>\n<pre>sudo netstat -tunlp | grep 5432<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>root@vps:~# sudo netstat -tunlp | grep 5432\r\ntcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      370876\/postgres\r\n<\/pre>\n<p>To check the installed PostgreSQL version, execute the following command:<\/p>\n<pre>sudo psql --version<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>root@host:~# sudo psql --version\r\npsql (PostgreSQL) 14.3 (Ubuntu 14.3-0ubuntu0.22.04.1)\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Configure-PostgreSQL\"><\/span>Step 3. Configure PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>The configuration changes of PostgreSQL 14, are locate at <b>\/etc\/postgresql\/14\/main\/postgresql.conf<\/b> on your server. In this file, you can configure incoming connections, security and authentication, resource usage, etc.<\/p>\n<p>In the next few paragraphs, we are going to show you some of the basic PostgreSQL commands and configurations.<\/p>\n<p><b>Accessing the PostgreSQL console<\/b><\/p>\n<p>To access the PostgreSQL console execute the following command on your server:<\/p>\n<pre>sudo -u postgres psql<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>root@vps:~# sudo -u postgres psql\r\npsql (14.3 (Ubuntu 14.3-0ubuntu0.22.04.1))\r\nType \"help\" for help.\r\n\r\npostgres=#<\/pre>\n<p><b>List Databases<\/b><\/p>\n<p>To list the databases, execute the <b>\\l<\/b> command:<\/p>\n<p>You should receive the following output:<\/p>\n<pre>postgres=# \\l\r\n                                  List of databases\r\n   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges\r\n-----------+----------+----------+-------------+-------------+-----------------------\r\n postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |\r\n template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n           |          |          |             |             | postgres=CTc\/postgres\r\n template1 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c\/postgres          +\r\n           |          |          |             |             | postgres=CTc\/postgres\r\n(3 rows)\r\n\r\npostgres=#\r\n<\/pre>\n<p><b>Select Database<\/b><\/p>\n<p>To select a database, execute the <b>\\c &#8220;database name&#8221;<\/b> command:<\/p>\n<p>You should receive the following output:<\/p>\n<pre>postgres=# \\c postgres\r\nYou are now connected to database \"postgres\" as user \"postgres\".<\/pre>\n<p><b>Quit PostgreSQL shell<\/b><\/p>\n<p>To quit from the PostgreSQL shell, just type &#8220;\\q.&#8221;<\/p>\n<p><b>Allow Remote Access<\/b><\/p>\n<p>To allow remote access so PostgreSQL can be accessed from everywhere, you need to open the <b>\/etc\/postgresql\/14\/main\/pg_hba.conf<\/b> file and configure the following lines of code to look like those described below:<\/p>\n<pre>host    all             all             0.0.0.0\/0                md5<\/pre>\n<p>Save the file, close it, and restart the PostgreSQL service for the changes to take effect.<\/p>\n<p><b>Increase Memory Usage<\/b><\/p>\n<p>To increase the memory usage of PostgreSQL open the <b>\/etc\/postgresql\/14\/main\/postgresql.conf<\/b> file and configure the following lines of code to look like those described below:<\/p>\n<pre>shared_buffers = 256MB<\/pre>\n<p>The default value of <b>shared_buffers<\/b> is <b>128MB<\/b>. Save the file, close it and restart the PostgreSQL service for the changes to take effect.<\/p>\n<pre>sudo systemctl restart postgresql.service<\/pre>\n<p>Congratulations! You successfully installed and configured the latest PostgreSQL 14 version on Ubuntu 22.04.<\/p>\n<p>Of course, you don\u2019t have to install PostgreSQL on Ubuntu 22.04 if you use one of our <a href=\"https:\/\/www.rosehosting.com\/postgresql-hosting\/\">PostgreSQL VPS Hosting<\/a> plans, in which case you can simply ask our expert Linux admins to install PostgreSQL 14 on Ubuntu 22.04 for you. They are available 24\u00d77 and will take care of your request immediately.<\/p>\n<p>If you liked this post on how to install PostgreSQL on Ubuntu 22.04, please share it with your friends on social networks or simply leave a reply below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this blog post, we are going to show you how to install PostgreSQL on Ubuntu 22.04 OS. PostgreSQL is &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install PostgreSQL on Ubuntu 22.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#more-42359\" aria-label=\"Read more about How to Install PostgreSQL on Ubuntu 22.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":42739,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[13,1698],"tags":[1603,434,2012],"class_list":["post-42359","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tutorials","category-ubuntu","tag-how-to-install","tag-postgresql","tag-ubuntu-22-04","generate-columns","tablet-grid-50","mobile-grid-100","grid-parent","grid-33"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install PostgreSQL on Ubuntu 22.04 | RoseHosting<\/title>\n<meta name=\"description\" content=\"In this blog post, we will show you how to install PostgreSQL on Ubuntu 22.04 OS. Read on to find out 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-on-ubuntu-22-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 on Ubuntu 22.04\" \/>\n<meta property=\"og:description\" content=\"In this blog post, we will show you how to install PostgreSQL on Ubuntu 22.04 OS. Read on to find out more!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-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=\"2022-08-08T17:30:51+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-05T06:23:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04.webp\" \/>\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\/webp\" \/>\n<meta name=\"author\" content=\"Jeff Wilson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"How to Install PostgreSQL on Ubuntu 22.04\" \/>\n<meta name=\"twitter:description\" content=\"In this blog post, we will show you how to install PostgreSQL on Ubuntu 22.04 OS. Read on to find out 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=\"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\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install PostgreSQL on Ubuntu 22.04\",\"datePublished\":\"2022-08-08T17:30:51+00:00\",\"dateModified\":\"2022-10-05T06:23:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/\"},\"wordCount\":524,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/how-to-install-postgresql-on-ubuntu-22.04.webp\",\"keywords\":[\"how to install\",\"PostgreSQL\",\"ubuntu 22.04\"],\"articleSection\":[\"Tutorials\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/\",\"name\":\"How to Install PostgreSQL on Ubuntu 22.04 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/how-to-install-postgresql-on-ubuntu-22.04.webp\",\"datePublished\":\"2022-08-08T17:30:51+00:00\",\"dateModified\":\"2022-10-05T06:23:46+00:00\",\"description\":\"In this blog post, we will show you how to install PostgreSQL on Ubuntu 22.04 OS. Read on to find out more!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/how-to-install-postgresql-on-ubuntu-22.04.webp\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/07\\\/how-to-install-postgresql-on-ubuntu-22.04.webp\",\"width\":742,\"height\":372,\"caption\":\"how to install postgresql on ubuntu 22.04\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-22-04\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install PostgreSQL on Ubuntu 22.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 on Ubuntu 22.04 | RoseHosting","description":"In this blog post, we will show you how to install PostgreSQL on Ubuntu 22.04 OS. Read on to find out 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-on-ubuntu-22-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL on Ubuntu 22.04","og_description":"In this blog post, we will show you how to install PostgreSQL on Ubuntu 22.04 OS. Read on to find out more!","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2022-08-08T17:30:51+00:00","article_modified_time":"2022-10-05T06:23:46+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04.webp","type":"image\/webp"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_title":"How to Install PostgreSQL on Ubuntu 22.04","twitter_description":"In this blog post, we will show you how to install PostgreSQL on Ubuntu 22.04 OS. Read on to find out more!","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\/how-to-install-postgresql-on-ubuntu-22-04\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install PostgreSQL on Ubuntu 22.04","datePublished":"2022-08-08T17:30:51+00:00","dateModified":"2022-10-05T06:23:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/"},"wordCount":524,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04.webp","keywords":["how to install","PostgreSQL","ubuntu 22.04"],"articleSection":["Tutorials","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/","name":"How to Install PostgreSQL on Ubuntu 22.04 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04.webp","datePublished":"2022-08-08T17:30:51+00:00","dateModified":"2022-10-05T06:23:46+00:00","description":"In this blog post, we will show you how to install PostgreSQL on Ubuntu 22.04 OS. Read on to find out more!","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04.webp","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/07\/how-to-install-postgresql-on-ubuntu-22.04.webp","width":742,"height":372,"caption":"how to install postgresql on ubuntu 22.04"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-22-04\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install PostgreSQL on Ubuntu 22.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\/42359","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=42359"}],"version-history":[{"count":8,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/42359\/revisions"}],"predecessor-version":[{"id":43270,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/42359\/revisions\/43270"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/42739"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=42359"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=42359"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=42359"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}