{"id":46248,"date":"2023-08-21T12:30:00","date_gmt":"2023-08-21T17:30:00","guid":{"rendered":"https:\/\/www.rosehosting.com\/blog\/?p=46248"},"modified":"2023-07-24T11:32:57","modified_gmt":"2023-07-24T16:32:57","slug":"how-to-install-pgadmin-4-on-debian-11","status":"publish","type":"post","link":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/","title":{"rendered":"How to Install PgAdmin 4 on Debian 11"},"content":{"rendered":"<div id=\"bsf_rt_marker\"><\/div>\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" width=\"1024\" height=\"372\" src=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11.webp\" alt=\"how to install pgadmin 4 on debian 11\" class=\"wp-image-46507\" srcset=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11.webp 1024w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11-300x109.webp 300w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11-150x54.webp 150w, https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11-768x279.webp 768w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>pgAdmin is a powerful and feature-rich administration tool with a user-friendly web-based interface. It&#8217;s a <a href=\"https:\/\/www.rosehosting.com\/blog\/mysql-vs-sqlite-vs-postgresql\/\">database management<\/a> tool for one of the most popular open-source RDMB systems, PostgreSQL. <\/p>\n\n\n\n<!--more-->\n\n\n\n<p>pgAdmin is used by new and experienced Postgres users, with pgAdmin features like Query Tool, ERD Tool for designing and documenting schemas, Monitoring dashboard, and <a href=\"https:\/\/www.pgadmin.org\/features\">other features<\/a>. In this tutorial, we will show you how to install pgAdmin 4 on a Debian 11 server.<\/p>\n\n\n\n<p>Prerequisites<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>A Debian 11 VPS<\/li>\n\n\n\n<li>Access to the root user account (or access to an admin account with root privileges)<\/li>\n<\/ul>\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-69ec269e1cae8\" 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-69ec269e1cae8\"  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-pgadmin-4-on-debian-11\/#Step-1-Log-in-to-the-Server-Update-the-Server-OS-Packages\" >Step 1: Log in to the Server &amp; Update the Server OS Packages<\/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-pgadmin-4-on-debian-11\/#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-3\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/#Step-3-Create-a-PostgreSQL-Database-and-User\" >Step 3: Create a PostgreSQL Database and User<\/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-pgadmin-4-on-debian-11\/#Step-4-Install-pgAdmin-4\" >Step 4. Install pgAdmin 4<\/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-pgadmin-4-on-debian-11\/#Step-4-Configure-pgAdmin\" >Step 4. Configure pgAdmin.<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-1-Log-in-to-the-Server-Update-the-Server-OS-Packages\"><\/span>Step 1: Log in to the Server &amp; Update the Server OS Packages<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>First, log in to your Debian 11 server via SSH as the root user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>ssh root@IP_Address -p Port_number<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>apt-get update -y<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><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>Before installing pgAdmin4, the PostgreSQL server must be installed on your server. If not installed, you can install it using the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># apt-get install postgresql<\/code><\/pre>\n\n\n\n<p>You can check if PostgreSQL has been installed and running with the systemctl status command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># systemctl status postgresql\n\u25cf postgresql.service - PostgreSQL RDBMS\nLoaded: loaded (\/lib\/systemd\/system\/postgresql.service; enabled; vendor pr&gt;\nActive: active (exited) since Tue 2023-06-20 15:33:18 CDT; 2min 56s ago\nMain PID: 2786 (code=exited, status=0\/SUCCESS)\nTasks: 0 (limit: 4148)\nMemory: 0B\nCPU: 0\nCGroup: \/system.slice\/postgresql.service<\/code><\/pre>\n\n\n\n<p>You can enable PostgreSQL to start with every system reboot using the command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>systemctl enable postgresql<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-3-Create-a-PostgreSQL-Database-and-User\"><\/span>Step 3: Create a PostgreSQL Database and User<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Next, you can connect to the PostgreSQL shell and create a new database and new user:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code># su - postgres\n# psql<\/code><\/pre>\n\n\n\n<p>Once you are connected, to create a user called dbuser with a given password, you can use the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres= CREATE USER dbuser WITH PASSWORD 'password';<\/code><\/pre>\n\n\n\n<p>Now you can also create a new database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres= CREATE DATABASE pgdb;<\/code><\/pre>\n\n\n\n<p>Next, grant all the privileges to the PostgreSQL database with the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres= GRANT ALL PRIVILEGES ON DATABASE pgdb to pguser;<\/code><\/pre>\n\n\n\n<p>Next, exit from the PostgreSQL shell with the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>postgres= \\q\nexit<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-4-Install-pgAdmin-4\"><\/span>Step 4. Install pgAdmin 4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>By default, pgAdmin4 is not included in the Debian 11 default repository. So you will need to add the pgAdmin4 repository in APT.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>echo \"deb https:\/\/ftp.postgresql.org\/pub\/pgadmin\/pgadmin4\/apt\/bullseye pgadmin4 main\"\\\n| sudo tee \/etc\/apt\/sources.list.d\/pgadmin4.list<\/code><\/pre>\n\n\n\n<p>Import the GPG key of the pgAdmin repository using the following command:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>curl https:\/\/www.pgadmin.org\/static\/packages_pgadmin_org.pub | sudo apt-key add<\/code><\/pre>\n\n\n\n<p>After that, update apt, and you can install pgAdmin using the following commands below:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo apt update\nsudo apt install pgadmin4-web<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Step-4-Configure-pgAdmin\"><\/span>Step 4. Configure pgAdmin.<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Now we set up pgAdmin 4 before accessing it:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sudo \/usr\/pgadmin4\/bin\/setup-web.sh<\/code><\/pre>\n\n\n\n<p>You will be asked to provide your Email and password to finish the configuration as shown below:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Setting up pgAdmin 4 in web mode on a Debian based platform\u2026\nCreating configuration database\u2026\nNOTE: Configuring authentication for SERVER mode.\n\nEnter the email address and password to use for the initial pgAdmin user account:\n\nEmail address: test@test.com\nPassword: your-password\nRetype password: your-passwdord\n\npgAdmin 4 - Application Initialisation\n\nCreating storage and log directories\u2026\nWe can now configure the Apache Web server for you. This involves enabling the wsgi module and configuring the pgAdmin 4 application to mount at \/pgadmin4. Do you wish to continue (y\/n)? y &lt;&lt; Type y and press Enter\nThe Apache web server is running and must be restarted for the pgAdmin 4 installation to complete. Continue (y\/n)? y &lt;&lt; Type y and press Enter\nApache successfully restarted. You can now start using pgAdmin 4 in web mode at http:\/\/127.0.0.1\/pgadmin<\/code><\/pre>\n\n\n\n<p>When the installation is completed, you can open <strong>http:\/\/YOUR-IP-ADDRESS\/pgadmin<\/strong> on your favorite browser and sign in to pgAdmin 4.<\/p>\n\n\n\n<p>Congratulation! You have successfully installed pgAdmin 4 on Debian 11, and now you can start using it, then build and customize it.<\/p>\n\n\n\n<p>If you are one of our web hosting customers and use our <a href=\"https:\/\/www.rosehosting.com\/nvme-hosting\/\">managed Linux Hosting<\/a>, you don\u2019t have to follow this tutorial and install pgAdmin 4 on Debian 11 yourself; our Linux admins will install and configure a pgAdmin 4 on your VPS for you. They are available 24\u00d77 and will take care of your request immediately, and all you need to do is to submit a ticket; you can count on our support team.<\/p>\n\n\n\n<p>PS. If you liked this post, please share it with your friends on social networks or simply leave a reply below. Thanks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>pgAdmin is a powerful and feature-rich administration tool with a user-friendly web-based interface. It&#8217;s a database management tool for one &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"How to Install PgAdmin 4 on Debian 11\" class=\"read-more button\" href=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/#more-46248\" aria-label=\"Read more about How to Install PgAdmin 4 on Debian 11\">Read More<\/a><\/p>\n","protected":false},"author":4,"featured_media":46507,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1702,1700,13],"tags":[48,1896],"class_list":["post-46248","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases","category-debian","category-tutorials","tag-debian","tag-pgadmin","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 PgAdmin 4 on Debian 11 | RoseHosting<\/title>\n<meta name=\"description\" content=\"Master the installation of PgAdmin 4 on Debian 11 with our guide. Simplify database management and optimize your workflow today.\" \/>\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-pgadmin-4-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 PgAdmin 4 on Debian 11\" \/>\n<meta property=\"og:description\" content=\"Master the installation of PgAdmin 4 on Debian 11 with our guide. Simplify database management and optimize your workflow today.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-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-08-21T17:30:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11.webp\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\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 PgAdmin 4 on Debian 11\" \/>\n<meta name=\"twitter:description\" content=\"Master the installation of PgAdmin 4 on Debian 11 with our guide. Simplify database management and optimize your workflow today.\" \/>\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-pgadmin-4-on-debian-11\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/\"},\"author\":{\"name\":\"Jeff Wilson\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#\\\/schema\\\/person\\\/7ce77a842fa6a9a7f8efa186f2353713\"},\"headline\":\"How to Install PgAdmin 4 on Debian 11\",\"datePublished\":\"2023-08-21T17:30:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/\"},\"wordCount\":462,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/how-to-install-pgadmin-4-on-debian-11.webp\",\"keywords\":[\"debian\",\"pgadmin\"],\"articleSection\":[\"Databases\",\"Debian\",\"Tutorials\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/\",\"name\":\"How to Install PgAdmin 4 on Debian 11 | RoseHosting\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/how-to-install-pgadmin-4-on-debian-11.webp\",\"datePublished\":\"2023-08-21T17:30:00+00:00\",\"description\":\"Master the installation of PgAdmin 4 on Debian 11 with our guide. Simplify database management and optimize your workflow today.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-on-debian-11\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/how-to-install-pgadmin-4-on-debian-11.webp\",\"contentUrl\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/wp-content\\\/uploads\\\/2023\\\/07\\\/how-to-install-pgadmin-4-on-debian-11.webp\",\"width\":1024,\"height\":372,\"caption\":\"how to install pgadmin 4 on debian 11\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.rosehosting.com\\\/blog\\\/how-to-install-pgadmin-4-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 PgAdmin 4 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 PgAdmin 4 on Debian 11 | RoseHosting","description":"Master the installation of PgAdmin 4 on Debian 11 with our guide. Simplify database management and optimize your workflow today.","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-pgadmin-4-on-debian-11\/","og_locale":"en_US","og_type":"article","og_title":"How to Install PgAdmin 4 on Debian 11","og_description":"Master the installation of PgAdmin 4 on Debian 11 with our guide. Simplify database management and optimize your workflow today.","og_url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-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-08-21T17:30:00+00:00","og_image":[{"width":1024,"height":372,"url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11.webp","type":"image\/webp"}],"author":"Jeff Wilson","twitter_card":"summary_large_image","twitter_title":"How to Install PgAdmin 4 on Debian 11","twitter_description":"Master the installation of PgAdmin 4 on Debian 11 with our guide. Simplify database management and optimize your workflow today.","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-pgadmin-4-on-debian-11\/#article","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/"},"author":{"name":"Jeff Wilson","@id":"https:\/\/www.rosehosting.com\/blog\/#\/schema\/person\/7ce77a842fa6a9a7f8efa186f2353713"},"headline":"How to Install PgAdmin 4 on Debian 11","datePublished":"2023-08-21T17:30:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/"},"wordCount":462,"commentCount":0,"publisher":{"@id":"https:\/\/www.rosehosting.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11.webp","keywords":["debian","pgadmin"],"articleSection":["Databases","Debian","Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/","url":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/","name":"How to Install PgAdmin 4 on Debian 11 | RoseHosting","isPartOf":{"@id":"https:\/\/www.rosehosting.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/#primaryimage"},"image":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/#primaryimage"},"thumbnailUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11.webp","datePublished":"2023-08-21T17:30:00+00:00","description":"Master the installation of PgAdmin 4 on Debian 11 with our guide. Simplify database management and optimize your workflow today.","breadcrumb":{"@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-on-debian-11\/#primaryimage","url":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11.webp","contentUrl":"https:\/\/www.rosehosting.com\/blog\/wp-content\/uploads\/2023\/07\/how-to-install-pgadmin-4-on-debian-11.webp","width":1024,"height":372,"caption":"how to install pgadmin 4 on debian 11"},{"@type":"BreadcrumbList","@id":"https:\/\/www.rosehosting.com\/blog\/how-to-install-pgadmin-4-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 PgAdmin 4 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\/46248","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=46248"}],"version-history":[{"count":8,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/46248\/revisions"}],"predecessor-version":[{"id":46509,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/posts\/46248\/revisions\/46509"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media\/46507"}],"wp:attachment":[{"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/media?parent=46248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/categories?post=46248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rosehosting.com\/blog\/wp-json\/wp\/v2\/tags?post=46248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}