{"id":2361,"date":"2022-10-30T03:47:01","date_gmt":"2022-10-30T03:47:01","guid":{"rendered":"https:\/\/sunucucozumleri.com\/?p=2361"},"modified":"2022-10-28T19:35:43","modified_gmt":"2022-10-28T19:35:43","slug":"ubuntu-postgresql-kurulumu-nasil-yapilir","status":"publish","type":"post","link":"https:\/\/sunucucozumleri.com\/blog\/ubuntu-postgresql-kurulumu-nasil-yapilir\/","title":{"rendered":"Ubuntu PostgreSQL Kurulumu Nas\u0131l Yap\u0131l\u0131r?"},"content":{"rendered":"<p><span>Bu yaz\u0131m\u0131zda Ubuntu 22.04 (Jammy Jellyfish) \u00fczerine PostgreSQL 15 veritaban\u0131 sunucusunun nas\u0131l kurulaca\u011f\u0131n\u0131 anlataca\u011f\u0131z.<\/span><\/p>\n<p><span>PostgreSQL, g\u00fc\u00e7l\u00fc, a\u00e7\u0131k kaynakl\u0131 bir nesne-ili\u015fkisel Veritaban\u0131 Y\u00f6netim Sistemidir (DBMS).\u00a0G\u00fcvenilirlik ve performans a\u00e7\u0131s\u0131ndan g\u00fc\u00e7l\u00fc bir itibar kazanan 35 y\u0131l\u0131 a\u015fk\u0131n bir s\u00fcredir sava\u015fta test edilmi\u015ftir.\u00a0Bu zengin \u00f6zelliklere sahip veritaban\u0131, Apple, IMDB, Instagram vb. gibi bir\u00e7ok teknoloji devi taraf\u0131ndan kullan\u0131lmaktad\u0131r.<\/span><\/p>\n<p><span>PostgreSQL, \u00e7ok say\u0131da SQL standard\u0131n\u0131 destekler ve bir\u00e7ok y\u00f6nden kullan\u0131c\u0131lar taraf\u0131ndan geni\u015fletilebilir olacak \u015fekilde yap\u0131land\u0131r\u0131lm\u0131\u015ft\u0131r.\u00a0Belirgin \u00f6zelliklerden baz\u0131lar\u0131 ACID i\u015flemlerini, yabanc\u0131 anahtarlar\u0131, alt sorgular\u0131, tetikleyicileri, kullan\u0131c\u0131 tan\u0131ml\u0131 t\u00fcrleri, i\u015flevleri vb. i\u00e7erir.<\/span><span id=\"ezoic-pub-ad-placeholder-166\" class=\"ezoic-adpicker-ad\"><\/span><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Makale \u0130\u00e7eri\u011fi<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u0130\u00e7indekiler Tablosunu A\u00e7\/Kapat\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucucozumleri.com\/blog\/ubuntu-postgresql-kurulumu-nasil-yapilir\/#Onkosullar\" >\u00d6nko\u015fullar<\/a><\/li><\/ul><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucucozumleri.com\/blog\/ubuntu-postgresql-kurulumu-nasil-yapilir\/#1_PostgreSQL_Paket_Deposunu_Etkinlestir\" >1) PostgreSQL Paket Deposunu Etkinle\u015ftir<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucucozumleri.com\/blog\/ubuntu-postgresql-kurulumu-nasil-yapilir\/#2_PostgreSQL_15_Veritabani_Sunucusu_ve_Istemcisini_Kurun\" >2) PostgreSQL 15 Veritaban\u0131 Sunucusu ve \u0130stemcisini Kurun<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucucozumleri.com\/blog\/ubuntu-postgresql-kurulumu-nasil-yapilir\/#3_PostgreSQL_Yonetici_Kullanici_Parolasini_Guncelleyin\" >3) PostgreSQL Y\u00f6netici Kullan\u0131c\u0131 Parolas\u0131n\u0131 G\u00fcncelleyin<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sunucucozumleri.com\/blog\/ubuntu-postgresql-kurulumu-nasil-yapilir\/#4_PostgreSQLi_Uzak_Baglantilara_Izin_Verecek_Sekilde_Yapilandirin\" >4) PostgreSQL&#8217;i Uzak Ba\u011flant\u0131lara \u0130zin Verecek \u015eekilde Yap\u0131land\u0131r\u0131n<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sunucucozumleri.com\/blog\/ubuntu-postgresql-kurulumu-nasil-yapilir\/#Uzak_Baglantiyi_Dogrulama\" >Uzak Ba\u011flant\u0131y\u0131 Do\u011frulama<\/a><\/li><\/ul><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h4><span class=\"ez-toc-section\" id=\"Onkosullar\"><\/span><span>\u00d6nko\u015fullar<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span>PostgreSQL sunucusunu kurmadan \u00f6nce, sistemin a\u015fa\u011f\u0131daki kurulum gereksinimlerini kar\u015f\u0131lad\u0131\u011f\u0131ndan emin olmal\u0131y\u0131z:<\/span><\/p>\n<ul>\n<li><span>\u00d6nceden Y\u00fcklenmi\u015f Ubuntu 22.04<\/span><\/li>\n<li><span>Sudo haklar\u0131na sahip normal bir kullan\u0131c\u0131<\/span><\/li>\n<li><span>Aktif bir internet ba\u011flant\u0131s\u0131<\/span><\/li>\n<li><span>Ek 512 MB disk alan\u0131 ile en az 2 GB RAM.\u00a0L\u00fctfen bunun demo ortam\u0131 i\u00e7in minimum bir gereklilik oldu\u011funu unutmay\u0131n.\u00a0Ger\u00e7ek donan\u0131m yap\u0131land\u0131rmas\u0131, veri hacmine g\u00f6re de\u011fi\u015fir.<\/span><\/li>\n<\/ul>\n<p><span>Daha fazla gecikmeden PostgreSQL 15 kurulum ad\u0131mlar\u0131n\u0131 derinlemesine inceleyelim,<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"1_PostgreSQL_Paket_Deposunu_Etkinlestir\"><\/span><span>1) PostgreSQL Paket Deposunu Etkinle\u015ftir<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>PostgreSQL 15 paketi varsay\u0131lan paket deposunda mevcut de\u011fildir, bu nedenle a\u015fa\u011f\u0131daki komutlar\u0131 kullanarak resmi paket deposunu etkinle\u015ftirin.<\/span><\/p>\n<pre>$ sudo sh -c 'echo \"deb http:\/\/apt.postgresql.org\/pub\/repos\/apt $(lsb_release -cs)-pgdg main\" &gt; \/etc\/apt\/sources.list.d\/pgdg.list'\r\n$ wget -qO- https:\/\/www.postgresql.org\/media\/keys\/ACCC4CF8.asc | sudo tee \/etc\/apt\/trusted.gpg.d\/pgdg.asc &amp;&gt;\/dev\/null<\/pre>\n<p><span>Ba\u015flamak i\u00e7in, paketlerin en son s\u00fcr\u00fcmlerini getirelim.\u00a0Bunu, a\u015fa\u011f\u0131da g\u00f6sterildi\u011fi gibi apt update komutunu kullanarak ba\u015farabiliriz:<\/span><\/p>\n<pre>$ sudo apt update<\/pre>\n<p><span>Yukar\u0131daki komutun tamamlanmas\u0131 birka\u00e7 saniye s\u00fcrecektir.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"2_PostgreSQL_15_Veritabani_Sunucusu_ve_Istemcisini_Kurun\"><\/span><span>2) PostgreSQL 15 Veritaban\u0131 Sunucusu ve \u0130stemcisini Kurun<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Postgresql paketi PostgreSQL veritaban\u0131 sunucusunun varsay\u0131lan s\u00fcr\u00fcm\u00fcn\u00fc kurarken, postgresql-client paketi istemci yard\u0131mc\u0131 program\u0131n\u0131 kurar.<\/span><\/p>\n<p><span>A\u015fa\u011f\u0131daki apt komutunu kullanarak PostgreSQL istemcisini ve sunucusunu kural\u0131m:<\/span><\/p>\n<pre>$ sudo apt install postgresql postgresql-client -y<\/pre>\n<p><span>Ard\u0131ndan, PostgreSQL hizmetinin \u00e7al\u0131\u015f\u0131r durumda oldu\u011funu do\u011frulayal\u0131m:<\/span><\/p>\n<pre>$ sudo systemctl status postgresql<\/pre>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2362\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir.webp\" alt=\"\" width=\"768\" height=\"157\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir.webp 768w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir-300x61.webp 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p><span>Son olarak, psql komut sat\u0131r\u0131 yard\u0131mc\u0131 program\u0131n\u0131 kullanarak PostgreSQL s\u00fcr\u00fcm\u00fcn\u00fc kontrol edin:<\/span><\/p>\n<pre>$ psql --version<\/pre>\n<p><span>Burada PostgreSQL&#8217;in s\u00fcr\u00fcm\u00fcn\u00fcn 15 oldu\u011funu g\u00f6rebiliriz.<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2363\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir2.png\" alt=\"\" width=\"646\" height=\"106\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir2.png 646w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir2-300x49.png 300w\" sizes=\"(max-width: 646px) 100vw, 646px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"3_PostgreSQL_Yonetici_Kullanici_Parolasini_Guncelleyin\"><\/span><span>3) PostgreSQL Y\u00f6netici Kullan\u0131c\u0131 Parolas\u0131n\u0131 G\u00fcncelleyin<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Varsay\u0131lan olarak PostgreSQL sunucusuna herhangi bir \u015fifre kullanmadan ba\u011flanabiliyoruz.\u00a0Bunu psql yard\u0131mc\u0131 program\u0131n\u0131 kullanarak \u00e7al\u0131\u015f\u0131rken g\u00f6relim:<\/span><\/p>\n<pre>$ sudo -u postgres psql\r\npostgres=#<\/pre>\n<p><span>Yukar\u0131daki \u00e7\u0131kt\u0131da,\u00a0<\/span><span>postgres=#<\/span><span>\u00a0\u00a0 istemi, PostgreSQL sunucusuyla etkin ba\u011flant\u0131y\u0131 g\u00f6sterdi.<\/span><\/p>\n<p><span>Bu \u00f6rnekte\u00a0<\/span><span>postgres<\/span><span>\u00a0kullan\u0131c\u0131s\u0131n\u0131 kulland\u0131k.\u00a0Bu, PostgreSQL&#8217;in y\u00f6netici kullan\u0131c\u0131s\u0131d\u0131r ve kurulum i\u015flemi s\u0131ras\u0131nda olu\u015fturulur.<\/span><\/p>\n<p><span>Veritaban\u0131na y\u00f6netici eri\u015fimine <a href=\"https:\/\/sunucucozumleri.com\/blog\/parola-saklama-uygulamalari-ve-karsilastirmalari\/\">parola<\/a> olmadan izin vermek iyi bir fikir de\u011fildir.\u00a0O halde postgres kullan\u0131c\u0131s\u0131n\u0131n \u015fifresini belirleyelim:<\/span><\/p>\n<pre>postgres=# ALTER USER postgres PASSWORD 'demoPassword';<\/pre>\n<p><span>Yukar\u0131daki SQL sorgusu, kullan\u0131c\u0131 parolas\u0131n\u0131\u00a0<\/span><span>demoPassword<\/span><span>\u00a0olarak ayarlar .\u00a0L\u00fctfen dikkat, bu bir demo ortam\u0131 oldu\u011fu i\u00e7in \u00e7ok basit bir \u015fifre kulland\u0131k.\u00a0Ancak, \u00fcretim ortam\u0131nda ayn\u0131 \u015fey \u00f6nerilmez.<\/span><\/p>\n<p><span>Parolan\u0131n ba\u015far\u0131yla ayarland\u0131\u011f\u0131n\u0131 do\u011frulayal\u0131m.\u00a0<\/span><span>\u0130lk olarak, \\q komutunu<\/span><span>\u00a0kullanarak mevcut oturumu sunucuyla sonland\u0131r\u0131n\u00a0.<\/span><\/p>\n<pre><span>postgres=# \\q<\/span><\/pre>\n<p><span>Yukar\u0131daki komutlar\u0131n \u00e7\u0131kt\u0131s\u0131,<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2364\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir3.webp\" alt=\"\" width=\"768\" height=\"193\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir3.webp 768w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir3-300x75.webp 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p><span>\u015eimdi tekrar veritaban\u0131 sunucusuna ba\u011flanal\u0131m:<\/span><\/p>\n<pre>$ psql -h localhost -U postgres<\/pre>\n<p><span>DemoPassword dizisini \u015fifre olarak girelim ve \u015fimdi veritaban\u0131na ba\u011fland\u0131k.<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2365\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir4.webp\" alt=\"\" width=\"768\" height=\"138\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir4.webp 768w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir4-300x54.webp 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"4_PostgreSQLi_Uzak_Baglantilara_Izin_Verecek_Sekilde_Yapilandirin\"><\/span><span>4) PostgreSQL&#8217;i Uzak Ba\u011flant\u0131lara \u0130zin Verecek \u015eekilde Yap\u0131land\u0131r\u0131n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span>Varsay\u0131lan olarak, PostgreSQL yaln\u0131zca yerel ana bilgisayardan gelen ba\u011flant\u0131lar\u0131 kabul eder.\u00a0Ancak, uzak istemcilerden ba\u011flant\u0131ya izin vermek i\u00e7in yap\u0131land\u0131rmay\u0131 kolayca de\u011fi\u015ftirebiliriz.<\/span><\/p>\n<p><span>PostgreSQL, yap\u0131land\u0131rmas\u0131n\u0131 \/etc\/postgresql\/&lt;version&gt;\/main\/\u00a0dizininde\u00a0bulunan\u00a0<\/span><span>postgresql.conf<\/span><span>\u00a0dosyas\u0131ndan okur .\u00a0Burada s\u00fcr\u00fcm, PostgreSQL&#8217;in ana s\u00fcr\u00fcm\u00fcn\u00fc g\u00f6sterir.<\/span><\/p>\n<p><span>\u00d6rne\u011fin, bizim durumumuzda dosyan\u0131n tam yolu\u00a0<\/span><span>\/etc\/postgresql\/15\/main\/postgresql.conf<\/span><span>\u00a0\u015feklindedir .<\/span><\/p>\n<p><span>\u015eimdi, postgresql.conf dosyas\u0131n\u0131 bir metin d\u00fczenleyicide a\u00e7\u0131n, listen_addresses<\/span><span>\u00a0ile ba\u015flayan sat\u0131r\u0131n yorumunu kald\u0131r\u0131n\u00a0ve &#8216;localhost&#8217;u&#8217;*&#8217; ile de\u011fi\u015ftirin.<\/span><\/p>\n<p><span>Bu ayar,\u00a0<\/span><span>BA\u011eLANTILAR VE DO\u011eRULAMA<\/span><span>\u00a0b\u00f6l\u00fcm\u00fcn\u00fcn alt\u0131nda bulunur.\u00a0De\u011fi\u015fiklikten sonra dosya \u015f\u00f6yle g\u00f6r\u00fcnecektir:<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2366\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir5.webp\" alt=\"\" width=\"768\" height=\"352\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir5.webp 768w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir5-300x138.webp 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p><span>Dosyay\u0131 kaydedin ve kapat\u0131n.<\/span><\/p>\n<p><span>Ard\u0131ndan, t\u00fcm istemcilerden IPv4 ba\u011flant\u0131lar\u0131na izin vermek i\u00e7in\u00a0<\/span><span>pg_hba.conf<\/span><span>\u00a0dosyas\u0131n\u0131n IPv4 yerel ba\u011flant\u0131lar\u0131 b\u00f6l\u00fcm\u00fcn\u00fc d\u00fczenleyin .\u00a0L\u00fctfen bu dosyan\u0131n\u00a0<\/span><span>\/etc\/postgresql\/15\/main\/<\/span><span>\u00a0dizininde de bulundu\u011funu unutmay\u0131n.<\/span><\/p>\n<pre>$ sudo vi \/etc\/postgresql\/15\/main\/pg_hba.conf<\/pre>\n<p><span>De\u011fi\u015fiklikten sonra dosya \u015f\u00f6yle g\u00f6r\u00fcnecektir:<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2367\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir6.webp\" alt=\"\" width=\"768\" height=\"368\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir6.webp 768w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir6-300x144.webp 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p><span>Yukar\u0131daki yap\u0131land\u0131rmada 192.168.1.0\/24 a\u011f\u0131ndan ba\u011flant\u0131ya izin verildi\u011fi belirtilir.<\/span><\/p>\n<p><span>Sisteminizde Ubuntu g\u00fcvenlik duvar\u0131 \u00e7al\u0131\u015f\u0131yorsa a\u015fa\u011f\u0131daki komutu kullanarak PostgreSQL 5432 portuna izin verin,<\/span><\/p>\n<pre>$ sudo ufw allow 5432\/tcp<\/pre>\n<h4><span class=\"ez-toc-section\" id=\"Uzak_Baglantiyi_Dogrulama\"><\/span><span>Uzak Ba\u011flant\u0131y\u0131 Do\u011frulama<\/span><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p><span>Son olarak, hizmeti yeniden ba\u015flat\u0131n ve \u00e7al\u0131\u015f\u0131r durumda oldu\u011funu do\u011frulay\u0131n:<\/span><\/p>\n<pre>$ sudo systemctl <a href=\"https:\/\/sunucucozumleri.com\/blog\/reboot-ve-restart-arasindaki-farklar-nedir\/\">restart<\/a> postgresql<\/pre>\n<pre>$ sudo systemctl status postgresql<\/pre>\n<p><span>\u015eimdi uzak istemciden DB&#8217;ye eri\u015fmeye \u00e7al\u0131\u015fal\u0131m.<\/span><\/p>\n<pre>$ psql -h 192.168.1.192 -U postgres<\/pre>\n<p><span>Bu \u00f6rnekte 192.168.1.192, PostgreSQL veritaban\u0131 sunucusunun IP adresidir.<\/span><\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-2368\" src=\"https:\/\/sunucucozumleri.com\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir7.webp\" alt=\"\" width=\"768\" height=\"177\" title=\"\" srcset=\"\/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir7.webp 768w, \/\/sunucucozumleri.com\/blog\/wp-content\/uploads\/2022\/10\/Ubuntu-PostgreSQL-Kurulumu-Nasil-Yapilir7-300x69.webp 300w\" sizes=\"(max-width: 768px) 100vw, 768px\" \/><\/p>\n<p><span>Burada, uzak istemciden DB&#8217;ye eri\u015febildi\u011fimizi g\u00f6rebiliriz.<\/span><\/p>\n<p><span>Bu makalenin tamam\u0131 bu kadar. L\u00fctfen sorular\u0131n\u0131z\u0131 ve geri bildirimlerinizi a\u015fa\u011f\u0131daki yorumlar b\u00f6l\u00fcm\u00fcne g\u00f6nderin.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Bu yaz\u0131m\u0131zda Ubuntu 22.04 (Jammy Jellyfish) \u00fczerine PostgreSQL 15 veritaban\u0131 sunucusunun nas\u0131l kurulaca\u011f\u0131n\u0131 anlataca\u011f\u0131z. PostgreSQL, g\u00fc\u00e7l\u00fc, a\u00e7\u0131k kaynakl\u0131 bir nesne-ili\u015fkisel Veritaban\u0131 Y\u00f6netim Sistemidir (DBMS).\u00a0G\u00fcvenilirlik ve performans a\u00e7\u0131s\u0131ndan g\u00fc\u00e7l\u00fc bir itibar kazanan 35 y\u0131l\u0131 a\u015fk\u0131n bir s\u00fcredir sava\u015fta test edilmi\u015ftir.\u00a0Bu zengin \u00f6zelliklere sahip veritaban\u0131, Apple, IMDB, Instagram vb. gibi bir\u00e7ok teknoloji devi taraf\u0131ndan kullan\u0131lmaktad\u0131r. PostgreSQL, \u00e7ok &hellip;<\/p>\n","protected":false},"author":1,"featured_media":2366,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[],"class_list":["post-2361","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-ubuntu"],"acf":[],"_links":{"self":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/2361","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/comments?post=2361"}],"version-history":[{"count":0,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/posts\/2361\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media\/2366"}],"wp:attachment":[{"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/media?parent=2361"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/categories?post=2361"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucucozumleri.com\/blog\/wp-json\/wp\/v2\/tags?post=2361"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}