{"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\/news\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0","title":{"rendered":"P\u00ebrdit\u00ebsim i PostgreSQL me korrigjim t\u00eb cenueshm\u00ebris\u00eb. Publikohet pg_ivm 1.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"
Jan\u00eb formuar azhurnime korrektuese p\u00ebr t\u00eb gjitha deg\u00ebt e mb\u00ebshtetura t\u00eb PostgreSQL: 14.3, 13.7, 12.11, 11.16 dhe 10.22. Dega 10.x po afron n\u00eb fund t\u00eb periudh\u00ebs s\u00eb mb\u00ebshtetjes (azhurnimet do t\u00eb formohen deri n\u00eb n\u00ebntor 2022). Publikimi i azhurnimeve 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 propozuar m\u00eb shum\u00eb se 50 korrigjime dhe \u00ebsht\u00eb eliminuar nep\u00ebrmjet\u00ebsia CVE-2022-1552, e lidhur me mund\u00ebsin\u00eb e shmangies s\u00eb izolimit t\u00eb ekzekutimit t\u00eb operacioneve me privilegje Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER dhe pg_amcheck. Nj\u00eb sulmues q\u00eb ka autorizimin p\u00ebr t\u00eb krijuar objekte jo temporale n\u00eb ndonj\u00eb skem\u00eb ruajtjeje, mund t\u00eb arrij\u00eb t\u00eb ekzekutoj\u00eb funksione SQL t\u00eb rast\u00ebsishme me t\u00eb drejta superp\u00ebrdoruesi gjat\u00eb kryerjes nga p\u00ebrdoruesi me privilegje t\u00eb m\u00ebsip\u00ebrm t\u00eb operacioneve q\u00eb prekin objektin e sulmuesit. Po ashtu, shfryt\u00ebzimi i nep\u00ebrmjet\u00ebsis\u00eb mund t\u00eb ndodh\u00eb gjat\u00eb pastrimit automatik t\u00eb baz\u00ebs gjat\u00eb ekzekutimit t\u00eb procesorit autovacuum. <\/p>\n
N\u00eb rast t\u00eb pamund\u00ebsis\u00eb p\u00ebr t\u00eb kryer azhurnimin, si nj\u00eb zgjidhje p\u00ebr bllokimin e problemit, mund t\u00eb \u00e7aktivizohet autovacuum dhe t\u00eb mos kryhen operacione REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW dhe CLUSTER nga p\u00ebrdoruesit me privilegje, si dhe t\u00eb mos startohet utilitari pg_amcheck dhe t\u00eb mos rikuperohet p\u00ebrmbajtja nga nj\u00eb kopje rezerv\u00eb e krijuar nga utilitari pg_dump. Ekzekutimi i VACUUM \u00ebsht\u00eb i njohur si i sigurt, ashtu si dhe aplikimi i \u00e7do operacioni komandash, n\u00ebse objektet q\u00eb p\u00ebrpunohen i p\u00ebrkasin p\u00ebrdoruesve t\u00eb besuesh\u00ebm. <\/p>\n
N\u00eb mesin e ndryshimeve t\u00eb tjera n\u00eb l\u00ebshimet e reja, mund t\u00eb p\u00ebrmenden azhurnimi i kodit JIT p\u00ebr t\u00eb punuar me LLVM 14, leja p\u00ebr t\u00eb p\u00ebrdorur template-et database.schema.table n\u00eb utilitar\u00ebt psql, pg_dump dhe pg_amcheck, p\u00ebrmir\u00ebsimi i problemeve q\u00eb \u00e7ojn\u00eb n\u00eb d\u00ebmtimin e indekseve GiST mbi kolonat ltree, rregullimi i gj\u00ebr\u00ebsive t\u00eb vlerave n\u00eb formatin epoch, t\u00eb nxjerra nga t\u00eb dh\u00ebnat me tipin interval, funksionimi i gabuar i planifikuesit gjat\u00eb p\u00ebrdorimit t\u00eb pyetjeve t\u00eb larg\u00ebta asinkrone, renditja e gabuar e rreshtave t\u00eb tabel\u00ebs gjat\u00eb p\u00ebrdorimit t\u00eb shprehjes CLUSTER mbi indekset me \u00e7elica mbi baza shprehjesh, humbja e t\u00eb dh\u00ebnave gjat\u00eb mbylljes menj\u00ebher\u00eb pas nd\u00ebrtimit t\u00eb nj\u00eb indeksi t\u00eb renditur GiST, bllokimi reciprok gjat\u00eb fshirjes s\u00eb indekseve t\u00eb ndara, dhe gjendja e gar\u00ebs midis operacionit DROP TABLESPACE dhe fiksej\u00ebs s\u00eb gjendjes (checkpoint). <\/p>\n
P\u00ebrve\u00e7 k\u00ebsaj, mund t\u00eb theksohet publikimi i shtes\u00ebs pg_ivm 1.0 me implementimin e mb\u00ebshtetjes p\u00ebr IVM (Mir\u00ebmbajtja Inkrementale t\u00eb Pamjeve) p\u00ebr PostgreSQL 14. IVM ofron nj\u00eb m\u00ebnyr\u00eb alternative p\u00ebr p\u00ebrdit\u00ebsimin e pamjeve materializuara, m\u00eb efikase 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 materializuara, duke aplikuar vet\u00ebm ndryshimet inkrementale pa nevoj\u00ebn p\u00ebr nj\u00eb ri-kalkulim t\u00eb pamjes, i b\u00ebr\u00eb gjat\u00eb p\u00ebrdorimit t\u00eb operacionit \"REFRESH MATERIALIZED VIEW\". \n Burimi: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"