{"id":50435,"date":"2025-06-23T12:30:00","date_gmt":"2025-06-23T17:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=50435"},"modified":"2025-06-27T07:51:46","modified_gmt":"2025-06-27T12:51:46","slug":"how-to-install-postgresql-on-debian-13","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/","title":{"rendered":"How to Install PostgreSQL on Debian 13"},"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\/2025\/05\/How-to-install-postgresql-on-debian-13.webp\" alt=\"How to Install PostgreSQL on Debian 13\" class=\"wp-image-50447\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13.webp 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13-300x169.webp 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13-150x84.webp 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13-768x432.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>This blog post will show you how to install PostgreSQL on Debian 13 OS. PostgreSQL, or Postgres, is a free and open-source relational database management system (RDBMS) for storing data. It is also supported on operating systems such as Windows, macOS, OpenBSD, and Linux. PostgreSQL offers many features, such as consistency, isolation, durability, and atomicity. This tutorial will cover the installation, service management, and some basic PostgreSQL commands in the Postgres terminal.<\/p>\n\n\n\n<p>Installing PostgreSQL is a straightforward procedure that takes a few minutes. Let&#8217;s get started!<\/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-69ec019679ab2\" 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-69ec019679ab2\"  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-debian-13\/#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-debian-13\/#Update-the-system\" >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-debian-13\/#Install-the-PostgreSQL-database-server\" >Install the PostgreSQL database server<\/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-debian-13\/#Manage-the-PostgreSQL-service\" >Manage the PostgreSQL service<\/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-debian-13\/#PostgreSQL-Commands\" >PostgreSQL Commands<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><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>A <a href=\"https:\/\/www.rosehosting.com\/debian-vps-hosting\/\" target=\"_blank\" rel=\"noreferrer noopener\">server running Debian<\/a> 13 OS<\/li>\n\n\n\n<li>User privileges: root or non-root user with sudo privileges<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Update-the-system\"><\/span>Update the system<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Before installing PostgreSQL, we will update the packages to the latest available versions. To do that, execute the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo apt update -y &amp;&amp; sudo apt upgrade -y<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Install-the-PostgreSQL-database-server\"><\/span>Install the PostgreSQL database server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>The PostgreSQL package is already added to the repository of Debian 13. To install PostgreSQL, execute the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo apt install postgresql -y<\/pre>\n\n\n\n<p>Once installed, check the PostgreSQL version with the command below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">psql --version<\/pre>\n\n\n\n<p>You should receive output similar to this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">root@host:~# psql --version\npsql (PostgreSQL) 17.4 (Debian 17.4-2)\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Manage-the-PostgreSQL-service\"><\/span>Manage the PostgreSQL service<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To start and enable the PostgreSQL service for an automatic start after the system boot, execute the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl start postgresql &amp;&amp; sudo systemctl enable postgresql<\/pre>\n\n\n\n<p>Once the service is enabled, you should see the following output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Synchronizing state of postgresql.service with SysV service script with \/usr\/lib\/systemd\/systemd-sysv-install.\nExecuting: \/usr\/lib\/systemd\/systemd-sysv-install enable postgresql\n<\/pre>\n\n\n\n<p>To check the status of the PostgreSQL service, you can use the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl status postgresql<\/pre>\n\n\n\n<p>You should get output similar to this:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">root@host:~# 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 2025-05-02 17:51:53 CDT; 19s ago\n Invocation: 9bbafb1bbbd4445f904e054e010fee8c\n   Main PID: 32969 (code=exited, status=0\/SUCCESS)\n   Mem peak: 1.5M\n        CPU: 20ms\n\nMay 02 17:51:53 host.test.vps systemd[1]: Starting postgresql.service - PostgreSQL RDBMS...\nMay 02 17:51:53 host.test.vps systemd[1]: Finished postgresql.service - PostgreSQL RDBMS.\n<\/pre>\n\n\n\n<p>The PostgreSQL service can be restarted with the command below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl restart postgresql<\/pre>\n\n\n\n<p>To stop the PostgreSQL service, you can use the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo systemctl stop postgresql<\/pre>\n\n\n\n<p>That&#8217;s all for managing the PostgreSQL service. In the following paragraph, you will learn some basic PostgreSQL commands.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"PostgreSQL-Commands\"><\/span>PostgreSQL Commands<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>To log in to the PostgreSQL command line with the main &#8220;postgres&#8221; user, execute the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">sudo -u postgres psql<\/pre>\n\n\n\n<p>Once logged in, you will be redirected to the PostgreSQL terminal:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">root@host:~# sudo -u postgres psql\npsql (17.4 (Debian 17.4-2))\nType \"help\" for help.\n\npostgres=#\n<\/pre>\n\n\n\n<p>Once logged in, you can start to use the PostgreSQL commands. For example, to list the databases, you can use the <strong>\\l<\/strong> command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">postgres=# <strong>\\l<\/strong>\n                                                     List of databases\n   Name    |  Owner   | Encoding | Locale Provider |   Collate   |    Ctype    | Locale | ICU Rules |   Access privileges\n-----------+----------+----------+-----------------+-------------+-------------+--------+-----------+-----------------------\n postgres  | postgres | UTF8     | libc            | en_US.UTF-8 | en_US.UTF-8 |        |           |\n template0 | postgres | UTF8     | libc            | en_US.UTF-8 | en_US.UTF-8 |        |           | =c\/postgres          +\n           |          |          |                 |             |             |        |           | postgres=CTc\/postgres\n template1 | postgres | UTF8     | libc            | en_US.UTF-8 | en_US.UTF-8 |        |           | =c\/postgres          +\n           |          |          |                 |             |             |        |           | postgres=CTc\/postgres\n(3 rows)\n\npostgres=#\n\n<\/pre>\n\n\n\n<p>To create a new database, execute the command below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">create database rhdb;<\/pre>\n\n\n\n<p>If the database is successfully created, you will get the following output:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">postgres=# create database rhdb;\n<strong>CREATE DATABASE<\/strong>\n<\/pre>\n\n\n\n<p>To create the user and set a password for that user, execute the command below:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">CREATE USER rhuser WITH PASSWORD 'StrongPasswordHere';\n<\/pre>\n\n\n\n<p>After successful creation, you will receive the following:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">postgres=# CREATE USER rhtest WITH PASSWORD 'StrongPasswordHere';\n<strong>CREATE ROLE<\/strong>\n<\/pre>\n\n\n\n<p>To grant permissions on the database for the user, you can use the following command:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">grant all privileges on database rhdb to rhuser;<\/pre>\n\n\n\n<p>After successfully granting permissions, you will receive the following:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">postgres=# grant all privileges on database rhdb to rhuser;\n<strong>GRANT<\/strong>\n<\/pre>\n\n\n\n<p>That\u2019s it. You successfully installed PostgreSQL on Debian 13 OS. Of course, you do not have to install it yourself if you are unfamiliar with databases and Linux. You can always contact our technical support, which will help you with any PostgreSQL installation and configuration aspect. You just need to sign up for one of our NVMe <a href=\"https:\/\/www.rosehosting.com\/linux-vps-hosting\/\" target=\"_blank\" rel=\"noreferrer noopener\">VPS hosting plans<\/a> and submit a support ticket. We are available 24\/7.<\/p>\n\n\n\n<p>PS. If you liked this post on installing PostgreSQL on Debian 13, please share it with your friends or leave a comment below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This blog post will show you how to install PostgreSQL on Debian 13 OS. PostgreSQL, or Postgres, is a free &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install PostgreSQL on Debian 13\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#more-50435\" aria-label=\"Read more about How to Install PostgreSQL on Debian 13\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":50447,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1700],"tags":[2265,1603,434],"class_list":["post-50435","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-debian","tag-debian-13","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.4 (Yoast SEO v27.4) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Install PostgreSQL on Debian 13 | RoseHosting<\/title>\n<meta name=\"description\" content=\"Learn how to install PostgreSQL on Debian 13 using our latest easy-to-follow guide or have our Linux admins install it for you.\" \/>\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-debian-13\/\" \/>\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 Debian 13\" \/>\n<meta property=\"og:description\" content=\"How to Install PostgreSQL on Debian 13 | RoseHosting\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/\" \/>\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=\"2025-06-23T17:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-06-27T12:51:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13.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=\"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-debian-13\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install PostgreSQL on Debian 13\",\"datePublished\":\"2025-06-23T17:30:00+00:00\",\"dateModified\":\"2025-06-27T12:51:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/\"},\"wordCount\":477,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/How-to-install-postgresql-on-debian-13.webp\",\"keywords\":[\"debian 13\",\"how to install\",\"PostgreSQL\"],\"articleSection\":[\"Debian\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/\",\"name\":\"How to Install PostgreSQL on Debian 13 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/How-to-install-postgresql-on-debian-13.webp\",\"datePublished\":\"2025-06-23T17:30:00+00:00\",\"dateModified\":\"2025-06-27T12:51:46+00:00\",\"description\":\"Learn how to install PostgreSQL on Debian 13 using our latest easy-to-follow guide or have our Linux admins install it for you.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/How-to-install-postgresql-on-debian-13.webp\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/How-to-install-postgresql-on-debian-13.webp\",\"width\":1024,\"height\":576,\"caption\":\"How to Install PostgreSQL on Debian 13\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-postgresql-on-debian-13\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Install PostgreSQL on Debian 13\"}]},{\"@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 Debian 13 | RoseHosting","description":"Learn how to install PostgreSQL on Debian 13 using our latest easy-to-follow guide or have our Linux admins install it for you.","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-debian-13\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PostgreSQL on Debian 13","og_description":"How to Install PostgreSQL on Debian 13 | RoseHosting","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/","og_site_name":"RoseHosting","article_publisher":"https:\/\/www.facebook.com\/RoseHosting","article_author":"https:\/\/www.facebook.com\/rosehosting.helpdesk","article_published_time":"2025-06-23T17:30:00+00:00","article_modified_time":"2025-06-27T12:51:46+00:00","og_image":[{"width":1024,"height":576,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13.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":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install PostgreSQL on Debian 13","datePublished":"2025-06-23T17:30:00+00:00","dateModified":"2025-06-27T12:51:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/"},"wordCount":477,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13.webp","keywords":["debian 13","how to install","PostgreSQL"],"articleSection":["Debian"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/","name":"How to Install PostgreSQL on Debian 13 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13.webp","datePublished":"2025-06-23T17:30:00+00:00","dateModified":"2025-06-27T12:51:46+00:00","description":"Learn how to install PostgreSQL on Debian 13 using our latest easy-to-follow guide or have our Linux admins install it for you.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13.webp","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2025\/05\/How-to-install-postgresql-on-debian-13.webp","width":1024,"height":576,"caption":"How to Install PostgreSQL on Debian 13"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-postgresql-on-debian-13\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.rosehosting.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to Install PostgreSQL on Debian 13"}]},{"@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\/50435","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=50435"}],"version-history":[{"count":3,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/50435\/revisions"}],"predecessor-version":[{"id":50448,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/50435\/revisions\/50448"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/50447"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=50435"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=50435"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=50435"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}