{"id":106628,"date":"2023-02-03T12:48:16","date_gmt":"2023-02-03T10:48:16","guid":{"rendered":"https:\/\/prohoster.info\/?p=106628"},"modified":"2023-02-03T21:50:34","modified_gmt":"2023-02-03T19:50:34","slug":"vypusk-postgres-pro-enterprise-15-1-1","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/vypusk-postgres-pro-enterprise-15-1-1","title":{"rendered":"L\u00ebshimi i Postgres Pro Enterprise 15.1.1","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Kompania Postgres Professional shpalli disponueshm\u00ebrin\u00eb e DB-s\u00eb pron\u00ebsore Pro Enterprise 15.1.1, e cila \u00ebsht\u00eb e bazuar n\u00eb kodin e PostgreSQL 15 dhe p\u00ebrfshin mund\u00ebsi t\u00eb reja, t\u00eb cilat jan\u00eb p\u00ebrcjell\u00eb p\u00ebr integrim n\u00eb deg\u00ebt e ardhshme t\u00eb PostgreSQL, si dhe nj\u00eb s\u00ebr\u00eb shtesash specifike p\u00ebr sisteme me ngarkes\u00eb t\u00eb lart\u00eb. DB-ja mb\u00ebshtet replikimin multimaster, kompresimin e t\u00eb dh\u00ebnave n\u00eb nivel blloku, kopjimin incremental, nj\u00eb pooler lidhjesh t\u00eb integruar, segmentimin e optimizuar t\u00eb tabelave, k\u00ebrkimin n\u00eb m\u00ebnyr\u00eb t\u00eb plot\u00eb t\u00eb p\u00ebrmir\u00ebsuar, kompilim automatik dhe planifikimin e k\u00ebrkesave. <\/p>\n
T\u00eb rejat kryesore: <\/p>\n
\n
Mb\u00ebshtetje p\u00ebr paketat (Packages, grupe funksionesh dhe procedurash) n\u00eb stilin Oracle p\u00ebr t\u00eb thjeshtuar migrimin e kodit n\u00eb gjuh\u00ebn PL\/SQL gjat\u00eb kalimit nga Oracle n\u00eb Postgres. Nga nj\u00eb k\u00ebndv\u00ebshtrim teknik, mb\u00ebshtetja e paketave paraqet nj\u00eb zgjerim t\u00eb sintaks\u00ebs s\u00eb gjuh\u00ebs PL\/pgSQL (me disa p\u00ebrmir\u00ebsime t\u00eb vogla n\u00eb b\u00ebrthamat e DB-s\u00eb), duke mund\u00ebsuar nj\u00eb ekuivalent funksional t\u00eb paketave Oracle dhe duke introduktuar nj\u00eb s\u00ebr\u00eb komandash shtes\u00eb p\u00ebr pun\u00eb me to.\n
Kalim i parametrave pozicional\u00eb n\u00eb skript n\u00eb psql, q\u00eb lejon krijimin e skripteve shell m\u00eb fleksib\u00ebl dhe universale p\u00ebr pun\u00eb me DB-n\u00eb. P\u00ebrve\u00e7 p\u00ebrfitimeve t\u00eb qarta n\u00eb projektimin e skripteve t\u00eb reja, kjo do ta thjeshtoj\u00eb adaptimin e skripteve SQL gjat\u00eb migrimit nga DB-ja Oracle, ku nj\u00eb funksionalitet i till\u00eb \u00ebsht\u00eb i njohur p\u00ebr p\u00ebrdoruesin.\n
Zgjerimi pgpro_anonymizer p\u00ebr maskimin (obfuskimin) e t\u00eb dh\u00ebnave, duke garantuar sigurin\u00eb e ruajtjes s\u00eb t\u00eb dh\u00ebnave n\u00eb sistemet e nivelit korporativ, si dhe krijimin e kopjeve t\u00eb anonimizuara t\u00eb DB-s\u00eb p\u00ebr p\u00ebrdorim n\u00eb mjedise testimi dhe zhvillimi.\n
N\u00eb baz\u00eb t\u00eb pg_probackup, \u00ebsht\u00eb zhvilluar nj\u00eb mjet i ri kopjimi p\u00ebr mjedise korporative pg_probackup Enterprise, q\u00eb p\u00ebrfshin: nj\u00eb n\u00ebnstruktur\u00eb t\u00eb re hyrjeje-dalite q\u00eb rrit performanc\u00ebn; mb\u00ebshtetje p\u00ebr protokollin S3 p\u00ebr ruajtjen e t\u00eb dh\u00ebnave n\u00eb sistemet cloud; kompatibilitet CFS (kompresion t\u00eb dh\u00ebnash) me mekanizmin e krijimit t\u00eb kopjimeve incrementale; mb\u00ebshtetje p\u00ebr t\u00eb gjitha modet e krijimit t\u00eb kopjimeve (DELTA, PAGE dhe PTRACK); mb\u00ebshtetje p\u00ebr algoritmet e kompresimit LZ4 dhe ZSTD.\n
Funksione t\u00eb reja t\u00eb p\u00ebrpunimit JSON nga standardi SQL:2016, n\u00eb shtes\u00eb t\u00eb gjuh\u00ebs JSONPATH t\u00eb zbatuar m\u00eb par\u00eb.\n
Gati p\u00ebr t\u00eb punuar me zgjerimin TimescaleDB (pasi zhvilluesi i saj e shpalli zyrtarisht mb\u00ebshtetje p\u00ebr PostgreSQL 15).\n
Shtimi i modulit tds_fdw p\u00ebr t\u00eb thjeshtuar migrimin nga MS SQL Server.\n