{"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\/cs\/blog\/news\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0","title":{"rendered":"Aktualizace PostgreSQL s odstran\u011bn\u00edm zranitelnosti. Vyd\u00e1n\u00ed pg_ivm 1.0","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Byly vytvo\u0159eny opravy pro v\u0161echny podporovan\u00e9 v\u011btve PostgreSQL: 14.3, 13.7, 12.11, 11.16 a 10.22. V\u011btev 10.x se bl\u00ed\u017e\u00ed ke konci podpory (aktualizace budou poskytov\u00e1ny do listopadu 2022). Vyd\u00e1v\u00e1n\u00ed aktualizac\u00ed pro v\u011btev 11.x potrv\u00e1 do listopadu 2023, 12.x \u2014 do listopadu 2024, 13.x \u2014 do listopadu 2025, 14.x \u2014 do listopadu 2026. <\/p>\n

V nov\u00fdch verz\u00edch bylo navr\u017eeno p\u0159es 50 oprav a byla odstran\u011bna zranitelnost CVE-2022-1552, kter\u00e1 souvis\u00ed s mo\u017enost\u00ed obch\u00e1zen\u00ed izolace prov\u00e1d\u011bn\u00ed privilegovan\u00fdch operac\u00ed Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER a pg_amcheck. \u00dato\u010dn\u00edk, kter\u00fd m\u00e1 opr\u00e1vn\u011bn\u00ed vytv\u00e1\u0159et nepotravinov\u00e9 objekty v jak\u00e9koli sch\u00e9matice, m\u016f\u017ee dos\u00e1hnout prov\u00e1d\u011bn\u00ed libovoln\u00fdch SQL funkc\u00ed s pr\u00e1vy superu\u017eivatele b\u011bhem prov\u00e1d\u011bn\u00ed privilegovan\u00fdm u\u017eivatelem v\u00fd\u0161e zm\u00edn\u011bn\u00fdch operac\u00ed, kter\u00e9 se dot\u00fdkaj\u00ed objektu \u00fato\u010dn\u00edka. Vyu\u017eit\u00ed t\u00e9to zranitelnosti m\u016f\u017ee nastat tak\u00e9 p\u0159i automatick\u00e9m \u010di\u0161t\u011bn\u00ed datab\u00e1ze b\u011bhem prov\u00e1d\u011bn\u00ed autovacuum handleru. <\/p>\n

Pokud nen\u00ed mo\u017en\u00e9 prov\u00e9st aktualizaci, jako obchvat blokov\u00e1n\u00ed probl\u00e9mu je mo\u017en\u00e9 vypnout autovacuum a neprov\u00e1d\u011bt privilegovan\u00fdm u\u017eivatelem operace REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW a CLUSTER, ani nespou\u0161t\u011bt n\u00e1stroj pg_amcheck a neobnovovat obsah ze z\u00e1lohy vytvo\u0159en\u00e9 n\u00e1strojem pg_dump. Prov\u00e1d\u011bn\u00ed VACUUM je pova\u017eov\u00e1no za bezpe\u010dn\u00e9, stejn\u011b jako pou\u017eit\u00ed jak\u00e9koliv operace, pokud zpracov\u00e1van\u00e9 objekty pat\u0159\u00ed d\u016fv\u011bryhodn\u00fdm u\u017eivatel\u016fm. <\/p>\n

Mezi dal\u0161\u00edmi zm\u011bnami v nov\u00fdch verz\u00edch lze zm\u00ednit aktualizaci k\u00f3du JIT pro spolupr\u00e1ci s LLVM 14, povolen\u00ed pou\u017e\u00edv\u00e1n\u00ed \u0161ablon database.schema.table v utilit\u00e1ch psql, pg_dump a pg_amcheck, opravu probl\u00e9m\u016f vedouc\u00edch k po\u0161kozen\u00ed index\u016f GiST nad sloupci ltree, nespr\u00e1vn\u00e9mu zaokrouhlov\u00e1n\u00ed hodnot ve form\u00e1tu epoch, z\u00edskan\u00fdch z dat typu interval, nespr\u00e1vn\u00e9 funkci pl\u00e1nova\u010de p\u0159i pou\u017e\u00edv\u00e1n\u00ed asynchronn\u00edch vzd\u00e1len\u00fdch dotaz\u016f, nespr\u00e1vn\u00e9mu t\u0159\u00edd\u011bn\u00ed \u0159\u00e1dk\u016f tabulky p\u0159i pou\u017eit\u00ed v\u00fdrazu CLUSTER nad indexy s kl\u00ed\u010di na z\u00e1klad\u011b v\u00fdraz\u016f, ztr\u00e1t\u011b dat p\u0159i havarijn\u00edm ukon\u010den\u00ed ihned po vybudov\u00e1n\u00ed se\u0159azen\u00e9ho indexu GiST, vz\u00e1jemn\u00e9mu zamyk\u00e1n\u00ed p\u0159i odstra\u0148ov\u00e1n\u00ed odstup\u0148ovan\u00e9ho indexu, a stavu z\u00e1vod\u011bn\u00ed mezi operac\u00ed DROP TABLESPACE a pevnou kontrolou stavu (checkpoint). <\/p>\n

D\u00e1le je mo\u017en\u00e9 zm\u00ednit vyd\u00e1n\u00ed roz\u0161\u00ed\u0159en\u00ed pg_ivm 1.0 s implementac\u00ed podpory IVM (Incremental View Maintenance) pro PostgreSQL 14. IVM nab\u00edz\u00ed alternativn\u00ed zp\u016fsob aktualizace materializovan\u00fdch pohled\u016f, efektivn\u011bj\u0161\u00ed, kdy\u017e se zm\u011bny t\u00fdkaj\u00ed mal\u00e9 \u010d\u00e1sti pohledu. IVM umo\u017e\u0148uje okam\u017eit\u011b aktualizovat materializovan\u00e9 pohledy aplikov\u00e1n\u00edm pouze inkrement\u00e1ln\u00edch zm\u011bn, bez op\u011btovn\u00e9ho v\u00fdpo\u010dtu pohledu, kter\u00fd se prov\u00e1d\u00ed p\u0159i pou\u017eit\u00ed operace \u201eREFRESH MATERIALIZED VIEW\u201c.
\n
Zdroj: opennet.ru<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"

\u0421\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a PostgreSQL: 14.3, 13.7, 12.11, 11.16 \u0438 10.22. \u0412\u0435\u0442\u043a\u0430 10.x \u043f\u0440\u0438\u0431\u043b\u0438\u0436\u0430\u0435\u0442\u0441\u044f \u043a \u043e\u043a\u043e\u043d\u0447\u0430\u043d\u0438\u044e \u0441\u0440\u043e\u043a\u0430 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u043a\u0438 (\u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0431\u0443\u0434\u0443\u0442 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2022 \u0433\u043e\u0434\u0430). \u0412\u044b\u043f\u0443\u0441\u043a \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0432\u0435\u0442\u043a\u0438 11.x \u043f\u0440\u043e\u0434\u043b\u0438\u0442\u0441\u044f \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2023 \u0433\u043e\u0434\u0430, 12.x — \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2024 \u0433\u043e\u0434\u0430, 13.x — \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2025 \u0433\u043e\u0434\u0430, 14.x — \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2026 […]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[702],"tags":[],"class_list":["post-104014","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\n","aioseo_head_json":{"title":"\ud83e\udd47Aktualizace PostgreSQL s opravou zranitelnosti. Vyd\u00e1n\u00ed pg_ivm 1.0 | ProHoster","description":"Byly vytvo\u0159eny opravn\u00e9 aktualizace pro v\u0161echny podporovan\u00e9 v\u011btve PostgreSQL: 14.3, 13.7, 12.11, 11.16 a 10.22.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/news\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0435 PostgreSQL \u0441 \u0443\u0441\u0442\u0440\u0430\u043d\u0435\u043d\u0438\u0435\u043c \u0443\u044f\u0437\u0432\u0438\u043c\u043e\u0441\u0442\u0438. \u0412\u044b\u043f\u0443\u0441\u043a pg_ivm 1.0 | ProHoster","og:description":"\u0421\u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u043d\u044b \u043a\u043e\u0440\u0440\u0435\u043a\u0442\u0438\u0440\u0443\u044e\u0449\u0438\u0435 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0441\u0435\u0445 \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432\u0435\u0442\u043e\u043a PostgreSQL: 14.3, 13.7, 12.11, 11.16 \u0438 10.22.","og:url":"https:\/\/prohoster.info\/cs\/blog\/news\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2022-05-13T01:36:48+00:00","article:modified_time":"2022-05-13T01:36:48+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"104014","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":"2026-01-25 10:59:40","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2022-05-13 01:37:46","updated":"2026-01-25 10:59:40","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/104014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=104014"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/104014\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=104014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=104014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=104014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}