{"id":42942,"date":"2020-02-17T14:41:56","date_gmt":"2020-02-17T11:41:56","guid":{"rendered":"https:\/\/prohoster.info\/blog\/blog_prohoster\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat"},"modified":"2020-02-17T14:41:56","modified_gmt":"2020-02-17T11:41:56","slug":"obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat","title":{"rendered":"A PostgreSQL friss\u00edt\u00e9s s\u00e9r\u00fcl\u00e9kenys\u00e9g jav\u00edt\u00e1ssal. A pgcat replik\u00e1ci\u00f3s rendszer kiad\u00e1sa","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/about\/news\/2011\/\">Kialak\u00edtva<\/a><\/noindex> Jav\u00edt\u00f3 friss\u00edt\u00e9sek az \u00f6sszes t\u00e1mogatott PostgreSQL \u00e1ghoz: <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/current\/static\/release-12-2.html\">12.2<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/current\/static\/release-11-7.html\">11.7<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/current\/static\/release-10-12.html\">10.12<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/release-9-6-17.html\">9.6.17<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/release-9-5-21.html\">9.5.21<\/a><\/noindex> \u00e9s <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/release-9-4-26.html\">9.4.26<\/a><\/noindex>. A 9.4.26 kiad\u00e1s v\u00e9gleges &#8212; a 9.4-es \u00e1g friss\u00edt\u00e9seinek el\u0151k\u00e9sz\u00edt\u00e9se. <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/support\/versioning\/\">le\u00e1ll\u00edtva<\/a><\/noindex>. A 9.5-\u00f6s \u00e1gba \u00e1prilisig k\u00e9sz\u00fclnek friss\u00edt\u00e9sek 2021-ig, a 9.6-os \u00e1g novemberig 2021-ig, a 10-es \u00e1g pedig novemberig 2022-ig, a 11-es \u00e1g novemberig 2023-ig, a 12-es \u00e1g pedig novemberig 2024-ig. <\/p>\n<p>Az \u00faj verzi\u00f3kban 75 hib\u00e1t jav\u00edtottak \u00e9s egy s\u00e9r\u00fcl\u00e9kenys\u00e9get<br \/>\n(CVE-2020-1720), amely az enged\u00e9lyez\u00e9s ellen\u0151rz\u00e9s\u00e9nek hi\u00e1ny\u00e1b\u00f3l ered az &#171;ALTER &#8230; DEPENDS ON EXTENSION&#187; parancs v\u00e9grehajt\u00e1sakor. Bizonyos k\u00f6r\u00fclm\u00e9nyek k\u00f6z\u00f6tt a sebezhet\u0151s\u00e9g lehet\u0151v\u00e9 teszi, hogy egy nem privilegiz\u00e1lt felhaszn\u00e1l\u00f3 elt\u00e1vol\u00edtson b\u00e1rmelyik funkci\u00f3t, elj\u00e1r\u00e1st, mat\u00e9rializ\u00e1lt n\u00e9zetet, indexet vagy triggert. A t\u00e1mad\u00e1s lehets\u00e9ges, ha a rendszergazda b\u00e1rmilyen kiterjeszt\u00e9st telep\u00edtett, \u00e9s a felhaszn\u00e1l\u00f3nak lehet\u0151s\u00e9ge van a CREATE parancs v\u00e9grehajt\u00e1s\u00e1ra, vagy meg tudja gy\u0151zni a kiterjeszt\u00e9s tulajdonos\u00e1t, hogy hajtsa v\u00e9gre a DROP EXTENSION parancsot.<\/p>\n<p>Ezen fel\u00fcl \u00e9rdemes megeml\u00edteni egy \u00faj alkalmaz\u00e1s megjelen\u00e9s\u00e9t <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/kingluo\/pgcat\">pgcat<\/a><\/noindex>, amely lehet\u0151v\u00e9 teszi adatok replik\u00e1ci\u00f3j\u00e1t t\u00f6bb PostgreSQL szerver k\u00f6z\u00f6tt. A program t\u00e1mogatja a logikai replik\u00e1ci\u00f3t a f\u0151 szerveren v\u00e9grehajtott SQL parancsok adatv\u00e1ltoz\u00e1st eredm\u00e9nyez\u0151 \u00e1tvitel\u00e9vel \u00e9s lej\u00e1tsz\u00e1s\u00e1val egy m\u00e1sik g\u00e9pen. A k\u00f3d Go nyelven \u00edr\u00f3dott \u00e9s <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/kingluo\/pgcat\">terjeszt\u00e9sre ker\u00fcl<\/a><\/noindex> Apache 2.0 licenc alatt \u00e1ll. F\u0151 k\u00fcl\u00f6nbs\u00e9gek az integr\u00e1lt logikai replik\u00e1l\u00e1si mechanizmust\u00f3l:<\/p>\n<ul>\n<li class=\"l\"> B\u00e1rmilyen t\u00edpus\u00fa c\u00e9l t\u00e1bl\u00e1k t\u00e1mogat\u00e1sa (n\u00e9zetek, fdw (Foreign Data Wrapper), szegment\u00e1lt t\u00e1bl\u00e1k, elosztott t\u00e1bl\u00e1k citus);\n<li class=\"l\"> Lehet\u0151v\u00e9 teszi a t\u00e1blanevek fel\u00fclb\u00edr\u00e1lat\u00e1t (replik\u00e1ci\u00f3 egy t\u00e1bl\u00e1b\u00f3l egy m\u00e1sikba);\n<li class=\"l\"> K\u00e9tir\u00e1ny\u00fa replik\u00e1ci\u00f3 t\u00e1mogat\u00e1sa, amely csak a helyi v\u00e1ltoztat\u00e1sok \u00e1tvitel\u00e9t teszi lehet\u0151v\u00e9, figyelmen k\u00edv\u00fcl hagyva a k\u00fcls\u0151 replik\u00e1ci\u00f3kat;\n<li class=\"l\"> Konfliktuskezel\u0151 rendszer, amely az LWW (last-writer-win) algoritmus alapjain m\u0171k\u00f6dik;\n<li class=\"l\"> Lehet\u0151s\u00e9g a replik\u00e1ci\u00f3 el\u0151rehalad\u00e1s\u00e1nak \u00e9s a nem alkalmazott replik\u00e1ci\u00f3k nyomon k\u00f6vet\u00e9s\u00e9re egy k\u00fcl\u00f6n t\u00e1bl\u00e1ban, amelyet a ideiglenesen el\u00e9rhetetlen fogad\u00f3csom\u00f3pont m\u0171k\u00f6d\u00e9s\u00e9nek helyre\u00e1ll\u00edt\u00e1sa sor\u00e1n lehet haszn\u00e1lni.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Forr\u00e1s: <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=52370\">opennet.ru<\/a><\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\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: 12.2, 11.7, 10.12, 9.6.17, 9.5.21 \u0438 9.4.26. \u0412\u044b\u043f\u0443\u0441\u043a 9.4.26 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0444\u0438\u043d\u0430\u043b\u044c\u043d\u044b\u043c &#8212; \u043f\u043e\u0434\u0433\u043e\u0442\u043e\u0432\u043a\u0430 \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0432\u0435\u0442\u043a\u0438 9.4 \u043f\u0440\u0435\u043a\u0440\u0430\u0449\u0435\u043d\u0430. \u041e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u044f \u0434\u043b\u044f \u0432\u0435\u0442\u043a\u0438 9.5 \u0431\u0443\u0434\u0443\u0442 \u0444\u043e\u0440\u043c\u0438\u0440\u043e\u0432\u0430\u0442\u044c\u0441\u044f \u0434\u043e \u0444\u0435\u0432\u0440\u0430\u043b\u044f 2021 \u0433., 9.6 &#8212; \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2021 \u0433\u043e\u0434\u0430, 10 &#8212; \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2022 \u0433\u043e\u0434\u0430, 11 &#8212; \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2023 \u0433\u043e\u0434\u0430, 12 [&hellip;]<\/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":[],"tags":[],"class_list":["post-42942","post","type-post","status-publish","format-standard","hentry"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\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:\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/hu\/blog\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"hu_HU\" \/>\n\t\t<meta property=\"og:site_name\" content=\"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\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\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 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438 pgcat | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\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:\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/hu\/blog\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-02-17T11:41:56+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-02-17T11:41:56+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47A PostgreSQL friss\u00edt\u00e9s s\u00e9r\u00fcl\u00e9kenys\u00e9g jav\u00edt\u00e1ssal. A pgcat replik\u00e1ci\u00f3s rendszer kiad\u00e1sa | ProHoster","description":"Jav\u00edt\u00f3 friss\u00edt\u00e9sek k\u00e9sz\u00fcltek az \u00f6sszes t\u00e1mogatott PostgreSQL \u00e1ghoz:","canonical_url":"https:\/\/prohoster.info\/hu\/blog\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat","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 \u0441\u0438\u0441\u0442\u0435\u043c\u044b \u0440\u0435\u043f\u043b\u0438\u043a\u0430\u0446\u0438\u0438 pgcat | 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:","og:url":"https:\/\/prohoster.info\/hu\/blog\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat","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":"2020-02-17T11:41:56+00:00","article:modified_time":"2020-02-17T11:41:56+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"42942","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":null,"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":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 23:51:33","updated":"2022-09-28 20:36:17","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\/42942","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=42942"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/posts\/42942\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/media?parent=42942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/categories?post=42942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/hu\/wp-json\/wp\/v2\/tags?post=42942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}