{"id":104014,"date":"2022-05-13T03:36:48","date_gmt":"2022-05-13T01:36:48","guid":{"rendered":"https:\/\/prohoster.info\/blog\/novosti-interneta\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0"},"modified":"2022-05-13T03:36:48","modified_gmt":"2022-05-13T01:36:48","slug":"obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0","status":"publish","type":"post","link":"https:\/\/prohoster.info\/sq\/blog\/novosti-interneta\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0","title":{"rendered":"P\u00ebrdit\u00ebsimi i PostgreSQL p\u00ebr t\u00eb adresuar dob\u00ebsin\u00eb. L\u00ebshimi pg_ivm 1.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Jan\u00eb formuar p\u00ebrdit\u00ebsime korrigjuese p\u00ebr t\u00eb gjitha deg\u00ebt e mb\u00ebshtetura t\u00eb PostgreSQL: 14.3, 13.7, 12.11, 11.16 dhe 10.22. Deg\u00ebn 10.x po i afrohet p\u00ebrfundimit t\u00eb mb\u00ebshtetjes (p\u00ebrdit\u00ebsimet do t\u00eb formohen deri n\u00eb n\u00ebntor 2022). Lirimi i p\u00ebrdit\u00ebsimeve p\u00ebr deg\u00ebn 11.x do t\u00eb vazhdoj\u00eb deri n\u00eb n\u00ebntor 2023, 12.x \u2014 deri n\u00eb n\u00ebntor 2024, 13.x \u2014 deri n\u00eb n\u00ebntor 2025, 14.x \u2014 deri n\u00eb n\u00ebntor 2026. <\/p>\n
N\u00eb versionet e reja jan\u00eb ofruar mbi 50 korrigjime dhe \u00ebsht\u00eb adresuar dob\u00ebsia CVE-2022-1552, e cila lidhet me mund\u00ebsin\u00eb e p\u00ebrjashtimit t\u00eb izolimit t\u00eb ekzekutimit t\u00eb operacioneve me privilegje Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER dhe pg_amcheck. Nj\u00eb sulmues, i cili ka autorizimin p\u00ebr t\u00eb krijuar objekte jo t\u00eb p\u00ebrkohshme n\u00eb \u00e7do skem\u00eb ruajtjeje, mund t\u00eb arrij\u00eb t\u00eb ekzekutoj\u00eb funksione SQL t\u00eb rastit me t\u00eb drejta superadministrator nd\u00ebrsa ekzekuton operacionet e m\u00ebsip\u00ebrme me privilegje t\u00eb p\u00ebrdoruesit, t\u00eb cilat prekin objektin e sulmuesit. Po ashtu, shfryt\u00ebzimi i dob\u00ebsis\u00eb mund t\u00eb ndodh\u00eb gjat\u00eb pastrimit automatike t\u00eb baz\u00ebs n\u00eb p\u00ebrputhje me menaxherin autovacuum. <\/p>\n
N\u00eb rast t\u00eb paaft\u00ebsis\u00eb p\u00ebr t\u00eb p\u00ebrdit\u00ebsuar, si nj\u00eb m\u00ebnyr\u00eb p\u00ebr t\u00eb bllokuar problemin, mund t\u00eb \u00e7aktivizoni autovacuum dhe t\u00eb mos kryeni operacione REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW dhe CLUSTER nga nj\u00eb p\u00ebrdorues me privilegje, si dhe t\u00eb mos nisni utilitarin pg_amcheck dhe t\u00eb mos riktheni p\u00ebrmbajtjen nga nj\u00eb kopje rezerv\u00eb e krijuar nga utilitari pg_dump. Kryerja e VACUUM konsiderohet e sigurt, ashtu si aplikimi i \u00e7do operacioni komandash, n\u00ebse objektet e p\u00ebrpunuara i p\u00ebrkasin p\u00ebrdoruesve t\u00eb besuesh\u00ebm. <\/p>\n
Ndryshime t\u00eb tjera n\u00eb versionet e reja p\u00ebrfshijn\u00eb p\u00ebrmir\u00ebsimin e kodit JIT p\u00ebr pun\u00ebn me LLVM 14, lejen p\u00ebr p\u00ebrdorimin e modeleve database.schema.table n\u00eb utilitat psql, pg_dump dhe pg_amcheck, rregullimin e problemeve q\u00eb shkaktojn\u00eb d\u00ebmtimin e indekseve GiST mbi kolonat ltree, gabime n\u00eb rrumbullakimin e vlerave n\u00eb formatin epoch, t\u00eb nxjerra nga t\u00eb dh\u00ebna me tipin interval, pun\u00ebn e gabuar t\u00eb planifikuesit gjat\u00eb p\u00ebrdorimit t\u00eb k\u00ebrkesave t\u00eb larg\u00ebta asinkrone, renditjen e gabuar t\u00eb rreshtave t\u00eb tabel\u00ebs gjat\u00eb p\u00ebrdorimit t\u00eb shprehjes CLUSTER mbi indekset me \u00e7el\u00ebsa t\u00eb bazuar n\u00eb shprehje, humbjen e t\u00eb dh\u00ebnave gjat\u00eb mbylljes emergjente menj\u00ebher\u00eb pas nd\u00ebrtimit t\u00eb nj\u00eb indeksi t\u00eb renditur GiST, bllokimin e nd\u00ebrsjell\u00eb gjat\u00eb fshirjes s\u00eb indekseve t\u00eb ndara, dhe nj\u00eb situat\u00eb garuese midis operacionit DROP TABLESPACE dhe fik\u00ebsit t\u00eb gjendjes (checkpoint). <\/p>\n
P\u00ebr m\u00eb tep\u00ebr, mund t\u00eb theksohet lirimi i zgjerimit pg_ivm 1.0 me implementimin e mb\u00ebshtetjes IVM (Menaxhimi i Pamjeve Inkremetale) p\u00ebr PostgreSQL 14. IVM ofron nj\u00eb m\u00ebnyr\u00eb alternative p\u00ebr t\u00eb p\u00ebrdit\u00ebsuar pamjet materializuese, m\u00eb efektive n\u00eb rastet kur ndryshimet prekin nj\u00eb pjes\u00eb t\u00eb vog\u00ebl t\u00eb pamjes. IVM lejon p\u00ebrdit\u00ebsimin menj\u00ebher\u00eb t\u00eb pamjeve materializuese, duke aplikuar vet\u00ebm ndryshimet inkremetale, pa nevoj\u00ebn p\u00ebr t\u00eb rishtuar pamjen, e cila kryhet gjat\u00eb p\u00ebrdorimit t\u00eb operacionit \u201cREFRESH MATERIALIZED VIEW\u201d. \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"