{"id":3483,"date":"2018-10-01T13:43:11","date_gmt":"2018-10-01T13:43:11","guid":{"rendered":"https:\/\/dbtut.com\/?p=3483"},"modified":"2018-11-24T21:12:45","modified_gmt":"2018-11-24T21:12:45","slug":"how-to-install-postgresql-9-6-on-debian-8-x-jessie","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/","title":{"rendered":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)"},"content":{"rendered":"<p>&nbsp;<\/p>\n<p>As you know, at the end of September 2016, PostgreSQL version 9.6 was released.<\/p>\n<p>In this article you will find the installation steps of PostgreSQL 9.6 on a minimal Debian 8.x (Jessie).<\/p>\n<p>In addition, we will create a database with Turkish support. You can configure it to support your own language.<\/p>\n<p>Since PostgreSQL supports UTF-8, you can store characters in any language in the database.<\/p>\n<p>However, some special situations may occur according to languages.<\/p>\n<p>For example, The upper case of the \u201di\u201c in Turkish is \u201d\u0130\u201d and the upper case of the &#8220;i&#8221; in English is &#8220;I&#8221;.<\/p>\n<p>This means that the output of the various functions will be different according to the language. In PostgreSQL, these settings are made when creating a database. (different language support can be used in the same database, but I won&#8217;t go into this detail)<\/p>\n<p>&nbsp;<\/p>\n<h2>Precondition<\/h2>\n<p>This article begins by assuming that a minimal Jessie installation with ssh support is performed and you have root privileges.<\/p>\n<p>In addition, a shell editor such as vim \/ nano should be available. I&#8217;ll use vim in the article.<\/p>\n<p>&nbsp;<\/p>\n<h2>Installation<\/h2>\n<h3>Debian Language settings<\/h3>\n<p>First, let&#8217;s check whether the default locale of our operating system and Turkish locale are installed or not.<\/p>\n<p>If you do not have Turkish locale, let&#8217;s install it. To check the default locale;<\/p>\n<pre class=\"lang:default decode:true \">root@JESSIE:\/home\/sahap# echo $LANG\r\nen_US.UTF-8<\/pre>\n<p>&nbsp;<\/p>\n<p>Our default language is en_US.UTF-8 We note this and continue with the following command.<\/p>\n<pre class=\"lang:default decode:true \">dpkg-reconfigure locales<\/pre>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s make sure that &#8220;[*] tr_TR.UTF-8 UTF-8&#8221; is selected (you can select it with space) and press &lt;OK&gt; (you can switch to Tab).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png\" width=\"620\" height=\"403\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We&#8217;ve already looked at what was the default locale. We continue our way of choosing it. The purpose of this is to keep the language settings of the services that are already running. In our case this was en_US.UTF-8<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/827.png\" width=\"636\" height=\"414\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>When you press &lt;OK&gt;, the result should be as follows. Thus, we are sure that there is Turkish language support in our operating system.<\/p>\n<pre class=\"lang:default decode:true \">root@JESSIE:\/home\/sahap# dpkg-reconfigure locales\r\nGenerating locales (this might take a while)...\r\n\u00a0 en_US.UTF-8... done\r\n\u00a0 tr_TR.UTF-8... done\r\nGeneration complete.<\/pre>\n<p>&nbsp;<\/p>\n<h2>PostgreSQL Installion:<\/h2>\n<p>We already have PostgreSQL packages in Debian, but because we want to install a higher version of PostgreSQL, we use PostgreSQL&#8217;s own repository.<\/p>\n<p>In our case, Jessie comes with version 9.4 of PostgreSQL but we want to install version 9.6.<\/p>\n<p>Let&#8217;s add our repository;<\/p>\n<pre class=\"lang:default decode:true \">vim \/etc\/apt\/sources.list.d\/pgdg.list<\/pre>\n<p>&nbsp;<\/p>\n<p>Then we write the following line into the document. This way, Jessie also checks the URL we provide when searching for available packages.<\/p>\n<pre class=\"lang:default decode:true \">deb http:\/\/apt.postgresql.org\/pub\/repos\/apt\/ jessie-pgdg main<\/pre>\n<p>&nbsp;<\/p>\n<p>Save and exit;<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/843.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We add the key of Repository to reliable keys.<\/p>\n<pre class=\"lang:default decode:true \">wget --quiet -O - https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | apt-key add -<\/pre>\n<p>&nbsp;<\/p>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/336.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We are updating the package list;<\/p>\n<pre class=\"lang:default decode:true \">apt-get update<\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/302.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s install PostgreSQL; Let&#8217;s continue by saying &#8216;Y&#8217; to the question;<\/p>\n<pre class=\"lang:default decode:true \">apt-get install postgresql-9.6<\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/740.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>The following information gives us information about where our data files are located.<\/p>\n<pre class=\"lang:default decode:true \">Creating new cluster 9.6\/main ...\r\n\u00a0 config \/etc\/postgresql\/9.6\/main\r\n\u00a0 data\u00a0\u00a0 \/var\/lib\/postgresql\/9.6\/main\r\n\u00a0 locale en_US.UTF-8\r\n\u00a0 socket \/var\/run\/postgresql\r\n\u00a0 port\u00a0\u00a0 5432<\/pre>\n<p>&nbsp;<\/p>\n<p>Our configuration files are in &#8220;\/etc\/postgresql\/9.6\/main&#8221; and our data files are in &#8220;\/var\/lib\/postgresql\/9.6\/main&#8221;.<\/p>\n<p>These are the default settings and can be changed as desired. We&#8217;re not going into that detail for now.<\/p>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s check that our PostgreSQL service is running;<\/p>\n<pre class=\"lang:default decode:true \">systemctl status postgresql<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/512.png\" width=\"671\" height=\"183\" \/><\/p>\n<p>&nbsp;<\/p>\n<h2>How To Create a Database With Turkish Language?(or your own language)<\/h2>\n<p>We have installed PostgreSQL. Now we can create the database into it.<\/p>\n<p>Because our operating system&#8217;s default locale is en_US.UTF-8, PostgreSQL has created a cluster in the default language.<\/p>\n<p>If we create a new database without providing a parameter, the database will be created according to the default locale (en_US.UTF-8 locale).<\/p>\n<p>If our default language in our operating system was tr_TR.UTF-8, then it wasn&#8217;t necessary.<\/p>\n<p>Because most operating systems are in English, we need to check them.<\/p>\n<p>Let&#8217;s log into PostgreSQL;<\/p>\n<p>There are several ways. One of them is to log in with the postgres user created during the installation. First we switch to the postgres user. then connect to the database using psql.<\/p>\n<pre class=\"lang:default decode:true \">su postgres\r\npsql<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/257.png\" width=\"671\" height=\"183\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Lets create the database;<\/p>\n<pre class=\"lang:default decode:true \">CREATE DATABASE testdb WITH\r\n\u00a0 TEMPLATE = template0\r\n\u00a0 ENCODING = 'UTF8'\r\n\u00a0 LC_COLLATE = 'tr_TR.UTF-8'\r\n\u00a0 LC_CTYPE = 'tr_TR.UTF-8';<\/pre>\n<p><img decoding=\"async\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/371.png\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You can connect to the newly created database by using the command &#8220;\\ c testdb&#8221;.<\/p>\n<pre class=\"lang:default decode:true \">postgres=# \\c testdb\r\nYou are now connected to database \"testdb\" as user \"postgres\".\r\ntestdb=#<\/pre>\n<p>&nbsp;<\/p>\n<p>Let&#8217;s test the Turkish characters and their order;<\/p>\n<pre class=\"lang:default decode:true \">SELECT\r\n\u00a0 harf, upper(harf)\r\nFROM (\r\nVALUES ('\u015f'), ('t'), ('u'), ('a'), ('n'), ('o'), ('\u00f6'), ('p'), ('f'), ('g'), ('\u011f'), ('h'), ('\u0131'), ('i'), ('j'\r\n\u00a0 ), ('k'), ('l'), ('m'), ('\u00fc'), ('v'), ('r'), ('s'), ('b'), ('c'), ('\u00e7'), ('d'), ('e'), ('y'), ('z')) AS\r\n\u00a0 alfabe(harf)\r\nORDER BY 1;<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"\" src=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/546.png\" width=\"624\" height=\"518\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Our Turkish database is ready.\u00a0 You can create a database that supports your own language by making minor changes.<\/p>\n<p>We have not yet made the necessary settings to access the postgreSQL server from another computer. We only access it from the computer where it is installed. In another article, we will go into details about access.<\/p>\n\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3483\" class=\"pvc_stats all  \" data-element-id=\"3483\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>&nbsp; As you know, at the end of September 2016, PostgreSQL version 9.6 was released. In this article you will find the installation steps of PostgreSQL 9.6 on a minimal Debian 8.x (Jessie). In addition, we will create a database with Turkish support. You can configure it to support your own language. Since PostgreSQL supports &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_3483\" class=\"pvc_stats all  \" data-element-id=\"3483\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":384,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-3483","post","type-post","status-publish","format-standard","","category-postgres"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":563,"today_views":1},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How To Install PostgreSQL 9.6 on Debian 8.x (Jessie) - Database Tutorials<\/title>\n<meta name=\"description\" content=\"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/\" \/>\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 9.6 on Debian 8.x (Jessie) - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2018-10-01T13:43:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-11-24T21:12:45+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png\" \/>\n<meta name=\"author\" content=\"\u015eahap A\u015f\u00e7\u0131\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u015eahap A\u015f\u00e7\u0131\" \/>\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:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/\"},\"author\":{\"name\":\"\u015eahap A\u015f\u00e7\u0131\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a2e613d6be4a3553f844a52366dc0888\"},\"headline\":\"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)\",\"datePublished\":\"2018-10-01T13:43:11+00:00\",\"dateModified\":\"2018-11-24T21:12:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/\"},\"wordCount\":722,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/\",\"name\":\"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie) - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png\",\"datePublished\":\"2018-10-01T13:43:11+00:00\",\"dateModified\":\"2018-11-24T21:12:45+00:00\",\"description\":\"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#primaryimage\",\"url\":\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png\",\"contentUrl\":\"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a2e613d6be4a3553f844a52366dc0888\",\"name\":\"\u015eahap A\u015f\u00e7\u0131\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/005a983c36f6cca1fef1bc16f5d9d1d3f2fd7a27692b5d2c362b0b806bcfdb4a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/005a983c36f6cca1fef1bc16f5d9d1d3f2fd7a27692b5d2c362b0b806bcfdb4a?s=96&d=mm&r=g\",\"caption\":\"\u015eahap A\u015f\u00e7\u0131\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/sahapasci\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie) - Database Tutorials","description":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)","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:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/","og_locale":"en_US","og_type":"article","og_title":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie) - Database Tutorials","og_description":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)","og_url":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/","og_site_name":"Database Tutorials","article_published_time":"2018-10-01T13:43:11+00:00","article_modified_time":"2018-11-24T21:12:45+00:00","og_image":[{"url":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png","type":"","width":"","height":""}],"author":"\u015eahap A\u015f\u00e7\u0131","twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u015eahap A\u015f\u00e7\u0131","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/"},"author":{"name":"\u015eahap A\u015f\u00e7\u0131","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a2e613d6be4a3553f844a52366dc0888"},"headline":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)","datePublished":"2018-10-01T13:43:11+00:00","dateModified":"2018-11-24T21:12:45+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/"},"wordCount":722,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#primaryimage"},"thumbnailUrl":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/","url":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/","name":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie) - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#primaryimage"},"thumbnailUrl":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png","datePublished":"2018-10-01T13:43:11+00:00","dateModified":"2018-11-24T21:12:45+00:00","description":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#primaryimage","url":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png","contentUrl":"http:\/\/www.veritabani.gen.tr\/wp-content\/uploads\/2017\/01\/141.png"},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2018\/10\/01\/how-to-install-postgresql-9-6-on-debian-8-x-jessie\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"How To Install PostgreSQL 9.6 on Debian 8.x (Jessie)"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a2e613d6be4a3553f844a52366dc0888","name":"\u015eahap A\u015f\u00e7\u0131","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/005a983c36f6cca1fef1bc16f5d9d1d3f2fd7a27692b5d2c362b0b806bcfdb4a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/005a983c36f6cca1fef1bc16f5d9d1d3f2fd7a27692b5d2c362b0b806bcfdb4a?s=96&d=mm&r=g","caption":"\u015eahap A\u015f\u00e7\u0131"},"url":"https:\/\/dbtut.com\/index.php\/author\/sahapasci\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/384"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=3483"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/3483\/revisions"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=3483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=3483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=3483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}