{"id":20356,"date":"2022-06-10T05:56:43","date_gmt":"2022-06-10T05:56:43","guid":{"rendered":"http:\/\/dev.profelis.net\/?p=20356"},"modified":"2023-02-01T10:57:58","modified_gmt":"2023-02-01T07:57:58","slug":"enterprisedb-postgrese-genel-bakis","status":"publish","type":"post","link":"https:\/\/profelis.com.tr\/en\/2022\/06\/10\/enterprisedb-postgrese-genel-bakis\/","title":{"rendered":"EnterpriseDB Postgres\u2019e Genel Bak\u0131\u015f"},"content":{"rendered":"

EnterpriseDB Postgres Platform, a\u00e7\u0131k kaynakl\u0131 PostgreSQL temelli veritaban\u0131 ile y\u00f6netim, entegrasyon, g\u00f6\u00e7 gibi konularda kendi geli\u015ftirdi\u011fi ara\u00e7lar\u0131 birle\u015ftiren, verdi\u011fi e\u011fitimler ve 7\/24 destek ile kurumsal d\u00fczeyde bir veri y\u00f6netim platformudur.<\/span><\/p>\n

EnterpriseDB Postgres Advanced Server<\/h2>\n

EnterpriseDB\u2019nin geli\u015ftirdi\u011fi ve deste\u011fini verdi\u011fi<\/span> Postgres Advanced Server (PAS) veritaban\u0131n\u0131n en g\u00fc\u00e7l\u00fc de\u011fer \u00f6nermelerinden birisi Oracle\u00ae veritaban\u0131 ile uyumlulu\u011fudur. <\/b><\/p>\n

Postgres platformu, Oracle veritaban\u0131 uyumlulu\u011fu ile a\u00e7\u0131k kayna\u011f\u0131n b\u00fct\u00e7e tasarrufunu birle\u015ftirir. <\/span>Postgres Advanced Server kullan\u0131larak fiziksel\/sanal\/bulut ortam\u0131nda yeni proje geli\u015ftirilebilir veya var olan veritabanlar\u0131n\u0131 Postgres’e g\u00f6\u00e7 ettirilebilir. Ayr\u0131ca EnterpriseDB’nin kurumsal ara\u00e7lar\u0131n\u0131n avantajlar\u0131ndan yararlan\u0131labilir ve EnterpriseDB’den destek al\u0131nabilir.<\/span><\/p>\n

Migration Toolkit<\/h2>\n

EnterpriseDB ara\u00e7lar\u0131ndan biri olan Migration Toolkit ile farkl\u0131 veritabanlar\u0131ndan (MySQL, Sybase, Oracle, SQL Server vb.) Postgres\u2019e canl\u0131 veya \u00e7evrimd\u0131\u015f\u0131 olarak g\u00f6\u00e7 yap\u0131labilir. <\/span>Veritaban\u0131 nesne tan\u0131mlamalar\u0131n\u0131n (tablo, g\u00f6r\u00fcn\u00fcm, fonksiyon, paket gibi) olu\u015fturulmas\u0131 ve verilerin aktar\u0131lmas\u0131 tek bir i\u015flem ile ger\u00e7ekle\u015ftirilir. Oracle uyumlulu\u011fu ve di\u011fer veritabanlar\u0131ndan \u015fema yap\u0131lar\u0131n\u0131n Postgres\u2019e uygun s\u00f6z diziminde yeniden \u00fcretilmesi de g\u00f6\u00e7 s\u00fcrecini kabul edilebilir derecede kolayla\u015ft\u0131r\u0131r.<\/b><\/p>\n

Postgres Enterprise Manager<\/h2>\n

PAS\u2019\u0131n s\u00f6z diziminin Oracle veritaban\u0131 ile uyumlu olmas\u0131, Postgres Advanced Server ge\u00e7i\u015fi sonras\u0131nda <\/span>veritaban\u0131 y\u00f6neticilerinin ve geli\u015ftiricilerinin yeni ortama uyum s\u00fcresini k\u0131saltarak Postgres Advanced Server \u00fczerinde i\u015flemlerini devam ettirebilmeleri sa\u011flar.<\/b> Postgres Enterprise Manager (PEM) arac\u0131 ile izleme ve y\u00f6netim i\u015flemleri de web ara y\u00fcz\u00fc \u00fczerinden kolayl\u0131kla ger\u00e7ekle\u015ftirilebilir.<\/span><\/p>\n

EDB Postgres Failover Manager<\/h2>\n

EnterpriseDB taraf\u0131ndan geli\u015ftirilen ve kullan\u0131c\u0131lara tek bir pakette sunulan Postgres Platformu\u2019nun \u00f6nemli ara\u00e7lar\u0131ndan biri de EDB Postgres Failover Manager<\/b>‘d\u0131r. <\/span>EDB Postgres Failover Manager <\/b>arac\u0131 sayesinde master-slave ili\u015fkisi kurulan veritaban\u0131 k\u00fcmesinin etkin y\u00f6netimi sa\u011flanarak olas\u0131 felaket senaryolar\u0131nda kesinti s\u00fcresi minimuma indirebilir. <\/span>Bart* <\/b>arac\u0131 ile veritaban\u0131 yedeklerinin al\u0131nmas\u0131 ve yedeklerin y\u00f6netimi otomatize edilip, art\u0131ml\u0131 yedekleme (incremental backup) \u00f6zelli\u011fi ile son yedek sonras\u0131nda olu\u015fan de\u011fi\u015fiklikler yedeklenerek b\u00fcy\u00fck veritabanlar\u0131n\u0131n yedeklerinin y\u00fcksek disk alan\u0131 kullan\u0131m\u0131n\u0131n \u00f6n\u00fcne ge\u00e7ilir. <\/span>Index Advisor<\/b> arac\u0131, verilen i\u015f y\u00fck\u00fcnde hangi kolonlar\u0131n indekslenmesi gerekti\u011finin karar verilmesi konusunda veritaban\u0131 y\u00f6neticilerine yard\u0131mc\u0131 olur.<\/span><\/p>\n

Yukar\u0131da bahsedilen t\u00fcm ara\u00e7lara ula\u015fmak i\u00e7in lisans al\u0131m\u0131 ve sonras\u0131nda lisans yenileme maliyeti olmadan, <\/span>abonelik sistemi ile hizmet veren EnterpriseDB, geleneksel veritabanlar\u0131 ile k\u0131yasland\u0131\u011f\u0131nda d\u00fc\u015f\u00fck maliyetli olmas\u0131 ile g\u00f6ze \u00e7arp\u0131yor. <\/b>EnterpriseDB, a\u00e7\u0131k kaynak kodlu yaz\u0131l\u0131m ile birlikte kurumsal d\u00fczeyde bir platform kurarak, veritaban\u0131 performans\u0131n\u0131 geli\u015ftirirken, buna ayr\u0131lan b\u00fct\u00e7elerini k\u0131smak isteyen firmalar aras\u0131nda y\u00fckselen bir trende sergiliyor.<\/span><\/p>\n

*EDB, Bart arac\u0131n\u0131n tam deste\u011finin 5 Kas\u0131m 2023 tarihinde bitece\u011fini a\u00e7\u0131klam\u0131\u015ft\u0131r.
\nBarman ve pgBackRest art\u0131k EDB’nin \u00f6nerilen yedekleme ve kurtarma ara\u00e7lar\u0131d\u0131r.<\/p>\n

EnterpriseDB hakk\u0131nda daha fazla bilgi i\u00e7in t\u0131klay\u0131n<\/a>.<\/p>","protected":false},"excerpt":{"rendered":"

EnterpriseDB Postgres Platform, a\u00e7\u0131k kaynakl\u0131 PostgreSQL temelli veritaban\u0131 ile y\u00f6netim, entegrasyon, g\u00f6\u00e7 gibi konularda kendi geli\u015ftirdi\u011fi ara\u00e7lar\u0131 birle\u015ftiren, verdi\u011fi e\u011fitimler ve 7\/24 destek ile kurumsal d\u00fczeyde bir veri y\u00f6netim platformudur. EnterpriseDB Postgres Advanced Server EnterpriseDB\u2019nin geli\u015ftirdi\u011fi ve deste\u011fini verdi\u011fi Postgres…<\/p>","protected":false},"author":10,"featured_media":22104,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[75,45],"tags":[48,60],"class_list":["post-20356","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-postgresql","category-yazi","tag-enterprisedb","tag-postgresql"],"_links":{"self":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/20356","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/comments?post=20356"}],"version-history":[{"count":0,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/posts\/20356\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media\/22104"}],"wp:attachment":[{"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/media?parent=20356"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/categories?post=20356"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/profelis.com.tr\/en\/wp-json\/wp\/v2\/tags?post=20356"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}