{"id":2711,"date":"2023-02-02T13:01:11","date_gmt":"2023-02-02T07:31:11","guid":{"rendered":"https:\/\/trysiteprice.com\/blog\/?p=2711"},"modified":"2023-02-02T13:01:11","modified_gmt":"2023-02-02T07:31:11","slug":"how-to-install-and-setup-postgresql-9-6-on-debian-linux-9","status":"publish","type":"post","link":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/","title":{"rendered":"How To install and setup PostgreSQL 9.6 on Debian Linux 9"},"content":{"rendered":"<p>To install and setup PostgreSQL 9.6 on Debian 9, follow these steps:<\/p>\n<ol>\n<li>Update the package index:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-sql\">sudo apt<span class=\"hljs-operator\">-<\/span><span class=\"hljs-keyword\">get<\/span> <span class=\"hljs-keyword\">update<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<ol start=\"2\">\n<li>Install the PostgreSQL 9.6 package:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-csharp\">sudo apt-<span class=\"hljs-keyword\">get<\/span> install postgresql<span class=\"hljs-number\">-9.6<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<ol start=\"3\">\n<li>Start the PostgreSQL service and enable it to start at boot:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-bash\">sudo systemctl start postgresql<br \/>\nsudo systemctl <span class=\"hljs-built_in\">enable<\/span> postgresql<br \/>\n<\/code><\/div>\n<\/div>\n<ol start=\"4\">\n<li>Change the default PostgreSQL user password:<\/li>\n<\/ol>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs language-python\">sudo -u postgres psql -c <span class=\"hljs-string\">\"ALTER USER postgres WITH PASSWORD 'new_password';\"<\/span><br \/>\n<\/code><\/div>\n<\/div>\n<p>Once the installation is complete, you can connect to the PostgreSQL server using the <code>psql<\/code> command-line client. For example, to connect as the <code>postgres<\/code> user, use the following command:<\/p>\n<div class=\"bg-black mb-4 rounded-md\">\n<div class=\"flex items-center relative text-gray-200 bg-gray-800 px-4 py-2 text-xs font-sans\"><\/div>\n<div class=\"p-4 overflow-y-auto\"><code class=\"!whitespace-pre hljs\">sudo -u postgres psql<br \/>\n<\/code><\/div>\n<\/div>\n<p>Note: Before installing PostgreSQL, make sure that your system has the required resources (e.g. memory, disk space, etc.) to handle the PostgreSQL service. Additionally, you may need to modify the firewall rules to allow incoming connections to the PostgreSQL server.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>To install and setup PostgreSQL 9.6 on Debian 9, follow these steps: Update the package index: sudo apt-get update Install the PostgreSQL 9.6 package: sudo apt-get install postgresql-9.6 Start the PostgreSQL service and enable it to start at boot: sudo systemctl start postgresql sudo systemctl enable postgresql Change the default PostgreSQL user password: sudo -u &#8230; <a title=\"How To install and setup PostgreSQL 9.6 on Debian Linux 9\" class=\"read-more\" href=\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/\" aria-label=\"Read more about How To install and setup PostgreSQL 9.6 on Debian Linux 9\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-2711","post","type-post","status-publish","format-standard","hentry","category-best-tutorial"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v23.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To install and setup PostgreSQL 9.6 on Debian Linux 9 - TrySitePrice<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How To install and setup PostgreSQL 9.6 on Debian Linux 9 - TrySitePrice\" \/>\n<meta property=\"og:description\" content=\"To install and setup PostgreSQL 9.6 on Debian 9, follow these steps: Update the package index: sudo apt-get update Install the PostgreSQL 9.6 package: sudo apt-get install postgresql-9.6 Start the PostgreSQL service and enable it to start at boot: sudo systemctl start postgresql sudo systemctl enable postgresql Change the default PostgreSQL user password: sudo -u ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/\" \/>\n<meta property=\"og:site_name\" content=\"TrySitePrice\" \/>\n<meta property=\"article:published_time\" content=\"2023-02-02T07:31:11+00:00\" \/>\n<meta name=\"author\" content=\"Rahul Sahu\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/\"},\"author\":{\"name\":\"Rahul Sahu\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\"},\"headline\":\"How To install and setup PostgreSQL 9.6 on Debian Linux 9\",\"datePublished\":\"2023-02-02T07:31:11+00:00\",\"dateModified\":\"2023-02-02T07:31:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/\"},\"wordCount\":112,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"articleSection\":[\"Best\/Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/\",\"name\":\"How To install and setup PostgreSQL 9.6 on Debian Linux 9 - TrySitePrice\",\"isPartOf\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\"},\"datePublished\":\"2023-02-02T07:31:11+00:00\",\"dateModified\":\"2023-02-02T07:31:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/trysiteprice.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To install and setup PostgreSQL 9.6 on Debian Linux 9\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#website\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"name\":\"TrySitePrice\",\"description\":\"Free Website Value Calculator Tool\",\"publisher\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#organization\",\"name\":\"TrySitePrice\",\"url\":\"https:\/\/trysiteprice.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"contentUrl\":\"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png\",\"width\":395,\"height\":268,\"caption\":\"TrySitePrice\"},\"image\":{\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4\",\"name\":\"Rahul Sahu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g\",\"caption\":\"Rahul Sahu\"},\"sameAs\":[\"https:\/\/trysiteprice.com\/blog\"],\"url\":\"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To install and setup PostgreSQL 9.6 on Debian Linux 9 - TrySitePrice","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:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/","og_locale":"en_US","og_type":"article","og_title":"How To install and setup PostgreSQL 9.6 on Debian Linux 9 - TrySitePrice","og_description":"To install and setup PostgreSQL 9.6 on Debian 9, follow these steps: Update the package index: sudo apt-get update Install the PostgreSQL 9.6 package: sudo apt-get install postgresql-9.6 Start the PostgreSQL service and enable it to start at boot: sudo systemctl start postgresql sudo systemctl enable postgresql Change the default PostgreSQL user password: sudo -u ... Read more","og_url":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/","og_site_name":"TrySitePrice","article_published_time":"2023-02-02T07:31:11+00:00","author":"Rahul Sahu","twitter_card":"summary_large_image","schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/#article","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/"},"author":{"name":"Rahul Sahu","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4"},"headline":"How To install and setup PostgreSQL 9.6 on Debian Linux 9","datePublished":"2023-02-02T07:31:11+00:00","dateModified":"2023-02-02T07:31:11+00:00","mainEntityOfPage":{"@id":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/"},"wordCount":112,"commentCount":0,"publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"articleSection":["Best\/Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/","url":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/","name":"How To install and setup PostgreSQL 9.6 on Debian Linux 9 - TrySitePrice","isPartOf":{"@id":"https:\/\/trysiteprice.com\/blog\/#website"},"datePublished":"2023-02-02T07:31:11+00:00","dateModified":"2023-02-02T07:31:11+00:00","breadcrumb":{"@id":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/trysiteprice.com\/blog\/how-to-install-and-setup-postgresql-9-6-on-debian-linux-9\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/trysiteprice.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How To install and setup PostgreSQL 9.6 on Debian Linux 9"}]},{"@type":"WebSite","@id":"https:\/\/trysiteprice.com\/blog\/#website","url":"https:\/\/trysiteprice.com\/blog\/","name":"TrySitePrice","description":"Free Website Value Calculator Tool","publisher":{"@id":"https:\/\/trysiteprice.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/trysiteprice.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/trysiteprice.com\/blog\/#organization","name":"TrySitePrice","url":"https:\/\/trysiteprice.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","contentUrl":"https:\/\/trysiteprice.com\/blog\/wp-content\/uploads\/2021\/12\/cropped-trysiteprice-logo.png","width":395,"height":268,"caption":"TrySitePrice"},"image":{"@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/358e04eeea4281deacad2f30c58e67f4","name":"Rahul Sahu","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/trysiteprice.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/51f0f95f7b95665f62baed2211572165?s=96&d=mm&r=g","caption":"Rahul Sahu"},"sameAs":["https:\/\/trysiteprice.com\/blog"],"url":"https:\/\/trysiteprice.com\/blog\/author\/rsahu4242_trysiteprice\/"}]}},"_links":{"self":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/2711","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/comments?post=2711"}],"version-history":[{"count":1,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/2711\/revisions"}],"predecessor-version":[{"id":2712,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/posts\/2711\/revisions\/2712"}],"wp:attachment":[{"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/media?parent=2711"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/categories?post=2711"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trysiteprice.com\/blog\/wp-json\/wp\/v2\/tags?post=2711"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}