{"id":396,"date":"2022-04-11T11:57:47","date_gmt":"2022-04-11T08:57:47","guid":{"rendered":"https:\/\/www.aakifb.com\/?p=396"},"modified":"2022-04-11T12:11:59","modified_gmt":"2022-04-11T09:11:59","slug":"postgresql-ayarlari","status":"publish","type":"post","link":"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/","title":{"rendered":"Postgresql 14 Ayarlar\u0131"},"content":{"rendered":"\n<!-- Speed Sense for AdSense WordPress Plugin: https:\/\/wordpress.org\/plugins\/speed-sense\/ -->\n<div id=\"ssp0\" style=\"float:left;margin:10px 10px 10px 0;max-width:970px;width:100%;\">\n<ins class=\"adsbygoogle\" id=\"adsgoogle0\" style=\"display: inline-block; width: 100%; height: 250px\"  data-ad-client=\"ca-pub-7093922171215546\" data-ad-slot=\"3130185915\"><\/ins><script>(adsbygoogle = window.adsbygoogle || []).push({});<\/script>\n<\/div>\n\n<h6>Bir \u00f6nceki yaz\u0131da Postgresql kurulumu yapt\u0131ysan\u0131z s\u0131rada konfig\u00fcrasyonunun yap\u0131lmas\u0131nda.Haydi ba\u015flayal\u0131m.<\/h6>\n\n\n\n<p> Varsay\u0131landa postgresql kuruldu\u011funda &#8220;postgres&#8221; ad\u0131nda kullan\u0131c\u0131 olu\u015fturuyor.<br> bu kullan\u0131c\u0131 \u015fifresi de\u011fi\u015ftirilebilir.<br><code> passwd postgres<\/code><br> Unutulmamal\u0131d\u0131r ki psql yetkisini sadece postgres kullan\u0131c\u0131s\u0131na vermektedir. Zaten root da bile olsan\u0131z psql komutunu girdi\u011finizde \u00e7al\u0131\u015ft\u0131rmayacakt\u0131r. Bunun i\u00e7in kullan\u0131c\u0131 de\u011fi\u015ftirilmeli 2 y\u00f6ntem ile girebilirsiniz hangisi akl\u0131n\u0131za yatarsa<br> -1 : <code>su postgres<\/code><br>       <code>psql<\/code><br> -2 : <code>su - postgres -c \"psql\"<\/code><br>bundan sonra postgres bash ekran\u0131na gelmi\u015f olaca\u011f\u0131z.<br>postgresql kurulduktan sonra yine postgres ad\u0131nda fakat veritaban\u0131na eri\u015fim i\u00e7in postgres kullan\u0131c\u0131s\u0131 olu\u015fturuyor. Bunu de\u011fi\u015ftirmeliyiz<br> <code>\\password postgres<\/code><\/p>\n\n\n\n<!--more-->\n\n\n\n<p>-Konfig\u00fcrasyon ayarlar\u0131n\u0131 Centos&#8217;da<em> \/var\/lib\/pgsql\/14\/data<\/em> &#8216;da tutuyor. (Ubuntu&#8217;da <em>\/etc\/postgresql\/14\/main<\/em>)<br> -yine de bulamazsan\u0131z postgresql de ayar de\u011fi\u015fli\u011fi yapaca\u011f\u0131m\u0131z bir dosyay\u0131 arayarak dizini bulabiliriz.<br><code> find \/ -name postgresql.conf<\/code><br> <code>sudo nano postgresql.conf<\/code><br> -burada <em># \u2014 Connection Settings &#8211; <\/em>sat\u0131r\u0131n\u0131 bulunuz. Varsay\u0131landa postgresql localhost&#8217;da \u00e7al\u0131\u015fmak \u00fczere ayarl\u0131 geliyor. Bunu de\u011fi\u015ftirmek i\u00e7in<br>#listen_addresses = \u2018localhost\u2019 sat\u0131r\u0131n\u0131 yorumdan kurtard\u0131ktan sonra<\/p>\n\n\n\n<p><em>listen_addresses = \u2018*\u2019<\/em> yapmak gerekli<br> -ayn\u0131 zamanda port a\u00e7mak i\u00e7in #port = 5432 sat\u0131r\u0131n\u0131da yorumdan kurtarmak gerekli.<br><em> port = 5432 <\/em><br> Son olarak pg_hba.conf dosyas\u0131n\u0131 d\u00fczenliyoruz<br><code> sudo nano ph_hba.conf<\/code><br> Burada # IPv4 local connections: sat\u0131r\u0131n\u0131 bulduktan sonra a\u015fa\u011f\u0131daki sat\u0131r\u0131 ekliyoruz. <br><code> host all all 0.0.0.0\/0 md5<\/code><\/p>\n\n\n\n<p>Postgresql servisini yeniden ba\u015flatt\u0131ktan sonra i\u015flemler tamamd\u0131r<br><code>systemctl restart postgresql<\/code>-14.service<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bir \u00f6nceki yaz\u0131da Postgresql kurulumu yapt\u0131ysan\u0131z s\u0131rada konfig\u00fcrasyonunun yap\u0131lmas\u0131nda.Haydi ba\u015flayal\u0131m. Varsay\u0131landa postgresql kuruldu\u011funda &#8220;postgres&#8221; ad\u0131nda kullan\u0131c\u0131 olu\u015fturuyor. bu kullan\u0131c\u0131 \u015fifresi de\u011fi\u015ftirilebilir. passwd postgres Unutulmamal\u0131d\u0131r ki psql yetkisini sadece postgres kullan\u0131c\u0131s\u0131na vermektedir. Zaten root da bile olsan\u0131z psql komutunu girdi\u011finizde \u00e7al\u0131\u015ft\u0131rmayacakt\u0131r. Bunun i\u00e7in kullan\u0131c\u0131 de\u011fi\u015ftirilmeli 2 y\u00f6ntem ile girebilirsiniz hangisi akl\u0131n\u0131za yatarsa -1 : su postgres &hellip; <a href=\"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/\" class=\"more-link\">Okumaya devam et<span class=\"screen-reader-text\"> &#8220;Postgresql 14 Ayarlar\u0131&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[137],"tags":[138,145,142,144,143],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v20.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Postgresql 14 Ayarlar\u0131 - aakifb<\/title>\n<meta name=\"description\" content=\"Postgresql kurulumu yapt\u0131ysan\u0131z s\u0131rada konfig\u00fcrasyonunun yap\u0131lmas\u0131nda. K\u00fc\u00e7\u00fck birka\u00e7 ayar ile art\u0131k postgresql sunucunuz eri\u015fime haz\u0131r hale gelecek\" \/>\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.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Postgresql 14 Ayarlar\u0131 - aakifb\" \/>\n<meta property=\"og:description\" content=\"Postgresql kurulumu yapt\u0131ysan\u0131z s\u0131rada konfig\u00fcrasyonunun yap\u0131lmas\u0131nda. K\u00fc\u00e7\u00fck birka\u00e7 ayar ile art\u0131k postgresql sunucunuz eri\u015fime haz\u0131r hale gelecek\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/\" \/>\n<meta property=\"og:site_name\" content=\"aakifb\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-11T08:57:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-04-11T09:11:59+00:00\" \/>\n<meta name=\"author\" content=\"aakifb\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"aakifb\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/\",\"url\":\"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/\",\"name\":\"Postgresql 14 Ayarlar\u0131 - aakifb\",\"isPartOf\":{\"@id\":\"https:\/\/www.aakifb.com\/#website\"},\"datePublished\":\"2022-04-11T08:57:47+00:00\",\"dateModified\":\"2022-04-11T09:11:59+00:00\",\"author\":{\"@id\":\"https:\/\/www.aakifb.com\/#\/schema\/person\/0c6eac9c7ad76608b1cff2f2840fc0d7\"},\"description\":\"Postgresql kurulumu yapt\u0131ysan\u0131z s\u0131rada konfig\u00fcrasyonunun yap\u0131lmas\u0131nda. K\u00fc\u00e7\u00fck birka\u00e7 ayar ile art\u0131k postgresql sunucunuz eri\u015fime haz\u0131r hale gelecek\",\"breadcrumb\":{\"@id\":\"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ana sayfa\",\"item\":\"https:\/\/www.aakifb.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Postgresql 14 Ayarlar\u0131\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.aakifb.com\/#website\",\"url\":\"https:\/\/www.aakifb.com\/\",\"name\":\"aakifb\",\"description\":\"Ki\u015fisel Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.aakifb.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"tr\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.aakifb.com\/#\/schema\/person\/0c6eac9c7ad76608b1cff2f2840fc0d7\",\"name\":\"aakifb\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/www.aakifb.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e67eac18d9da4cd52c5526141d6657ca?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e67eac18d9da4cd52c5526141d6657ca?s=96&d=mm&r=g\",\"caption\":\"aakifb\"},\"url\":\"https:\/\/www.aakifb.com\/index.php\/author\/aakifb\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Postgresql 14 Ayarlar\u0131 - aakifb","description":"Postgresql kurulumu yapt\u0131ysan\u0131z s\u0131rada konfig\u00fcrasyonunun yap\u0131lmas\u0131nda. K\u00fc\u00e7\u00fck birka\u00e7 ayar ile art\u0131k postgresql sunucunuz eri\u015fime haz\u0131r hale gelecek","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.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/","og_locale":"tr_TR","og_type":"article","og_title":"Postgresql 14 Ayarlar\u0131 - aakifb","og_description":"Postgresql kurulumu yapt\u0131ysan\u0131z s\u0131rada konfig\u00fcrasyonunun yap\u0131lmas\u0131nda. K\u00fc\u00e7\u00fck birka\u00e7 ayar ile art\u0131k postgresql sunucunuz eri\u015fime haz\u0131r hale gelecek","og_url":"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/","og_site_name":"aakifb","article_published_time":"2022-04-11T08:57:47+00:00","article_modified_time":"2022-04-11T09:11:59+00:00","author":"aakifb","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"aakifb","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/","url":"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/","name":"Postgresql 14 Ayarlar\u0131 - aakifb","isPartOf":{"@id":"https:\/\/www.aakifb.com\/#website"},"datePublished":"2022-04-11T08:57:47+00:00","dateModified":"2022-04-11T09:11:59+00:00","author":{"@id":"https:\/\/www.aakifb.com\/#\/schema\/person\/0c6eac9c7ad76608b1cff2f2840fc0d7"},"description":"Postgresql kurulumu yapt\u0131ysan\u0131z s\u0131rada konfig\u00fcrasyonunun yap\u0131lmas\u0131nda. K\u00fc\u00e7\u00fck birka\u00e7 ayar ile art\u0131k postgresql sunucunuz eri\u015fime haz\u0131r hale gelecek","breadcrumb":{"@id":"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.aakifb.com\/index.php\/2022\/04\/11\/postgresql-ayarlari\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ana sayfa","item":"https:\/\/www.aakifb.com\/"},{"@type":"ListItem","position":2,"name":"Postgresql 14 Ayarlar\u0131"}]},{"@type":"WebSite","@id":"https:\/\/www.aakifb.com\/#website","url":"https:\/\/www.aakifb.com\/","name":"aakifb","description":"Ki\u015fisel Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.aakifb.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"tr"},{"@type":"Person","@id":"https:\/\/www.aakifb.com\/#\/schema\/person\/0c6eac9c7ad76608b1cff2f2840fc0d7","name":"aakifb","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/www.aakifb.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e67eac18d9da4cd52c5526141d6657ca?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e67eac18d9da4cd52c5526141d6657ca?s=96&d=mm&r=g","caption":"aakifb"},"url":"https:\/\/www.aakifb.com\/index.php\/author\/aakifb\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pbvmez-6o","_links":{"self":[{"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/posts\/396"}],"collection":[{"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/comments?post=396"}],"version-history":[{"count":5,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/posts\/396\/revisions"}],"predecessor-version":[{"id":404,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/posts\/396\/revisions\/404"}],"wp:attachment":[{"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/media?parent=396"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/categories?post=396"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aakifb.com\/index.php\/wp-json\/wp\/v2\/tags?post=396"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}