{"id":51534,"date":"2026-03-11T12:30:00","date_gmt":"2026-03-11T17:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=51534"},"modified":"2026-02-27T06:49:47","modified_gmt":"2026-02-27T12:49:47","slug":"how-to-install-postgresql-on-ubuntu-26-04","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/","title":{"rendered":"How to Install PostgreSQL on Ubuntu 26.04"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04.webp\" alt=\"How to install PostgreSQL on Ubuntu 26.04\" class=\"wp-image-51629\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04.webp 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04-300x169.webp 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04-150x84.webp 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04-768x432.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>PostgreSQL is an open-source relational database management system (RDBMS). This database management system uses the SQL query language, similar to MySQL. Developed by the Berkeley Computer Science Department, PostgreSQL has been a trusted database for approximately 30 years. PostgreSQL databases are widely used across mobile, web, and analytics applications. PostgreSQL can process data in tables that are related to each other. Generally, this database management system is widely used for various applications with complex data processing requirements. In this article, we will show you how to install PostgreSQL on Ubuntu 26.04 for the first time and outline considerations to keep in mind.<\/p>\n\n\n\n<!--more-->\n\n\n\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-69ee2aa2a1bb7\" 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-69ee2aa2a1bb7\"  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-26-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-26-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-26-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-26-04\/#Step-3-Use-PostgreSQL\" >Step 3. Use PostgreSQL<\/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-on-ubuntu-26-04\/#Step-4-Allow-Remote-Connections\" >Step 4. Allow Remote Connections<\/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-on-ubuntu-26-04\/#Thats-it\" >That&#8217;s it!<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-prerequisites\"><span class=\"ez-toc-section\" id=\"Prerequisites\"><\/span>Prerequisites<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>An <a href=\"https:\/\/www.rosehosting.com\/ubuntu-hosting\/\" target=\"_blank\" rel=\"noreferrer noopener\">Ubuntu 26.04 VPS<\/a> with at least 4GB of RAM is necessary<\/li>\n\n\n\n<li>SSH access with sudo privileges, or root access<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-conventions\">Conventions<\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code># \u2013 given commands should be executed with root privileges either directly as a root user or by use of sudo command\n$ \u2013 given commands should be executed as a regular user<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-1-update-the-system\"><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\n\n\n<p>First, we need to log in to our Ubuntu 26.04 VPS via SSH before installing PostgreSQL.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ssh master@IP_Address -p Port_number<\/code><\/pre>\n\n\n\n<p>Replace &#8220;master&#8221; with a user that has sudo privileges or root if necessary. Additionally, replace &#8220;IP_Address&#8221; and &#8220;Port_Number&#8221; with your server\u2019s respective IP address and SSH port number. Next, let\u2019s make sure that we\u2019re on Ubuntu 26.04. You can verify it with this command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ lsb_release -a<\/code><\/pre>\n\n\n\n<p>You should get this as the output if your system is properly set up for PostgreSQL on Ubuntu 26.04.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>No LSB modules are available.\nDistributor ID:     Ubuntu\nDescription:   Ubuntu Resolute Raccoon \nRelease:  26.04\nCodename: resolute<\/code><\/pre>\n\n\n\n<p>Then run the following command to ensure all installed packages on the server are up to date.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo apt update <\/code><\/pre>\n\n\n\n<p>That&#8217;s it, your system&#8217;s local list of available software packages and their versions from online repositories should be updated now before proceeding with anything related to PostgreSQL on Ubuntu 26.04.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-2-install-postgresql\"><span class=\"ez-toc-section\" id=\"Step-2-Install-PostgreSQL\"><\/span>Step 2. Install PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>There are three methods to install PostgreSQL on Ubuntu 26.04: using the system&#8217;s default repository, using PostgreSQL&#8217;s official repository, or installing from source. In this tutorial, we will show you the easiest methods to get it up and running.<\/p>\n\n\n\n<p>The easiest way is to use the Advanced Package Tool (apt). The installation is easy and straightforward. Execute the command below with apt for best compatibility.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo apt install postgresql<\/code><\/pre>\n\n\n\n<p>On an Ubuntu 26.04 system, PostgreSQL runs automatically upon installation, which is an advantage compared to some other distributions. To verify this, we can invoke this command.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo systemctl status postgresql<\/code><\/pre>\n\n\n\n<p>The command above will return an output similar to this.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>master@ubuntu26:~$ sudo systemctl status postgresql\n\u25cf postgresql.service - PostgreSQL RDBMS\n     Loaded: loaded (\/usr\/lib\/systemd\/system\/postgresql.service; enabled; preset: enabled)\n     Active: active (exited) since Fri 2026-01-16 10:06:54 UTC; 13s ago\n Invocation: f1fe3cef114246d98614f3e41572489a\n   Main PID: 5342 (code=exited, status=0\/SUCCESS)\n   Mem peak: 1.7M\n        CPU: 8ms\n\nJan 16 10:06:54 ubuntu26 systemd&#91;1]: Starting postgresql.service - PostgreSQL RDBMS...\nJan 16 10:06:54 ubuntu26 systemd&#91;1]: Finished postgresql.service - PostgreSQL RDBMS.<\/code><\/pre>\n\n\n\n<p>We can also check the installed PostgreSQL version by running this command and confirming it meets the Ubuntu 26.04 requirements.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ psql --version<\/code><\/pre>\n\n\n\n<p>You should see this in the output if PostgreSQL is installed correctly on Ubuntu 26.04.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">psql (PostgreSQL) 17.6 (Ubuntu 17.6-1build1)<\/pre>\n\n\n\n<p>At the moment, there is no other option to install PostgreSQL as the APT repository for Ubuntu 26.04 is still unavailable. You can check and verify it in the <a href=\"https:\/\/ftp.postgresql.org\/pub\/repos\/apt\/dists\/\" target=\"_blank\" rel=\"noreferrer noopener\">official PostgreSQL repository<\/a> if you need information about future options.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-3-use-postgresql\"><span class=\"ez-toc-section\" id=\"Step-3-Use-PostgreSQL\"><\/span>Step 3. Use PostgreSQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Once PostgreSQL is installed, it should be automatically up and running, and a default database and user account called &#8216;postgres&#8217; will be created during installation. To access the database, execute the following command in the Ubuntu 26.04 system.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo su - postgres<\/code><\/pre>\n\n\n\n<p>After switching to user postgres, we can execute this command to get into the PostgreSQL shell and begin exploring the features.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ psql<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres@ubuntu26:~$ psql\npsql (17.6 (Ubuntu 17.6-1build1))\nType \"help\" for help.\n\npostgres=#<\/code><\/pre>\n\n\n\n<p>Run \\l to list the databases you have in your PostgreSQL on Ubuntu 26.04 environment.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ppostgres@ubuntu26:~$ psql\npsql (17.6 (Ubuntu 17.6-1build1))\nType \"help\" for help.\n\npostgres=# \\l\n                                                 List of databases\n   Name    |  Owner   | Encoding | Locale Provider | Collate |  Ctype  | Locale | ICU Rules |   Access privileges   \n-----------+----------+----------+-----------------+---------+---------+--------+-----------+-----------------------\n postgres  | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |        |           | \n template0 | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |        |           | =c\/postgres          +\n           |          |          |                 |         |         |        |           | postgres=CTc\/postgres\n template1 | postgres | UTF8     | libc            | C.UTF-8 | C.UTF-8 |        |           | =c\/postgres          +\n           |          |          |                 |         |         |        |           | postgres=CTc\/postgres\n(3 rows)\n\npostgres=# <\/code><\/pre>\n\n\n\n<p>To exit from the PostgreSQL shell, simply run \\q, then hit ENTER when you finish.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-step-4-allow-remote-connections\"><span class=\"ez-toc-section\" id=\"Step-4-Allow-Remote-Connections\"><\/span>Step 4. Allow Remote Connections<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By default, PostgreSQL is configured to listen only on localhost. It means you cannot access your PostgreSQL server remotely if you just finished a local installation. To configure PostgreSQL to listen on all available network addresses, let&#8217;s edit the configuration file.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo nano \/etc\/postgresql\/17\/main\/postgresql.conf<\/code><\/pre>\n\n\n\n<p>Uncomment the line listen_addresses = &#8216;localhost&#8217; and replace localhost with *. With this adjustment, your PostgreSQL on Ubuntu 26.04 server will begin accepting remote connections.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>listen_addresses = '*'<\/code><\/pre>\n\n\n\n<p>Save the file, then exit from the editor. We can edit the pg_hba.conf file now to allow password authentication for your instance.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo nano \/etc\/postgresql\/17\/main\/pg_hba.conf<\/code><\/pre>\n\n\n\n<p>Scroll down and append this line to enable external users to access PostgreSQL on Ubuntu 26.04.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>host all all 0.0.0.0\/0 md5<\/code><\/pre>\n\n\n\n<p>Save the file and restart PostgreSQL to apply the changes. Now your system should be configured for remote access.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo systemctl restart postgresql<\/code><\/pre>\n\n\n\n<p>We should be able to access the PostgreSQL server from another machine. However, we need to create a password for &#8216;postgres&#8217; user first.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>$ sudo -u postgres psql<\/code><\/pre>\n\n\n\n<p>In the PostgreSQL shell, run this command so you&#8217;ll secure access to PostgreSQL on Ubuntu 26.04 installations.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\\password postgres<\/code><\/pre>\n\n\n\n<p>You will be prompted to type the password for that user, like this, when setting up your system securely.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres=# \\password postgres\nEnter new password for user \"postgres\": \nEnter it again: <\/code><\/pre>\n\n\n\n<p>At this point, you should be able to access the PostgreSQL server remotely and benefit from running PostgreSQL on Ubuntu 26.04 in your network environment.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-that-s-it\"><span class=\"ez-toc-section\" id=\"Thats-it\"><\/span>That&#8217;s it!<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>You have successfully installed the PostgreSQL server on your Ubuntu 26.04 system and can now manage your applications.<\/p>\n\n\n\n<p>Of course, if you are one of our <a href=\"https:\/\/www.rosehosting.com\/linux-vps-hosting\/\">Linux VPS hosting<\/a> customers, you don\u2019t have to bother with this installation yourself \u2013 simply ask our admins, sit back, and relax. Our admins will take care of the installation for you, at no additional cost. Managing a PostgreSQL-based website is not just about the installation; we can help you optimize your PostgreSQL installation if you have an active VPS with us.<\/p>\n\n\n\n<p>If you liked this post, please share it with your friends, or simply leave a comment down below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>PostgreSQL is an open-source relational database management system (RDBMS). This database management system uses the SQL query language, similar to &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install PostgreSQL on Ubuntu 26.04\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/#more-51534\" aria-label=\"Read more about How to Install PostgreSQL on Ubuntu 26.04\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":51629,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1698],"tags":[1603,434,2308],"class_list":["post-51534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu","tag-how-to-install","tag-postgresql","tag-ubuntu-26-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 26.04 | RoseHosting<\/title>\n<meta name=\"description\" content=\"Learn how to install PostgreSQL on Ubuntu 26.04 effortlessly. Get started with this powerful database management system.\" \/>\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-26-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 26.04\" \/>\n<meta property=\"og:description\" content=\"How to Install PostgreSQL on Ubuntu 26.04 | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-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=\"2026-03-11T17:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"576\" \/>\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: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-on-ubuntu-26-04\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install PostgreSQL on Ubuntu 26.04\",\"datePublished\":\"2026-03-11T17:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/\"},\"wordCount\":844,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/how-to-install-postgresql-on-ubuntu-26.04.webp\",\"keywords\":[\"how to install\",\"PostgreSQL\",\"ubuntu 26.04\"],\"articleSection\":[\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/\",\"name\":\"How to Install PostgreSQL on Ubuntu 26.04 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/how-to-install-postgresql-on-ubuntu-26.04.webp\",\"datePublished\":\"2026-03-11T17:30:00+00:00\",\"description\":\"Learn how to install PostgreSQL on Ubuntu 26.04 effortlessly. Get started with this powerful database management system.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-04\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/how-to-install-postgresql-on-ubuntu-26.04.webp\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/03\\\/how-to-install-postgresql-on-ubuntu-26.04.webp\",\"width\":1024,\"height\":576,\"caption\":\"How to install PostgreSQL on Ubuntu 26.04\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-ubuntu-26-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 26.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 26.04 | RoseHosting","description":"Learn how to install PostgreSQL on Ubuntu 26.04 effortlessly. Get started with this powerful database management system.","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-26-04\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL on Ubuntu 26.04","og_description":"How to Install PostgreSQL on Ubuntu 26.04 | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2026-03-11T17:30:00+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04.webp","type":"image\/webp"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_creator":"@rosehosting","twitter_site":"@rosehosting","twitter_misc":{"Written by":"Jeff Wilson","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install PostgreSQL on Ubuntu 26.04","datePublished":"2026-03-11T17:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/"},"wordCount":844,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04.webp","keywords":["how to install","PostgreSQL","ubuntu 26.04"],"articleSection":["Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/","name":"How to Install PostgreSQL on Ubuntu 26.04 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04.webp","datePublished":"2026-03-11T17:30:00+00:00","description":"Learn how to install PostgreSQL on Ubuntu 26.04 effortlessly. Get started with this powerful database management system.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-04\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04.webp","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2026\/03\/how-to-install-postgresql-on-ubuntu-26.04.webp","width":1024,"height":576,"caption":"How to install PostgreSQL on Ubuntu 26.04"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-ubuntu-26-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 26.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\/51534","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=51534"}],"version-history":[{"count":6,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/51534\/revisions"}],"predecessor-version":[{"id":51631,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/51534\/revisions\/51631"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/51629"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=51534"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=51534"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=51534"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}