{"id":30729,"date":"2025-10-01T09:41:00","date_gmt":"2025-10-01T06:41:00","guid":{"rendered":"https:\/\/fatihsoysal.com\/blog\/?p=30729"},"modified":"2025-10-01T09:41:00","modified_gmt":"2025-10-01T06:41:00","slug":"postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/","title":{"rendered":"PostgreSQL Veri Dizinini Ubuntu 18.04&#8217;te Yeni Bir Konuma Ta\u015f\u0131ma"},"content":{"rendered":"<p><body><\/p>\n<h2>PostgreSQL Veri Dizinini Ubuntu 18.04&#8217;te Yeni Bir Konuma Ta\u015f\u0131ma<\/h2>\n<h3>Giri\u015f<\/h3>\n<p>PostgreSQL, a\u00e7\u0131k kaynakl\u0131 ve g\u00fc\u00e7l\u00fc bir ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir (RDBMS). Uygulamalar\u0131n ve hizmetlerin temelini olu\u015fturan verilerin depolanmas\u0131nda kritik bir rol oynar. Zamanla, bir PostgreSQL kurulumunun veri dizini, disk alan\u0131 yetersizli\u011fi, performans optimizasyonu, ayr\u0131 bir depolama birimine ge\u00e7i\u015f, yedekleme stratejilerini iyile\u015ftirme veya sistem mimarisini d\u00fczenleme gibi \u00e7e\u015fitli nedenlerle farkl\u0131 bir konuma ta\u015f\u0131nma ihtiyac\u0131 duyabilir. Bu teknik makale, Ubuntu 18.04 i\u015fletim sistemi \u00fczerinde \u00e7al\u0131\u015fan bir PostgreSQL veri dizinini g\u00fcvenli ve etkili bir \u015fekilde yeni bir konuma nas\u0131l ta\u015f\u0131yaca\u011f\u0131n\u0131z\u0131 ad\u0131m ad\u0131m a\u00e7\u0131klamaktad\u0131r.<\/p>\n<p>Veri dizinini ta\u015f\u0131mak, hassas bir i\u015flem olup yanl\u0131\u015f yap\u0131ld\u0131\u011f\u0131nda veri kayb\u0131na yol a\u00e7abilir. Bu nedenle, her ad\u0131m\u0131n dikkatlice takip edilmesi ve \u00f6zellikle yedekleme ad\u0131mlar\u0131n\u0131n atlanmamas\u0131 b\u00fcy\u00fck \u00f6nem ta\u015f\u0131r. Bu rehber, olas\u0131 riskleri en aza indirerek sorunsuz bir ge\u00e7i\u015f sa\u011flamay\u0131 ama\u00e7lamaktad\u0131r.<\/p>\n<h3>\u00d6n Haz\u0131rl\u0131klar ve G\u00fcvenlik Tedbirleri<\/h3>\n<p>Veri ta\u015f\u0131ma i\u015flemine ba\u015flamadan \u00f6nce, sisteminizin ve verilerinizin g\u00fcvenli\u011fini sa\u011flamak i\u00e7in baz\u0131 \u00f6nemli haz\u0131rl\u0131klar yapman\u0131z gerekmektedir. Bu ad\u0131mlar, olas\u0131 sorunlarda geri d\u00f6n\u00fc\u015f noktas\u0131 sa\u011flaman\u0131n yan\u0131 s\u0131ra, ta\u015f\u0131ma i\u015fleminin ba\u015far\u0131l\u0131 bir \u015fekilde tamamlanmas\u0131 i\u00e7in gerekli ortam\u0131 haz\u0131rlar.<\/p>\n<h4>Veri Yedekleme<\/h4>\n<p>Herhangi bir kritik sistem de\u011fi\u015fikli\u011finde oldu\u011fu gibi, PostgreSQL veri dizinini ta\u015f\u0131madan \u00f6nce mevcut veritabanlar\u0131n\u0131z\u0131n tam bir yede\u011fini almak mutlak surette gereklidir. Bu yedek, beklenmedik bir hata durumunda verilerinizi kurtarman\u0131z\u0131 sa\u011flayacak cankurtaran\u0131n\u0131zd\u0131r. \u0130ki temel yedekleme y\u00f6ntemi \u00f6nerilir:<\/p>\n<h5>Mant\u0131ksal Yedekleme (pg_dumpall)<\/h5>\n<p>Bu y\u00f6ntem, t\u00fcm veritabanlar\u0131n\u0131, rolleri, tablolar\u0131 ve di\u011fer veritaban\u0131 nesnelerini SQL komutlar\u0131 \u015feklinde yedekler. Bu, platform ba\u011f\u0131ms\u0131z bir yedekleme olup, geri y\u00fckleme esnekli\u011fi sunar.<\/p>\n<pre><code class=\"language-bash\">sudo -u postgres pg_dumpall > \/path\/to\/your\/backup\/all_databases_backup.sql<\/code><\/pre>\n<p><code>\/path\/to\/your\/backup\/<\/code> k\u0131sm\u0131n\u0131 yedek dosyan\u0131z\u0131 saklamak istedi\u011finiz g\u00fcvenli bir dizinle de\u011fi\u015ftirin. Bu dizinin yeni veri dizini konumunda veya mevcut PostgreSQL veri dizininde olmamas\u0131 \u00f6nemlidir. Tercihen harici bir depolama birimi veya farkl\u0131 bir disk b\u00f6l\u00fcm\u00fc kullan\u0131lmal\u0131d\u0131r.<\/p>\n<h5>Fiziksel Yedekleme (Dizin Kopyalama)<\/h5>\n<p>PostgreSQL servisi durdurulduktan sonra veri dizininin do\u011frudan kopyalanmas\u0131, ta\u015f\u0131ma i\u015flemi s\u0131ras\u0131nda bir sorun ya\u015fanmas\u0131 durumunda mevcut durumu geri y\u00fcklemek i\u00e7in h\u0131zl\u0131 bir yol sa\u011flar. Bu, bir nevi &#8220;anl\u0131k g\u00f6r\u00fcnt\u00fc&#8221; yedeklemesidir.<\/p>\n<pre><code class=\"language-bash\">sudo cp -Rp \/var\/lib\/postgresql\/10\/main \/path\/to\/your\/backup\/postgresql_data_backup_$(date +%Y%m%d%H%M)<\/code><\/pre>\n<p>Burada <code>\/var\/lib\/postgresql\/10\/main<\/code> varsay\u0131lan PostgreSQL 10 veri dizini yoludur. Kendi PostgreSQL s\u00fcr\u00fcm\u00fcn\u00fcze g\u00f6re bu yolu ayarlaman\u0131z gerekebilir (\u00f6rne\u011fin, PostgreSQL 12 i\u00e7in <code>\/var\/lib\/postgresql\/12\/main<\/code>). <code>-R<\/code> dizinleri \u00f6zyinelemeli olarak kopyalar, <code>-p<\/code> ise izinleri ve zaman damgalar\u0131n\u0131 korur.<\/p>\n<h4>Sistem Bilgilerini Kontrol Etme<\/h4>\n<p>Ta\u015f\u0131ma i\u015flemine ba\u015flamadan \u00f6nce mevcut PostgreSQL kurulumunuz hakk\u0131nda baz\u0131 temel bilgileri edinmek faydal\u0131d\u0131r:<\/p>\n<p>*   <strong>PostgreSQL S\u00fcr\u00fcm\u00fc:<\/strong> Genellikle <code>\/etc\/postgresql\/<\/code> alt\u0131nda s\u00fcr\u00fcm numaras\u0131na g\u00f6re dizinler bulunur (\u00f6rn. <code>10<\/code>, <code>12<\/code>, <code>14<\/code>).<br \/>\n*   <strong>Mevcut Veri Dizini Konumu:<\/strong> PostgreSQL komut sat\u0131r\u0131ndan ba\u011flanarak bu bilgiyi edinebilirsiniz:<\/p>\n<pre><code class=\"language-bash\">sudo -u postgres psql -c \"SHOW data_directory;\"<\/code><\/pre>\n<p>    Bu komut size mevcut veri dizininin tam yolunu g\u00f6sterecektir, \u00f6rne\u011fin <code>\/var\/lib\/postgresql\/10\/main<\/code>.<br \/>\n*   <strong>PostgreSQL Servis Durumu:<\/strong> Servisin \u00e7al\u0131\u015ft\u0131\u011f\u0131ndan emin olun.<\/p>\n<pre><code class=\"language-bash\">sudo systemctl status postgresql<\/code><\/pre>\n<p>*   <strong>Yeni Konumda Disk Alan\u0131:<\/strong> Yeni veri dizinini ta\u015f\u0131yaca\u011f\u0131n\u0131z disk b\u00f6l\u00fcm\u00fcnde yeterli bo\u015f alan oldu\u011fundan emin olun. Mevcut veri dizininin boyutunu kontrol edin ve yeni konumda en az ayn\u0131 miktarda, hatta biraz daha fazla bo\u015f alan oldu\u011fundan emin olun.<\/p>\n<pre><code class=\"language-bash\">du -sh \/var\/lib\/postgresql\/10\/main # Mevcut dizin boyutu\n    df -h \/mnt\/new_disk_mount_point # Yeni konumdaki bo\u015f alan<\/code><\/pre>\n<h4>Yeni Konumun Haz\u0131rlanmas\u0131<\/h4>\n<p>Veri dizinini ta\u015f\u0131yaca\u011f\u0131n\u0131z yeni konumda gerekli dizin yap\u0131s\u0131n\u0131 olu\u015fturman\u0131z ve do\u011fru sahiplik ile izinleri ayarlaman\u0131z gerekmektedir.<\/p>\n<p>*   <strong>Yeni Dizin Olu\u015fturma:<\/strong> Yeni veri dizini i\u00e7in bir ana dizin ve ard\u0131ndan s\u00fcr\u00fcm ve k\u00fcme ad\u0131 i\u00e7in alt dizinler olu\u015fturun. \u00d6rne\u011fin, <code>\/mnt\/new_disk\/postgresql\/10\/main<\/code> gibi bir yap\u0131 kullanabilirsiniz.<\/p>\n<pre><code class=\"language-bash\">sudo mkdir -p \/mnt\/new_disk\/postgresql\/10\/main<\/code><\/pre>\n<p>    Burada <code>\/mnt\/new_disk<\/code> yeni disk b\u00f6l\u00fcm\u00fcn\u00fcz\u00fcn ba\u011flama noktas\u0131 olabilir. Bu yolu kendi sisteminize g\u00f6re ayarlay\u0131n.<br \/>\n*   <strong>Sahiplik ve \u0130zinleri Ayarlama:<\/strong> PostgreSQL veri dizini, <code>postgres<\/code> kullan\u0131c\u0131s\u0131 ve grubuna ait olmal\u0131 ve yaln\u0131zca bu kullan\u0131c\u0131 taraf\u0131ndan okunabilir ve yaz\u0131labilir olmal\u0131d\u0131r. Bu, g\u00fcvenlik i\u00e7in kritik \u00f6neme sahiptir.<\/p>\n<pre><code class=\"language-bash\">sudo chown -R postgres:postgres \/mnt\/new_disk\/postgresql\/10\/main\n    sudo chmod -R 0700 \/mnt\/new_disk\/postgresql\/10\/main<\/code><\/pre>\n<p>    <code>0700<\/code> izinleri, yaln\u0131zca dizin sahibinin (yani <code>postgres<\/code> kullan\u0131c\u0131s\u0131n\u0131n) okuma, yazma ve y\u00fcr\u00fctme (dizinler i\u00e7in gezinme) haklar\u0131na sahip oldu\u011fu anlam\u0131na gelir. Ba\u015fka hi\u00e7bir kullan\u0131c\u0131 veya grup bu dizine eri\u015femez.<\/p>\n<h3>PostgreSQL Servisini Durdurma<\/h3>\n<p>Veri dizinini ta\u015f\u0131madan \u00f6nce PostgreSQL servisini tamamen durdurmak zorunludur. Servis \u00e7al\u0131\u015f\u0131rken veri dizinini ta\u015f\u0131maya \u00e7al\u0131\u015fmak, veri bozulmas\u0131na ve geri d\u00f6n\u00fc\u015f\u00fc olmayan hatalara yol a\u00e7abilir.<\/p>\n<pre><code class=\"language-bash\">sudo systemctl stop postgresql<\/code><\/pre>\n<p>Servisin ba\u015far\u0131yla durduruldu\u011funu do\u011frulamak i\u00e7in a\u015fa\u011f\u0131daki komutu kullanabilirsiniz:<\/p>\n<pre><code class=\"language-bash\">sudo systemctl status postgresql<\/code><\/pre>\n<p>\u00c7\u0131kt\u0131da <code>Active: inactive (dead)<\/code> veya benzeri bir durum g\u00f6rmelisiniz.<\/p>\n<h3>Veri Dizinini Ta\u015f\u0131ma<\/h3>\n<p>PostgreSQL servisi durdurulduktan ve yeni konum haz\u0131rland\u0131ktan sonra, mevcut veri dizinini yeni konuma ta\u015f\u0131yabiliriz. Bu i\u015flem i\u00e7in <code>rsync<\/code> komutunu kullanmak, b\u00fcy\u00fck dizinler i\u00e7in daha g\u00fcvenli ve bilgilendirici bir y\u00f6ntemdir.<\/p>\n<h4>rsync ile Ta\u015f\u0131ma<\/h4>\n<p><code>rsync<\/code>, dosyalar\u0131 ve dizinleri kopyalamak ve senkronize etmek i\u00e7in g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. \u00d6zellikle b\u00fcy\u00fck veri dizinlerini ta\u015f\u0131rken ilerleme g\u00f6stergesi sunmas\u0131, a\u011f \u00fczerinden kopyalama yapabilmesi ve hatalara kar\u015f\u0131 daha diren\u00e7li olmas\u0131 nedeniyle tercih edilir.<\/p>\n<pre><code class=\"language-bash\">sudo rsync -av \/var\/lib\/postgresql\/10\/main\/ \/mnt\/new_disk\/postgresql\/10\/main\/<\/code><\/pre>\n<p>Bu komuttaki parametrelerin anlamlar\u0131:<br \/>\n*   <code>-a<\/code> (archive): Ar\u015fiv modu; \u00f6zyinelemeli kopyalama, sembolik ba\u011flant\u0131lar\u0131 koruma, izinleri, sahipli\u011fi, zaman damgalar\u0131n\u0131 koruma gibi bir\u00e7ok \u015feyi i\u00e7erir.<br \/>\n*   <code>-v<\/code> (verbose): Ayr\u0131nt\u0131l\u0131 \u00e7\u0131kt\u0131 verir, kopyalanan dosyalar\u0131 g\u00f6sterir.<br \/>\n<em>   <code>\/var\/lib\/postgresql\/10\/main\/<\/code> (kaynak): Mevcut PostgreSQL veri dizininin yolu. Sondaki e\u011fik \u00e7izgi (<code>\/<\/code>), dizinin <\/em>i\u00e7eri\u011finin* kopyalanaca\u011f\u0131 anlam\u0131na gelir, dizinin kendisinin de\u011fil.<br \/>\n*   <code>\/mnt\/new_disk\/postgresql\/10\/main\/<\/code> (hedef): Yeni veri dizini konumu.<\/p>\n<p>Ta\u015f\u0131ma i\u015flemi tamamland\u0131ktan sonra, eski veri dizinini hemen silmek yerine, bir yedek olarak yeniden adland\u0131rmak iyi bir uygulamad\u0131r. Bu, herhangi bir sorun ya\u015fanmas\u0131 durumunda kolayca geri d\u00f6nebilmenizi sa\u011flar.<\/p>\n<pre><code class=\"language-bash\">sudo mv \/var\/lib\/postgresql\/10\/main \/var\/lib\/postgresql\/10\/main_old<\/code><\/pre>\n<h3>PostgreSQL Yap\u0131land\u0131rmas\u0131n\u0131 G\u00fcncelleme<\/h3>\n<p>Veri dizini yeni konumuna ta\u015f\u0131nd\u0131ktan sonra, PostgreSQL&#8217;e bu de\u011fi\u015fikli\u011fi bildirmeniz gerekir. Bu, <code>postgresql.conf<\/code> yap\u0131land\u0131rma dosyas\u0131nda yap\u0131l\u0131r.<\/p>\n<h4>postgresql.conf Dosyas\u0131n\u0131 D\u00fczenleme<\/h4>\n<p><code>postgresql.conf<\/code> dosyas\u0131, PostgreSQL sunucusunun davran\u0131\u015f\u0131n\u0131 kontrol eden ana yap\u0131land\u0131rma dosyas\u0131d\u0131r. Ubuntu&#8217;da bu dosya genellikle <code>\/etc\/postgresql\/<version>\/main\/postgresql.conf<\/code> yolunda bulunur.<\/p>\n<p>1.  <strong>Yap\u0131land\u0131rma Dosyas\u0131n\u0131 A\u00e7ma:<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo nano \/etc\/postgresql\/10\/main\/postgresql.conf<\/code><\/pre>\n<p>    PostgreSQL s\u00fcr\u00fcm\u00fcn\u00fcze g\u00f6re yolu ayarlamay\u0131 unutmay\u0131n.<\/p>\n<p>2.  <strong><code>data_directory<\/code> Parametresini Bulma ve G\u00fcncelleme:<\/strong><br \/>\n    Dosya i\u00e7inde <code>data_directory<\/code> parametresini aray\u0131n. Genellikle yorum sat\u0131r\u0131 olarak (ba\u015f\u0131nda <code>#<\/code> i\u015faretiyle) bulunur ve varsay\u0131lan yolu g\u00f6sterir.<\/p>\n<pre><code class=\"language-conf\">#data_directory = 'var\/lib\/postgresql\/10\/main'     # use data in another directory<\/code><\/pre>\n<p>    Bu sat\u0131r\u0131 bulun, yorum i\u015faretini kald\u0131r\u0131n (<code>#<\/code>) ve de\u011ferini yeni veri dizini konumunuza ayarlay\u0131n:<\/p>\n<pre><code class=\"language-conf\">data_directory = '\/mnt\/new_disk\/postgresql\/10\/main'<\/code><\/pre>\n<p>    E\u011fer dosyada birden fazla <code>data_directory<\/code> giri\u015fi varsa, yaln\u0131zca birinin yorum sat\u0131r\u0131 olmad\u0131\u011f\u0131ndan ve do\u011fru yolu g\u00f6sterdi\u011finden emin olun. Di\u011ferlerini yorum sat\u0131r\u0131 yap\u0131n veya silin.<\/p>\n<p>3.  <strong>Dosyay\u0131 Kaydetme ve \u00c7\u0131kma:<\/strong><br \/>\n    Nano d\u00fczenleyicisinde, <code>Ctrl+O<\/code> tu\u015flar\u0131na basarak kaydedin, ard\u0131ndan <code>Enter<\/code> tu\u015funa bas\u0131n ve <code>Ctrl+X<\/code> tu\u015flar\u0131na basarak \u00e7\u0131k\u0131n.<\/p>\n<h3>Yeni Konumun \u0130zinlerini Kontrol Etme<\/h3>\n<p>Daha \u00f6nce yeni dizini olu\u015ftururken izinleri ayarlam\u0131\u015f olsak da, ta\u015f\u0131ma i\u015flemi veya yap\u0131land\u0131rma de\u011fi\u015fiklikleri s\u0131ras\u0131nda yanl\u0131\u015fl\u0131kla de\u011fi\u015fmi\u015f olabilece\u011fi ihtimaline kar\u015f\u0131 izinleri ve sahipli\u011fi tekrar kontrol etmek iyi bir ad\u0131md\u0131r. PostgreSQL&#8217;in yeni veri dizinine eri\u015febilmesi i\u00e7in do\u011fru izinlere sahip olmas\u0131 kritik \u00f6neme sahiptir.<\/p>\n<pre><code class=\"language-bash\">sudo chown -R postgres:postgres \/mnt\/new_disk\/postgresql\/10\/main\nsudo chmod -R 0700 \/mnt\/new_disk\/postgresql\/10\/main<\/code><\/pre>\n<p>Bu komutlar, yeni veri dizininin ve t\u00fcm alt dizinleri ile dosyalar\u0131n\u0131n <code>postgres<\/code> kullan\u0131c\u0131s\u0131 ve grubuna ait olmas\u0131n\u0131 sa\u011flar ve yaln\u0131zca bu kullan\u0131c\u0131ya tam eri\u015fim yetkisi verir.<\/p>\n<h3>PostgreSQL Servisini Ba\u015flatma ve Do\u011frulama<\/h3>\n<p>T\u00fcm yap\u0131land\u0131rma de\u011fi\u015fiklikleri yap\u0131ld\u0131ktan ve izinler kontrol edildikten sonra, PostgreSQL servisini ba\u015flatabilir ve ta\u015f\u0131ma i\u015fleminin ba\u015far\u0131l\u0131 olup olmad\u0131\u011f\u0131n\u0131 do\u011frulayabiliriz.<\/p>\n<p>1.  <strong>PostgreSQL Servisini Ba\u015flatma:<\/strong><\/p>\n<pre><code class=\"language-bash\">sudo systemctl start postgresql<\/code><\/pre>\n<p>2.  <strong>Servis Durumunu Kontrol Etme:<\/strong><br \/>\n    Servisin ba\u015far\u0131yla ba\u015flat\u0131l\u0131p ba\u015flat\u0131lmad\u0131\u011f\u0131n\u0131 kontrol edin.<\/p>\n<pre><code class=\"language-bash\">sudo systemctl status postgresql<\/code><\/pre>\n<p>    <code>Active: active (exited)<\/code> veya <code>Active: active (running)<\/code> gibi bir durum g\u00f6rmelisiniz. E\u011fer servis ba\u015flamazsa veya hata verirse, sonraki &#8220;S\u0131k Kar\u015f\u0131la\u015f\u0131lan Sorunlar ve \u00c7\u00f6z\u00fcmleri&#8221; b\u00f6l\u00fcm\u00fcne bak\u0131n.<\/p>\n<p>3.  <strong>PostgreSQL Loglar\u0131n\u0131 Kontrol Etme:<\/strong><br \/>\n    Herhangi bir hata veya uyar\u0131 i\u00e7in PostgreSQL loglar\u0131n\u0131 kontrol etmek \u00e7ok \u00f6nemlidir.<\/p>\n<pre><code class=\"language-bash\">sudo journalctl -u postgresql -f<\/code><\/pre>\n<p>    veya do\u011frudan log dosyalar\u0131n\u0131 kontrol edebilirsiniz:<\/p>\n<pre><code class=\"language-bash\">sudo tail -f \/var\/log\/postgresql\/postgresql-10-main.log<\/code><\/pre>\n<p>    Loglarda <code>FATAL<\/code> veya <code>ERROR<\/code> mesajlar\u0131 aray\u0131n.<\/p>\n<p>4.  <strong>Veri Dizini Konumunu Do\u011frulama:<\/strong><br \/>\n    <code>psql<\/code> ile PostgreSQL&#8217;e ba\u011flanarak yeni <code>data_directory<\/code> konumunun do\u011fru ayarland\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n.<\/p>\n<pre><code class=\"language-bash\">sudo -u postgres psql<\/code><\/pre>\n<p>    <code>psql<\/code> komut isteminde:<\/p>\n<pre><code class=\"language-sql\">SHOW data_directory;<\/code><\/pre>\n<p>    Bu komutun \u00e7\u0131kt\u0131s\u0131, <code>postgresql.conf<\/code> dosyas\u0131nda belirtti\u011finiz yeni yolu (<code>\/mnt\/new_disk\/postgresql\/10\/main<\/code>) g\u00f6stermelidir.<\/p>\n<p>5.  <strong>Veritabanlar\u0131n\u0131 ve Verileri Test Etme:<\/strong><br \/>\n    Veritabanlar\u0131n\u0131z\u0131n listesini g\u00f6r\u00fcnt\u00fcleyin, tablolara sorgular \u00e7al\u0131\u015ft\u0131r\u0131n ve verilerinize eri\u015febildi\u011finizden emin olun. T\u00fcm uygulamalar\u0131n\u0131z\u0131n ve hizmetlerinizin veritaban\u0131na sorunsuz bir \u015fekilde ba\u011flanabildi\u011fini ve beklendi\u011fi gibi \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n.<\/p>\n<pre><code class=\"language-sql\">\\l  -- Veritabanlar\u0131n\u0131 listeler\n    \\c your_database_name -- Bir veritaban\u0131na ba\u011flan\u0131n\n    \\dt -- Tablolar\u0131 listeler\n    SELECT * FROM your_table_name LIMIT 10; -- Bir tablodan veri sorgulay\u0131n<\/code><\/pre>\n<h3>Eski Veri Dizinini Kald\u0131rma<\/h3>\n<p>PostgreSQL servisi yeni konumdan ba\u015far\u0131yla \u00e7al\u0131\u015f\u0131yor ve t\u00fcm verilerinizin eri\u015filebilir oldu\u011funu do\u011frulad\u0131ktan sonra, eski veri dizinini g\u00fcvenli bir \u015fekilde kald\u0131rabilirsiniz. <strong>Bu ad\u0131m\u0131, yeni sistemin birka\u00e7 g\u00fcn veya hafta boyunca sorunsuz \u00e7al\u0131\u015ft\u0131\u011f\u0131ndan emin olmadan yapmaman\u0131z \u015fiddetle tavsiye edilir.<\/strong> Eski dizini <code>main_old<\/code> olarak yeniden adland\u0131rm\u0131\u015ft\u0131k, \u015fimdi onu silebiliriz.<\/p>\n<pre><code class=\"language-bash\">sudo rm -rf \/var\/lib\/postgresql\/10\/main_old<\/code><\/pre>\n<p>Bu komutu \u00e7al\u0131\u015ft\u0131rmadan \u00f6nce, yedeklerinizin g\u00fcncel oldu\u011fundan ve yeni sistemin kararl\u0131 \u00e7al\u0131\u015ft\u0131\u011f\u0131ndan <em>kesinlikle<\/em> emin olun. Bu komut geri al\u0131namaz.<\/p>\n<h3>S\u0131k Kar\u015f\u0131la\u015f\u0131lan Sorunlar ve \u00c7\u00f6z\u00fcmleri<\/h3>\n<p>Veri dizinini ta\u015f\u0131ma i\u015flemi s\u0131ras\u0131nda veya sonras\u0131nda baz\u0131 sorunlarla kar\u015f\u0131la\u015fmak m\u00fcmk\u00fcnd\u00fcr. \u0130\u015fte en yayg\u0131n sorunlar ve bunlar\u0131n \u00e7\u00f6z\u00fcmleri:<\/p>\n<h4>\u0130zin Hatalar\u0131<\/h4>\n<p><strong>Belirti:<\/strong> PostgreSQL servisi ba\u015flamaz ve loglarda <code>FATAL: could not open directory \"...\" Permission denied<\/code> veya <code>FATAL: data directory \"\/...\" has wrong ownership<\/code> gibi mesajlar g\u00f6r\u00fcn\u00fcr.<br \/>\n<strong>Neden:<\/strong> Yeni veri dizini veya i\u00e7indeki dosyalar <code>postgres<\/code> kullan\u0131c\u0131s\u0131 ve grubuna ait de\u011fildir veya do\u011fru izinlere sahip de\u011fildir.<br \/>\n<strong>\u00c7\u00f6z\u00fcm:<\/strong> Yeni veri dizininin sahipli\u011fini ve izinlerini do\u011fru \u015fekilde ayarlay\u0131n.<\/p>\n<pre><code class=\"language-bash\">sudo chown -R postgres:postgres \/mnt\/new_disk\/postgresql\/10\/main\nsudo chmod -R 0700 \/mnt\/new_disk\/postgresql\/10\/main<\/code><\/pre>\n<h4>Yap\u0131land\u0131rma Dosyas\u0131 Hatalar\u0131<\/h4>\n<p><strong>Belirti:<\/strong> PostgreSQL servisi ba\u015flamaz ve loglarda <code>FATAL: unrecognized configuration parameter \"data_directory\"<\/code> veya <code>FATAL: multiple data_directory specifications<\/code> gibi mesajlar g\u00f6r\u00fcn\u00fcr.<br \/>\n<strong>Neden:<\/strong> <code>postgresql.conf<\/code> dosyas\u0131nda <code>data_directory<\/code> parametresi yanl\u0131\u015f yaz\u0131lm\u0131\u015f, iki kez tan\u0131mlanm\u0131\u015f veya yorum sat\u0131r\u0131 olarak b\u0131rak\u0131lm\u0131\u015ft\u0131r.<br \/>\n<strong>\u00c7\u00f6z\u00fcm:<\/strong> <code>postgresql.conf<\/code> dosyas\u0131n\u0131 dikkatlice kontrol edin. <code>data_directory<\/code> parametresinin do\u011fru yaz\u0131ld\u0131\u011f\u0131ndan, yaln\u0131zca bir kez tan\u0131mland\u0131\u011f\u0131ndan ve ba\u015f\u0131nda <code>#<\/code> i\u015fareti olmad\u0131\u011f\u0131ndan emin olun.<\/p>\n<h4>Disk Alan\u0131 Yetersizli\u011fi<\/h4>\n<p><strong>Belirti:<\/strong> <code>rsync<\/code> komutu s\u0131ras\u0131nda veya PostgreSQL servisi ba\u015flat\u0131l\u0131rken disk alan\u0131 yetersizli\u011fi ile ilgili hatalar.<br \/>\n<strong>Neden:<\/strong> Yeni veri dizini i\u00e7in ayr\u0131lan disk b\u00f6l\u00fcm\u00fcnde yeterli bo\u015f alan yoktur.<br \/>\n<strong>\u00c7\u00f6z\u00fcm:<\/strong> Ta\u015f\u0131ma i\u015flemine ba\u015flamadan \u00f6nce <code>df -h<\/code> komutuyla hedef disk b\u00f6l\u00fcm\u00fcndeki bo\u015f alan\u0131 kontrol edin. Gerekirse daha b\u00fcy\u00fck bir disk b\u00f6l\u00fcm\u00fc haz\u0131rlay\u0131n veya mevcut b\u00f6l\u00fcm\u00fc geni\u015fletin.<\/p>\n<h4>PostgreSQL Ba\u015flat\u0131lam\u0131yor<\/h4>\n<p><strong>Belirti:<\/strong> <code>sudo systemctl start postgresql<\/code> komutu ba\u015far\u0131s\u0131z olur ve <code>sudo systemctl status postgresql<\/code> \u00e7\u0131kt\u0131s\u0131nda hatalar g\u00f6r\u00fcn\u00fcr.<br \/>\n<strong>Neden:<\/strong> Genellikle izin hatalar\u0131, yap\u0131land\u0131rma hatalar\u0131 veya yeni veri dizinindeki bozuk dosyalar nedeniyle olu\u015fur.<br \/>\n<strong>\u00c7\u00f6z\u00fcm:<\/strong><br \/>\n*   <strong>Loglar\u0131 kontrol edin:<\/strong> <code>sudo journalctl -u postgresql<\/code> veya <code>\/var\/log\/postgresql\/<\/code> alt\u0131ndaki log dosyalar\u0131n\u0131 dikkatlice inceleyin. Hatan\u0131n nedenini genellikle burada bulabilirsiniz.<br \/>\n*   <strong>\u0130zinleri ve sahipli\u011fi kontrol edin:<\/strong> Yukar\u0131daki izin hatalar\u0131 b\u00f6l\u00fcm\u00fcndeki ad\u0131mlar\u0131 tekrarlay\u0131n.<br \/>\n*   <strong><code>postgresql.conf<\/code> dosyas\u0131n\u0131 kontrol edin:<\/strong> <code>data_directory<\/code> parametresinin do\u011fru ayarland\u0131\u011f\u0131ndan emin olun.<br \/>\n*   <strong>Yedekten geri y\u00fckleme:<\/strong> E\u011fer hi\u00e7bir \u00e7\u00f6z\u00fcm i\u015fe yaramazsa ve loglar net bir \u00e7\u00f6z\u00fcm sunmazsa, fiziksel veya mant\u0131ksal yedeklerinizden geri y\u00fckleme yapmay\u0131 d\u00fc\u015f\u00fcnebilirsiniz.<\/p>\n<h4>Ba\u011flant\u0131 Sorunlar\u0131<\/h4>\n<p><strong>Belirti:<\/strong> PostgreSQL servisi \u00e7al\u0131\u015f\u0131yor gibi g\u00f6r\u00fcnse de, uygulamalar veya <code>psql<\/code> arac\u0131 veritaban\u0131na ba\u011flanam\u0131yor.<br \/>\n<strong>Neden:<\/strong> Genellikle <code>pg_hba.conf<\/code> dosyas\u0131ndaki yanl\u0131\u015f yap\u0131land\u0131rma, g\u00fcvenlik duvar\u0131 kurallar\u0131 veya a\u011f ayarlar\u0131 nedeniyle olu\u015fur.<br \/>\n<strong>\u00c7\u00f6z\u00fcm:<\/strong><br \/>\n*   <strong><code>pg_hba.conf<\/code> kontrol\u00fc:<\/strong> Bu dosya, istemci ba\u011flant\u0131lar\u0131na izin veren kurallar\u0131 i\u00e7erir. Dosyan\u0131n (<code>\/etc\/postgresql\/10\/main\/pg_hba.conf<\/code>) do\u011fru yap\u0131land\u0131r\u0131ld\u0131\u011f\u0131ndan emin olun.<br \/>\n*   <strong>G\u00fcvenlik duvar\u0131:<\/strong> Ubuntu&#8217;da <code>ufw<\/code> gibi bir g\u00fcvenlik duvar\u0131 kullan\u0131yorsan\u0131z, PostgreSQL&#8217;in varsay\u0131lan portu olan 5432&#8217;nin gelen ba\u011flant\u0131lara a\u00e7\u0131k oldu\u011fundan emin olun.<\/p>\n<pre><code class=\"language-bash\">sudo ufw status\n    sudo ufw allow 5432\/tcp<\/code><\/pre>\n<p><em>   <strong>PostgreSQL dinleme adresi:<\/strong> <code>postgresql.conf<\/code> dosyas\u0131ndaki <code>listen_addresses<\/code> parametresinin do\u011fru ayarland\u0131\u011f\u0131ndan emin olun. T\u00fcm aray\u00fczlerden dinlemek i\u00e7in <code>'<\/em>'<\/code> olarak ayarlanabilir.<\/p>\n<h3>Sonu\u00e7<\/h3>\n<p>PostgreSQL veri dizinini Ubuntu 18.04 \u00fczerinde yeni bir konuma ta\u015f\u0131mak, dikkatli planlama ve ad\u0131m ad\u0131m uygulama gerektiren kritik bir sistem y\u00f6netimi g\u00f6revidir. Bu rehberde a\u00e7\u0131klanan ad\u0131mlar\u0131 izleyerek, veri kayb\u0131 riskini en aza indirerek bu i\u015flemi g\u00fcvenli ve ba\u015far\u0131l\u0131 bir \u015fekilde ger\u00e7ekle\u015ftirebilirsiniz.<\/p>\n<p>Unutulmamas\u0131 gereken en \u00f6nemli ad\u0131mlar:<br \/>\n1.  <strong>Kapsaml\u0131 Yedekleme:<\/strong> Herhangi bir de\u011fi\u015fikli\u011fe ba\u015flamadan \u00f6nce verilerinizin tam yede\u011fini ald\u0131\u011f\u0131n\u0131zdan emin olun.<br \/>\n2.  <strong>Do\u011fru \u0130zinler:<\/strong> Yeni veri dizininin <code>postgres<\/code> kullan\u0131c\u0131s\u0131na ve grubuna ait oldu\u011fundan ve <code>0700<\/code> izinlerine sahip oldu\u011fundan emin olun.<br \/>\n3.  <strong>Yap\u0131land\u0131rma G\u00fcncellemesi:<\/strong> <code>postgresql.conf<\/code> dosyas\u0131ndaki <code>data_directory<\/code> parametresini yeni yola i\u015faret edecek \u015fekilde do\u011fru bir \u015fekilde g\u00fcncelleyin.<br \/>\n4.  <strong>Do\u011frulama:<\/strong> PostgreSQL servisini ba\u015flatt\u0131ktan sonra, loglar\u0131 kontrol edin ve t\u00fcm veritaban\u0131 i\u015flemlerinin beklendi\u011fi gibi \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 do\u011frulay\u0131n.<\/p>\n<p>Veri dizinini ta\u015f\u0131mak, disk alan\u0131 y\u00f6netimi, performans iyile\u015ftirmeleri ve genel sistem esnekli\u011fi a\u00e7\u0131s\u0131ndan \u00f6nemli faydalar sa\u011flayabilir. Bu rehberdeki bilgileri kullanarak, PostgreSQL altyap\u0131n\u0131z\u0131 daha verimli ve g\u00fcvenli bir \u015fekilde y\u00f6netebilirsiniz.<\/body><\/p>\n","protected":false},"excerpt":{"rendered":"PostgreSQL Veri Dizinini Ubuntu 18.04&#8217;te Yeni Bir Konuma Ta\u015f\u0131ma\nGiri\u015f\nPostgreSQL, a\u00e7\u0131k kaynakl\u0131 ve g\u00fc\u00e7l\u00fc bir ili\u015fkisel veritaban\u0131 y\u00f6netim","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[1468],"tags":[],"class_list":{"0":"post-30729","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-ubuntu","7":"cs-entry","8":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>PostgreSQL Veri Dizinini Ubuntu 18.04&#039;te Yeni Bir Konuma Ta\u015f\u0131ma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"PostgreSQL Veri Dizinini Ubuntu 18.04&#039;te Yeni Bir Konuma Ta\u015f\u0131ma\" \/>\n<meta property=\"og:description\" content=\"PostgreSQL Veri Dizinini Ubuntu 18.04&#039;te Yeni Bir Konuma Ta\u015f\u0131ma Giri\u015f PostgreSQL, a\u00e7\u0131k kaynakl\u0131 ve g\u00fc\u00e7l\u00fc bir ili\u015fkisel veritaban\u0131 y\u00f6netim\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2025-10-01T06:41:00+00:00\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"PostgreSQL Veri Dizinini Ubuntu 18.04&#8217;te Yeni Bir Konuma Ta\u015f\u0131ma\",\"datePublished\":\"2025-10-01T06:41:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/\"},\"wordCount\":2244,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"articleSection\":[\"Ubuntu\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/#respond\"]}],\"copyrightYear\":\"2025\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/\",\"name\":\"PostgreSQL Veri Dizinini Ubuntu 18.04'te Yeni Bir Konuma Ta\u015f\u0131ma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"datePublished\":\"2025-10-01T06:41:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"PostgreSQL Veri Dizinini Ubuntu 18.04&#8217;te Yeni Bir Konuma Ta\u015f\u0131ma\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"PostgreSQL Veri Dizinini Ubuntu 18.04'te Yeni Bir Konuma Ta\u015f\u0131ma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","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:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/","og_locale":"tr_TR","og_type":"article","og_title":"PostgreSQL Veri Dizinini Ubuntu 18.04'te Yeni Bir Konuma Ta\u015f\u0131ma","og_description":"PostgreSQL Veri Dizinini Ubuntu 18.04'te Yeni Bir Konuma Ta\u015f\u0131ma Giri\u015f PostgreSQL, a\u00e7\u0131k kaynakl\u0131 ve g\u00fc\u00e7l\u00fc bir ili\u015fkisel veritaban\u0131 y\u00f6netim","og_url":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2025-10-01T06:41:00+00:00","author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"13 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"PostgreSQL Veri Dizinini Ubuntu 18.04&#8217;te Yeni Bir Konuma Ta\u015f\u0131ma","datePublished":"2025-10-01T06:41:00+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/"},"wordCount":2244,"commentCount":0,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"articleSection":["Ubuntu"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/#respond"]}],"copyrightYear":"2025","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/","url":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/","name":"PostgreSQL Veri Dizinini Ubuntu 18.04'te Yeni Bir Konuma Ta\u015f\u0131ma - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"datePublished":"2025-10-01T06:41:00+00:00","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/postgresql-veri-dizinini-ubuntu-18-04te-yeni-bir-konuma-tasima\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"PostgreSQL Veri Dizinini Ubuntu 18.04&#8217;te Yeni Bir Konuma Ta\u015f\u0131ma"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/30729","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=30729"}],"version-history":[{"count":1,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/30729\/revisions"}],"predecessor-version":[{"id":30730,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/30729\/revisions\/30730"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=30729"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=30729"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=30729"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}