{"id":44033,"date":"2023-01-02T12:30:02","date_gmt":"2023-01-02T18:30:02","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=44033"},"modified":"2022-12-30T07:52:01","modified_gmt":"2022-12-30T13:52:01","slug":"how-to-install-postgresql-15-on-debian-11","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/","title":{"rendered":"How to Install PostgreSQL 15 on Debian 11"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div><p><img decoding=\"async\" class=\"size-full wp-image-44501 alignnone\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11.webp\" alt=\"install postgresql on debian 11\" width=\"742\" height=\"372\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11.webp 742w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11-300x150.webp 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11-150x75.webp 150w\" sizes=\"(max-width: 742px) 100vw, 742px\" \/><\/p>\n<p>In this tutorial, we will explain in detail how to install PostgreSQL 15 on Debian 11 OS.<\/p>\n<p>PostgreSQL or Postgres is a free and open-source relational <a href=\"https:\/\/www.rosehosting.com\/blog\/mysql-vs-sqlite-vs-postgresql\/\">database management system<\/a> used worldwide in thousands of applications by thousands of database administrators and developers. PostgreSQL database management system is written in C and C++ and can handle multiple tasks at the same time. There is a number of database types offered by Postgres such as integer, big integer, date, interval and etc. In this blog post, except for the installation, we will explain logging into Postgres and some useful information about managing the PostgreSQL service.<\/p>\n<p>Installing PostgreSQL 15 on <a href=\"https:\/\/www.rosehosting.com\/debian-hosting\/\">Debian<\/a> 11 is a straightforward process and may 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_84 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-6a21b9ba927fd\" 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-6a21b9ba927fd\"  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-15-on-debian-11\/#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-15-on-debian-11\/#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-15-on-debian-11\/#Step-2-Install-Dependencies\" >Step 2. Install Dependencies<\/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-15-on-debian-11\/#Step-3-Add-PostgreSQL-repo-and-Key\" >Step 3. Add PostgreSQL repo and Key<\/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-15-on-debian-11\/#Step-4-Install-PostgreSQL-15\" >Step 4. Install PostgreSQL 15<\/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-15-on-debian-11\/#Step-5-Managing-the-PostgreSQL-service\" >Step 5. Managing the PostgreSQL service<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#Useful-PostgreSQL-information\" >Useful PostgreSQL information<\/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 Debian 11 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>Before we start with the installation of PostgreSQL, we will 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-Dependencies\"><\/span>Step 2. Install Dependencies<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To install the PostgreSQL required dependencies execute the following command:<\/p>\n<pre>sudo apt-get install gnupg2 wget curl -y<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-3-Add-PostgreSQL-repo-and-Key\"><\/span>Step 3. Add PostgreSQL repo and Key<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>In the default Debian repository, the available version of PostgreSQL is version 13. Since we need the latest PostgreSQL 15 we need first to add the repository:<\/p>\n<pre>sh -c 'echo \"deb http:\/\/apt.postgresql.org\/pub\/repos\/apt $(lsb_release -cs)-pgdg main\" &gt; \/etc\/apt\/sources.list.d\/pgdg.list'<\/pre>\n<p>Once the repo is added next is to add the GPG Key:<\/p>\n<pre>wget --quiet -O - https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo apt-key add -<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>root@host:~# sh -c 'echo \"deb http:\/\/apt.postgresql.org\/pub\/repos\/apt $(lsb_release -cs)-pgdg main\" &gt; \/etc\/apt\/sources.list.d\/pgdg.list'\r\nroot@host:~# wget --quiet -O - https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo apt-key add -\r\nOK\r\n<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-4-Install-PostgreSQL-15\"><\/span>Step 4. Install PostgreSQL 15<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Everything is ready for installation, but first, we need to update the packages after the repo and key insertion:<\/p>\n<pre>sudo apt-get update -y<\/pre>\n<p>To install the PostgreSQL 15 version, execute the following command:<\/p>\n<pre>sudo apt-get install postgresql-15 -y<\/pre>\n<h2><span class=\"ez-toc-section\" id=\"Step-5-Managing-the-PostgreSQL-service\"><\/span>Step 5. Managing the PostgreSQL service<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>After installation, you need to start and enable the PostgreSQL service for an automatic start after the system reboot.<\/p>\n<pre>sudo systemctl start postgresql &amp;&amp; sudo systemctl enable postgresql<\/pre>\n<p>To check the status of the service, execute the following command:<\/p>\n<pre>sudo systemctl status postgresql<\/pre>\n<p>You should receive the following output:<\/p>\n<pre>root@vps:~# sudo systemctl status postgresql\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 Sat 2022-12-10 05:20:50 CST; 8min ago\r\n   Main PID: 4191 (code=exited, status=0\/SUCCESS)\r\n      Tasks: 0 (limit: 4678)\r\n     Memory: 0B\r\n        CPU: 0\r\n     CGroup: \/system.slice\/postgresql.service\r\n\r\nDec 10 05:20:50 host.test.vps systemd[1]: Starting PostgreSQL RDBMS...\r\nDec 10 05:20:50 host.test.vps systemd[1]: Finished PostgreSQL RDBMS.\r\n<\/pre>\n<p>Respectively for restarting and stopping the service, you can use the following commands:<\/p>\n<pre>sudo systemctl restart postgresql\r\n\r\nsudo systemctl stop postgresql\r\n<\/pre>\n<p>Good to know is if the service is stopped and you try to restart it, it will start anyway. The restart of the service will act as a start when the service is stopped.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Useful-PostgreSQL-information\"><\/span>Useful PostgreSQL information<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>PostgreSQL is listening on port <b>5432<\/b>, and you can check this with the following command:<\/p>\n<pre>sudo netstat -tunlp | grep 5432<\/pre>\n<p>You will receive output similar to this:<\/p>\n<pre>root@host:~# sudo netstat -tunlp | grep 5432\r\ntcp        0      0 127.0.0.1:5432          0.0.0.0:*               LISTEN      5696\/<b>postgres<\/b>\r\ntcp6       0      0 ::1:5432                :::*                    LISTEN      5696\/<b>postgres<\/b>\r\n<\/pre>\n<p>The command for PostgreSQL login is the following one:<\/p>\n<pre>sudo -u postgres psql<\/pre>\n<p>Once logged in, you will see the Postgres command line:<\/p>\n<pre>root@host:~# sudo -u postgres psql\r\ncould not change directory to \"\/root\": Permission denied\r\npsql (15.1 (Debian 15.1-1.pgdg110+1))\r\nType \"help\" for help.\r\n\r\npostgres=#\r\n<\/pre>\n<p>That&#8217;s it. You successfully installed PostgreSQL 15 on Debian 11 OS. Of course, if you do not know how to install and configure it, you can always contact our technical support, and they will do the rest. You just need to sign up for one of our <a href=\"https:\/\/www.rosehosting.com\/nvme-hosting\/\">NVMe VPS<\/a> hosting plans and submit a support ticket. We are available 24\/7.<\/p>\n<p>PS. If you liked this post on how to install PostgreSQL 15 on Debian 11, please share it with your friends on social networks using the buttons on the left or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, we will explain in detail how to install PostgreSQL 15 on Debian 11 OS. PostgreSQL or Postgres &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install PostgreSQL 15 on Debian 11\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#more-44033\" aria-label=\"Read more about How to Install PostgreSQL 15 on Debian 11\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":44501,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1698],"tags":[1962,1603,434],"class_list":["post-44033","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-ubuntu","tag-debian-11","tag-how-to-install","tag-postgresql","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.7 (Yoast SEO v27.7) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install PostgreSQL 15 on Debian 11 | RoseHosting<\/title>\n<meta name=\"description\" content=\"In this guide, we will help you install PostgreSQL 15 on Debian 11. Keep on reading, and find out more about this topic.\" \/>\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-15-on-debian-11\/\" \/>\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 15 on Debian 11\" \/>\n<meta property=\"og:description\" content=\"In this guide, we will help you install PostgreSQL 15 on Debian 11. Keep on reading, and find out more about this topic.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/\" \/>\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=\"2023-01-02T18:30:02+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11.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 15 on Debian 11\" \/>\n<meta name=\"twitter:description\" content=\"In this guide, we will help you install PostgreSQL 15 on Debian 11. Keep on reading, and find out more about this topic.\" \/>\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-15-on-debian-11\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install PostgreSQL 15 on Debian 11\",\"datePublished\":\"2023-01-02T18:30:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/\"},\"wordCount\":481,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/install-postgresql-on-debian-11.webp\",\"keywords\":[\"debian 11\",\"how to install\",\"PostgreSQL\"],\"articleSection\":[\"Databases\",\"Ubuntu\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/\",\"name\":\"How to Install PostgreSQL 15 on Debian 11 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/install-postgresql-on-debian-11.webp\",\"datePublished\":\"2023-01-02T18:30:02+00:00\",\"description\":\"In this guide, we will help you install PostgreSQL 15 on Debian 11. Keep on reading, and find out more about this topic.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/install-postgresql-on-debian-11.webp\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2022\\\/12\\\/install-postgresql-on-debian-11.webp\",\"width\":742,\"height\":372,\"caption\":\"install postgresql on debian 11\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-15-on-debian-11\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install PostgreSQL 15 on Debian 11\"}]},{\"@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 15 on Debian 11 | RoseHosting","description":"In this guide, we will help you install PostgreSQL 15 on Debian 11. Keep on reading, and find out more about this topic.","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-15-on-debian-11\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL 15 on Debian 11","og_description":"In this guide, we will help you install PostgreSQL 15 on Debian 11. Keep on reading, and find out more about this topic.","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2023-01-02T18:30:02+00:00","og_image":[{"width":742,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11.webp","type":"image\/webp"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_title":"How to Install PostgreSQL 15 on Debian 11","twitter_description":"In this guide, we will help you install PostgreSQL 15 on Debian 11. Keep on reading, and find out more about this topic.","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-15-on-debian-11\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install PostgreSQL 15 on Debian 11","datePublished":"2023-01-02T18:30:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/"},"wordCount":481,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11.webp","keywords":["debian 11","how to install","PostgreSQL"],"articleSection":["Databases","Ubuntu"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/","name":"How to Install PostgreSQL 15 on Debian 11 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11.webp","datePublished":"2023-01-02T18:30:02+00:00","description":"In this guide, we will help you install PostgreSQL 15 on Debian 11. Keep on reading, and find out more about this topic.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11.webp","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2022\/12\/install-postgresql-on-debian-11.webp","width":742,"height":372,"caption":"install postgresql on debian 11"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-15-on-debian-11\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install PostgreSQL 15 on Debian 11"}]},{"@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\/44033","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=44033"}],"version-history":[{"count":6,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/44033\/revisions"}],"predecessor-version":[{"id":44503,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/44033\/revisions\/44503"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/44501"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=44033"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=44033"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=44033"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}