{"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\/hu\/blog\/news\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0","title":{"rendered":"PostgreSQL friss\u00edt\u00e9s a sebezhet\u0151s\u00e9g jav\u00edt\u00e1s\u00e1val. Megjelent a pg_ivm 1.0.","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

A PostgreSQL minden t\u00e1mogatott \u00e1g\u00e1hoz (14.3, 13.7, 12.11, 11.16 \u00e9s 10.22) elk\u00e9sz\u00fcltek a hibajav\u00edt\u00f3 friss\u00edt\u00e9sek. A 10.x \u00e1g t\u00e1mogat\u00e1sa a k\u00f6zelj\u00f6v\u0151ben lej\u00e1r (a friss\u00edt\u00e9sek 2022. november\u00e9ig k\u00e9sz\u00fclnek). A 11.x \u00e1g friss\u00edt\u00e9sei 2023. november\u00e9ig folytat\u00f3dnak, a 12.x \u00e1g 2024. november\u00e9ig, a 13.x \u00e1g 2025. november\u00e9ig, m\u00edg a 14.x \u00e1g 2026. november\u00e9ig. <\/p>\n

Az \u00faj verzi\u00f3kban t\u00f6bb mint 50 jav\u00edt\u00e1s ker\u00fclt bevezet\u00e9sre, valamint a CVE-2022-1552 sebezhet\u0151s\u00e9get is orvosolt\u00e1k, amely a privilegiz\u00e1lt m\u0171veletek v\u00e9grehajt\u00e1s\u00e1nak elk\u00fcl\u00f6n\u00edt\u00e9s\u00e9nek megker\u00fcl\u00e9s\u00e9nek lehet\u0151s\u00e9g\u00e9vel \u00e1ll \u00f6sszef\u00fcgg\u00e9sben, ide\u00e9rtve az Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER \u00e9s pg_amcheck m\u0171veleteket. A t\u00e1mad\u00f3, aki k\u00e9pes nem ideiglenes objektumok l\u00e9trehoz\u00e1s\u00e1ra b\u00e1rmely t\u00e1rol\u00e1si s\u00e9ma alatt, el\u00e9rheti tetsz\u0151leges SQL-funkci\u00f3k v\u00e9grehajt\u00e1s\u00e1t szuperfelhaszn\u00e1l\u00f3i jogokkal a privilegiz\u00e1lt felhaszn\u00e1l\u00f3 \u00e1ltal v\u00e9grehajtott m\u0171veletek sor\u00e1n, amelyek az \u0151 objektumait \u00e9rintik. A sebezhet\u0151s\u00e9g kihaszn\u00e1l\u00e1sa automatikus adatb\u00e1zis-tiszt\u00edt\u00e1s sor\u00e1n is megt\u00f6rt\u00e9nhet az autovacuum feldolgoz\u00f3 v\u00e9grehajt\u00e1sakor. <\/p>\n

Ha a friss\u00edt\u00e9s v\u00e9grehajt\u00e1sa nem lehets\u00e9ges, mint megker\u00fcl\u0151 megold\u00e1s a probl\u00e9ma blokkja eset\u00e9n, le lehet tiltani az autovacuumot \u00e9s privilegiz\u00e1lt felhaszn\u00e1l\u00f3 \u00e1ltal v\u00e9grehajtott REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW \u00e9s CLUSTER m\u0171veleteket, valamint nem indul el a pg_amcheck seg\u00e9deszk\u00f6z, \u00e9s nem lehet helyre\u00e1ll\u00edtani a pg_dump \u00e1ltal l\u00e9trehozott biztons\u00e1gi m\u00e1solat tartalm\u00e1t. A VACUUM v\u00e9grehajt\u00e1sa biztons\u00e1gosnak sz\u00e1m\u00edt, ak\u00e1rcsak b\u00e1rmilyen m\u0171veleti parancs alkalmaz\u00e1sa, ha a kezelt objektumok megb\u00edzhat\u00f3 felhaszn\u00e1l\u00f3khoz tartoznak. <\/p>\n

A leg\u00fajabb kiad\u00e1sok m\u00e1s v\u00e1ltoz\u00e1sai k\u00f6z\u00f6tt megeml\u00edthet\u0151 a JIT k\u00f3d friss\u00edt\u00e9se az LLVM 14-hez val\u00f3 kompatibilit\u00e1s \u00e9rdek\u00e9ben, a database.schema.table sablonok haszn\u00e1lat\u00e1nak enged\u00e9lyez\u00e9se a psql, pg_dump \u00e9s pg_amcheck seg\u00e9deszk\u00f6z\u00f6kben, valamint a GiST indexek ltree oszlopok feletti s\u00e9r\u00fcl\u00e9s\u00e9hez vezet\u0151 probl\u00e9m\u00e1k jav\u00edt\u00e1sa, az epoch form\u00e1tumb\u00f3l sz\u00e1rmaz\u00f3 \u00e9rt\u00e9kek helytelen kerek\u00edt\u00e9se, a tervez\u0151 hib\u00e1s m\u0171k\u00f6d\u00e9se aszinkron t\u00e1voli lek\u00e9rdez\u00e9sek alkalmaz\u00e1sakor, a CLUSTER kifejez\u00e9s feletti indexekkel v\u00e9gzett m\u0171veletek sor\u00e1n a t\u00e1bl\u00e1zat sorainak helytelen rendez\u00e9se, az adatveszt\u00e9s a GiST rendezett index azonnali \u00fajrarendez\u00e9se ut\u00e1n, k\u00f6lcs\u00f6n\u00f6s blokkol\u00e1s a part\u00edcion\u00e1lt index t\u00f6rl\u00e9sekor, valamint a DROP TABLESPACE m\u0171velet \u00e9s a rendszer\u00e1llapot (checkpoint) r\u00f6gz\u00edt\u00e9se k\u00f6z\u00f6tti versenyhelyzet. <\/p>\n

Ezen k\u00edv\u00fcl megemelend\u0151 a pg_ivm 1.0 kiterjeszt\u00e9s kiad\u00e1sa, amely t\u00e1mogatja az IVM (Incremental View Maintenance) megold\u00e1s\u00e1t a PostgreSQL 14 eset\u00e9ben. Az IVM alternat\u00edv m\u00f3dot k\u00edn\u00e1l az anyagias\u00edtott n\u00e9zetek friss\u00edt\u00e9s\u00e9re, amely hat\u00e9konyabb m\u00f3dszert jelent, ha a v\u00e1ltoz\u00e1sok a n\u00e9zet kis r\u00e9sz\u00e9t \u00e9rintik. Az IVM lehet\u0151v\u00e9 teszi az anyagias\u00edtott n\u00e9zetek azonnali friss\u00edt\u00e9s\u00e9t, kiz\u00e1r\u00f3lag az inkrement\u00e1lis v\u00e1ltoz\u00e1sok alkalmaz\u00e1s\u00e1val, an\u00e9lk\u00fcl, hogy \u00fajra kellene sz\u00e1molni a n\u00e9zetet a 'REFRESH MATERIALIZED VIEW' m\u0171velet haszn\u00e1latakor.
\n
Forr\u00e1s: 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\udd47PostgreSQL friss\u00edt\u00e9s a sebezhet\u0151s\u00e9g megsz\u00fcntet\u00e9s\u00e9vel. pg_ivm 1.0 kiad\u00e1s | ProHoster","description":"Korrig\u00e1l\u00f3 friss\u00edt\u00e9sek k\u00e9sz\u00fcltek a PostgreSQL minden t\u00e1mogatott \u00e1gazat\u00e1hoz: 14.3, 13.7, 12.11, 11.16 \u00e9s 10.22.","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/news\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-pg_ivm-1-0","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"hu_HU","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\/hu\/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\/hu\/wp-json\/wp\/v2\/posts\/104014","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/comments?post=104014"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/104014\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=104014"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=104014"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=104014"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}