{"id":916,"date":"2024-07-24T11:39:43","date_gmt":"2024-07-24T08:39:43","guid":{"rendered":"https:\/\/kamp.linux.org.tr\/2024-yaz\/?page_id=916"},"modified":"2024-07-24T21:31:26","modified_gmt":"2024-07-24T18:31:26","slug":"postgresqlin-yuksek-erisilebilirligi-ha","status":"publish","type":"page","link":"https:\/\/kamp.linux.org.tr\/2024-yaz\/kurslar\/postgresqlin-yuksek-erisilebilirligi-ha\/","title":{"rendered":"PostgreSQL&#8217;in Y\u00fcksek Eri\u015filebilirli\u011fi (HA)"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><strong>E\u011fitmenler:<\/strong> <a href=\"https:\/\/kamp.linux.org.tr\/2024-yaz\/egitmenler\/burak-ergen\/\">Burak Ergen<\/a>, <a href=\"https:\/\/kamp.linux.org.tr\/2024-yaz\/egitmenler\/enez-mutluoglu\/\">Enez Mutluo\u011flu<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Kat\u0131l\u0131mc\u0131lar i\u00e7in \u00f6n-\u015fartlar:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/kamp.linux.org.tr\/2024-yaz\/kurslar\/gnu-linux-sistem-yonetimi-1-duzey\/\">GNU\/Linux Sistem Y\u00f6netimi 1. D\u00fczey<\/a> konular\u0131na hakim olmak<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>E\u011fitim \u0130\u00e7eri\u011fi:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>PostgreSQL Kurulumu<\/li>\n\n\n\n<li>Sunucuyu Ba\u015flatma ve \u00c7al\u0131\u015fmas\u0131\n<ul class=\"wp-block-list\">\n<li>PostgreSQL Cluster Mimarisi<\/li>\n\n\n\n<li>PostgreSQL Cluster Olu\u015fturma<\/li>\n\n\n\n<li>PostgreSQL Komut Sat\u0131r\u0131 Ara\u00e7lar\u0131<\/li>\n\n\n\n<li>Veritaban\u0131 Cluster Ba\u015flatma (initdb, pg_ctl)<\/li>\n\n\n\n<li>Komut Sat\u0131r\u0131ndan Veritaban\u0131 \u0130\u015flemleri (createdb,dropdb, psql, pgdump)<\/li>\n\n\n\n<li>Kurulum Bilgilerini Sorgulama (pg_config)<\/li>\n\n\n\n<li>SSH T\u00fcneli \u0130le G\u00fcvenli TCP\/IP Ba\u011flant\u0131s\u0131<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>PostgreSQL Sunucu Yap\u0131land\u0131rmas\u0131<\/li>\n\n\n\n<li>Sunucu Performans Ayarlar\u0131\n<ul class=\"wp-block-list\">\n<li>Ba\u011flant\u0131 ve Yetkilendirme Ayarlar\u0131<\/li>\n\n\n\n<li>Dosya Konum Ayarlar\u0131<\/li>\n\n\n\n<li>Write Ahead Log Ayarlar\u0131<\/li>\n\n\n\n<li>Yedekleme ve Replikasyon Ayarlar\u0131<\/li>\n\n\n\n<li>Hata Raporlama Ayarlar\u0131<\/li>\n\n\n\n<li>\u00c7al\u0131\u015fma Zaman\u0131 \u0130statistik Ayarlar\u0131<\/li>\n\n\n\n<li>\u0130stemci Ba\u011flant\u0131 Ayarlar\u0131<\/li>\n\n\n\n<li>Veritaban\u0131 Rolleri<\/li>\n\n\n\n<li>Rol Olu\u015fturma ve Yetkilendirme<\/li>\n\n\n\n<li>Rol Kimlik Do\u011frulama Y\u00f6ntemleri<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Veritaban\u0131 Y\u00f6netimi\n<ul class=\"wp-block-list\">\n<li>Veritaban\u0131 Olu\u015fturma<\/li>\n\n\n\n<li>\u015eablon Veritaban\u0131 Kullan\u0131m\u0131<\/li>\n\n\n\n<li>Veritaban\u0131 Ayarlar\u0131<\/li>\n\n\n\n<li>Log Dosyas\u0131 Bak\u0131m\u0131<\/li>\n\n\n\n<li>Yedekleme ve Geri Y\u00fckleme<\/li>\n\n\n\n<li>SQL Dump \u0130\u015flemi<\/li>\n\n\n\n<li>Dosya Sistemi D\u00fczeyinde Yedekleme<\/li>\n\n\n\n<li>Devaml\u0131 Ar\u015fivleme ve Ar\u015fivden Geri Y\u00fckleme (Point-in-Time Recovery)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Y\u00fcksek Kullan\u0131labilirlik, Y\u00fck Dengeleme ve Replikasyon\n<ul class=\"wp-block-list\">\n<li>Farkl\u0131 \u00c7\u00f6z\u00fcmlerin Kar\u015f\u0131la\u015ft\u0131r\u0131lmas\u0131<\/li>\n\n\n\n<li>Standby Sunucular<\/li>\n\n\n\n<li>Standby Sunucu Ayarlar\u0131<\/li>\n\n\n\n<li>Streaming Replikasyon<\/li>\n\n\n\n<li>Cascading Replikasyon<\/li>\n\n\n\n<li>Senkron Replikasyon<\/li>\n\n\n\n<li>Asenkron Replikasyon<\/li>\n\n\n\n<li>WAL Ar\u015fivleme ile Standby<\/li>\n\n\n\n<li>Failover Kavram\u0131<\/li>\n\n\n\n<li>Hot Standby Kavram\u0131<\/li>\n\n\n\n<li>Veri Kurtarma Yap\u0131land\u0131rmas\u0131<\/li>\n\n\n\n<li>Ar\u015fivden Kurtarma Ayarlar\u0131<\/li>\n\n\n\n<li>Kurtarma Hedefleme Ayarlar\u0131<\/li>\n\n\n\n<li>Standby Sunucu Ayarlar\u0131<\/li>\n\n\n\n<li>Veritaban\u0131 Etkinli\u011fi G\u00f6zlemleme ve Takibi<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li>Monitoring\n<ul class=\"wp-block-list\">\n<li>Dinamik \u0130zleme<\/li>\n\n\n\n<li>Standart Unix Ara\u00e7lar\u0131 ile \u0130zleme<\/li>\n\n\n\n<li>\u0130statistik Toplama<\/li>\n\n\n\n<li>Kilitlemeleri G\u00f6r\u00fcnt\u00fcleme<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>E\u011fitmenler: Burak Ergen, Enez Mutluo\u011flu Kat\u0131l\u0131mc\u0131lar i\u00e7in \u00f6n-\u015fartlar: E\u011fitim \u0130\u00e7eri\u011fi:<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":11,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-916","page","type-page","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/pages\/916","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/comments?post=916"}],"version-history":[{"count":3,"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/pages\/916\/revisions"}],"predecessor-version":[{"id":1010,"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/pages\/916\/revisions\/1010"}],"up":[{"embeddable":true,"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/pages\/11"}],"wp:attachment":[{"href":"https:\/\/kamp.linux.org.tr\/2024-yaz\/wp-json\/wp\/v2\/media?parent=916"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}