{"id":689,"date":"2014-03-21T17:44:28","date_gmt":"2014-03-21T15:44:28","guid":{"rendered":"http:\/\/www.ayhanarda.com\/blog\/?p=689"},"modified":"2014-03-21T17:45:18","modified_gmt":"2014-03-21T15:45:18","slug":"postgresql-uzak-erisim-ayari","status":"publish","type":"post","link":"https:\/\/www.ayhanarda.com\/blog\/2014\/03\/postgresql-uzak-erisim-ayari\/","title":{"rendered":"Postgresql Uzak Eri\u015fim Ayar\u0131"},"content":{"rendered":"<p>Sunucunuzda 5432 nolu porta firewall dan izin verdi\u011finizi ya da firewall kullanmad\u0131\u011f\u0131n\u0131z\u0131 varsay\u0131yorum<\/p>\n<p>E\u011fer iptables kullan\u0131yor iseniz a\u015fa\u011f\u0131daki komut ile a\u00e7abilirsiniz.<\/p>\n<p><strong>iptables -A INPUT -p tcp &#8211;dport 5432 -j ACCEPT<\/strong><\/p>\n<p>Bu i\u015flemden sonra <strong>postgresql.conf<\/strong> dosyas\u0131nda i\u015flem yapmam\u0131z gerekiyor,\u00a0 bu dosya genellikle\u00a0 <strong>\/etc\/postgresql\/9.1\/main\/postgresql.conf<\/strong> yolundad\u0131r , Sizde bu \u015fekil de\u011fil ise <strong>locate<\/strong> komutu ile yeri bulunabilir.<\/p>\n<p>root@webhostingsitesi.com:# <strong>locate postgresql.conf<\/strong><br \/>\n\/etc\/postgresql\/9.1\/main\/postgresql.conf<\/p>\n<p>Dosyam\u0131z\u0131 nano ya da farkl\u0131 bir editor ile a\u00e7\u0131p i\u00e7inde bo\u015f bir alana a\u015fa\u011f\u0131daki sat\u0131r\u0131 yaz\u0131p kaydediyoruz.<\/p>\n<p>root@webhostingsitesi.com:# <strong>nano \/etc\/postgresql\/9.1\/main\/postgresql.conf<\/strong><\/p>\n<p><em>listen_addresses = &#8216;*&#8217;<\/em><\/p>\n<p>Sonras\u0131nda postresql i restart etmemiz gerekiyor , a\u015fa\u011f\u0131daki komutla yapabiliriz.<\/p>\n<p>root@webhostingsitesi.com:#<strong>\/etc\/init.d\/postgresql restart<\/strong><\/p>\n<p>Art\u0131k 5432 nolu porta her yerden eri\u015febilirsiniz.<\/p>\n<p>Ayhan ARDA<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<div style=\"padding-bottom:20px; padding-top:10px;\" class=\"hupso-share-buttons\"><!-- Hupso Share Buttons - https:\/\/www.hupso.com\/share\/ --><a class=\"hupso_toolbar\" href=\"https:\/\/www.hupso.com\/share\/\"><img decoding=\"async\" src=\"https:\/\/static.hupso.com\/share\/buttons\/lang\/tr\/share-medium.png\" style=\"border:0px; padding-top: 5px; float:left;\" alt=\"Share Button\"\/><\/a><script type=\"text\/javascript\">var hupso_services_t=new Array(\"Twitter\",\"Facebook\",\"Google Plus\",\"Pinterest\",\"Linkedin\");var hupso_background_t=\"#EAF4FF\";var hupso_border_t=\"#66CCFF\";var hupso_toolbar_size_t=\"medium\";var hupso_image_folder_url = \"\";var hupso_twitter_via=\"ayhanarda\";var hupso_url_t=\"\";var hupso_title_t=\"Postgresql%20Uzak%20Eri%C5%9Fim%20Ayar%C4%B1\";<\/script><script type=\"text\/javascript\" src=\"https:\/\/static.hupso.com\/share\/js\/share_toolbar.js\"><\/script><!-- Hupso Share Buttons --><\/div>","protected":false},"excerpt":{"rendered":"Sunucunuzda 5432 nolu porta firewall dan izin verdi\u011finizi ya da firewall kullanmad\u0131\u011f\u0131n\u0131z\u0131 varsay\u0131yorum E\u011fer iptables kullan\u0131yor iseniz a\u015fa\u011f\u0131daki komut ile a\u00e7abilirsiniz. iptables -A INPUT -p tcp &#8211;dport 5432 -j ACCEPT Bu i\u015flemden sonra postgresql.conf dosyas\u0131nda i\u015flem yapmam\u0131z gerekiyor,\u00a0 bu dosya genellikle\u00a0 \/etc\/postgresql\/9.1\/main\/postgresql.conf yolundad\u0131r , Sizde bu \u015fekil de\u011fil ise locate komutu ile yeri bulunabilir. root@webhostingsitesi.com:# [&hellip;]","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","footnotes":""},"categories":[501],"tags":[502,504,503,505],"class_list":["post-689","post","type-post","status-publish","format-standard","hentry","category-postgresql","tag-postgresql-2","tag-postgresql-listen-address","tag-postgresql-remote-access","tag-postgresql-conf"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/689","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/comments?post=689"}],"version-history":[{"count":2,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/689\/revisions"}],"predecessor-version":[{"id":691,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/posts\/689\/revisions\/691"}],"wp:attachment":[{"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/media?parent=689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/categories?post=689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.ayhanarda.com\/blog\/wp-json\/wp\/v2\/tags?post=689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}