{"id":53344,"date":"2022-12-15T19:31:21","date_gmt":"2022-12-15T19:31:21","guid":{"rendered":"https:\/\/dbtut.com\/?p=53344"},"modified":"2022-12-15T19:32:00","modified_gmt":"2022-12-15T19:32:00","slug":"postgresql-external-connection","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/","title":{"rendered":"PostgreSQL External Connection"},"content":{"rendered":"<p>In this article, we will be learning the necessary configurations to connect to Postgresql from external.<\/p>\n<p>First, I will talk about two files. postgresql.conf and pg_hba.conf these two files are essential configuration files for postgresql.<\/p>\n<p>Postgresql.conf and pg_hba.conf files are located in the place we specify as the data file when making initdb.<\/p>\n<p>It is located in \/var\/lib\/pgsql\/13 (depending on version)\/data\/\u00a0 if standard installation is done.<\/p>\n<p>First, let&#8217;s briefly talk about postgresql.conf.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/postgresqlconf_1.png\" \/><\/p>\n<p>Postgresql.conf is used to change and adjust parameters such as data directories of postgresql, connection, authentication, wal, replication, query tuning, reporting, logging, statistics, autovacuum, client connections, lock management, config file on a cluster basis.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/postgresqlconf_2.png\" \/><\/p>\n<p>Pg_hba.conf is the config file in which configurations such as connecting from a specific IP or only from a specific IP block to postgresql with or without encryption or hash algorithm are made.<\/p>\n<p>After talking about postgresql.conf and pg_hba.conf in general, let&#8217;s make the necessary configurations.<\/p>\n<p>First, we take the first step to accept all incoming requests by changing the listen_addresses parameter via postgresql.conf as follows.<\/p>\n<p>By deleting the localhost written against Listen addresses, we save and exit by making *.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/postgresqlconf_3.png\" \/><\/p>\n<p>We come to the next step, the pg_hba.conf parameter, and here we change the following parameters.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/postgresqlconf_4.png\" \/><\/p>\n<p>The above changes were made for problem-free connection in the test environment.<\/p>\n<p>In the production environment, instead of trust, scram-sha-256 and 0.0.0.0\/0 should come from which ip block or ip-based permission should be defined.<\/p>\n<p>You need to connect to PostgreSQL as follows and change the postgres password with the help of the following command.<\/p>\n<pre class=\"lang:default decode:true \">alter user  postgres password 'P@sSwOrd1!'\r\n<\/pre>\n<p><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/www.farukerdem.com\/wp-content\/uploads\/2020\/12\/psqlalter.png\" \/><\/p>\n<p id=\"JPrGevN\">After changing the configuration files and the postgres password, we need to restart the postgresql service as follows.<\/p>\n<pre class=\"lang:default decode:true \">systemctl restart postgresql-13.service\r\n<\/pre>\n<p>Note : The service may not start in case of errors or missing spellings in the configurations.<\/p>\n<p>If the firewall is open, you need to turn off the firewall with the help of the command below.<\/p>\n<p>(Those who do not want to turn off the firewall can only define permission for that port over the firewall.)<\/p>\n<pre class=\"lang:default decode:true \">systemctl stop firewalld\r\n<\/pre>\n<p>After restarting the service, it accepts the changes made in postgresql and starts serving again with the parameters we specified, and all connection requests become acceptable.<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_53344\" class=\"pvc_stats all  \" data-element-id=\"53344\" 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>In this article, we will be learning the necessary configurations to connect to Postgresql from external. First, I will talk about two files. postgresql.conf and pg_hba.conf these two files are essential configuration files for postgresql. Postgresql.conf and pg_hba.conf files are located in the place we specify as the data file when making initdb. It is &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_53344\" class=\"pvc_stats all  \" data-element-id=\"53344\" 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":366,"featured_media":53350,"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-53344","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-postgres"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL External Connection - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In this article, we will be learning the necessary configurations to connect to Postgresql from external. postgresql.conf and pg_hba.conf\" \/>\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\/2022\/12\/15\/postgresql-external-connection\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL External Connection - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In this article, we will be learning the necessary configurations to connect to Postgresql from external. postgresql.conf and pg_hba.conf\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-15T19:31:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-15T19:32:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png\" \/>\n\t<meta property=\"og:image:width\" content=\"687\" \/>\n\t<meta property=\"og:image:height\" content=\"293\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Faruk Erdem\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Faruk Erdem\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/\"},\"author\":{\"name\":\"Faruk Erdem\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb\"},\"headline\":\"PostgreSQL External Connection\",\"datePublished\":\"2022-12-15T19:31:21+00:00\",\"dateModified\":\"2022-12-15T19:32:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/\"},\"wordCount\":377,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png\",\"articleSection\":[\"PostgreSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/\",\"name\":\"PostgreSQL External Connection - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png\",\"datePublished\":\"2022-12-15T19:31:21+00:00\",\"dateModified\":\"2022-12-15T19:32:00+00:00\",\"description\":\"In this article, we will be learning the necessary configurations to connect to Postgresql from external. postgresql.conf and pg_hba.conf\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png\",\"width\":687,\"height\":293},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL External Connection\"}]},{\"@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\/a7dfc5684c116e536b4e93ee214ccbfb\",\"name\":\"Faruk Erdem\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g\",\"caption\":\"Faruk Erdem\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"PostgreSQL External Connection - Database Tutorials","description":"In this article, we will be learning the necessary configurations to connect to Postgresql from external. postgresql.conf and pg_hba.conf","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\/2022\/12\/15\/postgresql-external-connection\/","og_locale":"en_US","og_type":"article","og_title":"PostgreSQL External Connection - Database Tutorials","og_description":"In this article, we will be learning the necessary configurations to connect to Postgresql from external. postgresql.conf and pg_hba.conf","og_url":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/","og_site_name":"Database Tutorials","article_published_time":"2022-12-15T19:31:21+00:00","article_modified_time":"2022-12-15T19:32:00+00:00","og_image":[{"width":687,"height":293,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png","type":"image\/png"}],"author":"Faruk Erdem","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Faruk Erdem","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/"},"author":{"name":"Faruk Erdem","@id":"https:\/\/dbtut.com\/#\/schema\/person\/a7dfc5684c116e536b4e93ee214ccbfb"},"headline":"PostgreSQL External Connection","datePublished":"2022-12-15T19:31:21+00:00","dateModified":"2022-12-15T19:32:00+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/"},"wordCount":377,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png","articleSection":["PostgreSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/","url":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/","name":"PostgreSQL External Connection - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png","datePublished":"2022-12-15T19:31:21+00:00","dateModified":"2022-12-15T19:32:00+00:00","description":"In this article, we will be learning the necessary configurations to connect to Postgresql from external. postgresql.conf and pg_hba.conf","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2022\/12\/Ekran-goruntusu-2022-12-15-222114.png","width":687,"height":293},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2022\/12\/15\/postgresql-external-connection\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL External Connection"}]},{"@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\/a7dfc5684c116e536b4e93ee214ccbfb","name":"Faruk Erdem","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ad1e61fb5a7c9a590e765f7cad8f2dc8332090f1ceb9a5ee2aa95c69213f0c50?s=96&d=mm&r=g","caption":"Faruk Erdem"},"url":"https:\/\/dbtut.com\/index.php\/author\/farukerdem\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53344","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\/366"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=53344"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53344\/revisions"}],"predecessor-version":[{"id":53351,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/53344\/revisions\/53351"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/53350"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=53344"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=53344"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=53344"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}