ProHoster > Блог > ozi ịntanetị > Mwepụta Postgres Pro Enterprise 15.1.1

Mwepụta Postgres Pro Enterprise 15.1.1

Ọkachamara Postgres ekwupụtala na enwere Pro Enterprise 15.1.1 DBMS nke ya, dabere na ntọala koodu PostgreSQL 15 yana gụnyere atụmatụ ọhụrụ ebufegoro maka ntinye n'ime ngalaba PostgreSQL ndị a, yana ọtụtụ mgbakwunye akọwapụtara maka elu- usoro ibu ibu. DBMS na-akwado ntugharị ọtụtụ nna ukwu, mkpakọ data ọkwa-ọkwa, nkwado ndabere agbakwunyere, ihe nrụnye njikọ arụnyere, nkewa tebụl kachasị mma, nchọ ederede zuru oke, nchịkọta ajụjụ akpaka na nhazi oge.

Isi ihe ọhụrụ:

  • Nkwado maka ngwugwu ụdị Oracle (Ngwugwu, nhazi ọrụ na usoro) iji mee ka njem nke koodu PL/SQL dị mfe mgbe ị na-akwaga na Oracle na Postgres. Site n'echiche teknụzụ, nkwado ngwugwu bụ ndọtị nke syntax asụsụ PL / pgSQL (yana obere mgbakwunye na isi DBMS), n'ihi nke etinyere analog na-arụ ọrụ nke ngwugwu Oracle yana ewebata ọtụtụ iwu ndị ọzọ ka ọ rụọ ọrụ. ha na ha.
  • Na-agafe paramita ọnọdụ na edemede dị na psql, nke na-enye gị ohere ịmepụta scripts shea ndị ọzọ na-agbanwe agbanwe ma na-agbanwe agbanwe maka ịrụ ọrụ na DBMS. Na mgbakwunye na uru doro anya mgbe ị na-emepụta script ọhụrụ, nke a ga-eme ka mmegharị nke scripts SQL dị mfe mgbe ị na-akwaga na Oracle DBMS, ebe ọrụ dị otú ahụ maara onye ọrụ ahụ.
  • Mgbatị pgpro_anonymizer maka nkpuchi data (obfuscation), nke na-enye gị ohere iji hụ na nchekwa data na sistemu ọkwa ụlọ ọrụ, yana mepụta nnomi nchekwa data na-amaghị aha maka ojiji na gburugburu ule na mmepe.
  • Dabere na pg_probackup, e mepụtala ihe ndabere ọhụrụ maka gburugburu ụlọ ọrụ pg_probackup Enterprise, nke na-arụ ọrụ: sistemụ I / O ọhụrụ na-eme ka arụmọrụ dịkwuo mma; nkwado maka usoro S3 maka ịchekwa data na sistemụ igwe ojii; ndakọrịta nke CFS (mkpakọ data) na usoro maka ịmepụta nkwado ndabere na mpaghara; nkwado maka ụdị nkwado ndabere niile (DELTA, PAGE na PTRACK); nkwado maka LZ4 na ZSTD mkpakọ algọridim.
  • Ọrụ nhazi JSON ọhụrụ sitere na SQL: ọkọlọtọ 2016 na mgbakwunye na asụsụ JSONPATH etinyere na mbụ.
  • Dị njikere ịrụ ọrụ na mgbakwunye TimescaleDB (mgbe ọkwa ọkwa nke onye nrụpụta ya gbasara nkwado PostgreSQL 15).
  • Na-agbakwụnye modul tds_fdw iji mee ka ọpụpụ sitere na MS SQL Server dị mfe.
  • Nkwado gọọmentị maka ndị nrụpụta Elbrus.

isi: opennet.ru

Tinye a comment