{"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\/sq\/blog\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat","title":{"rendered":"P\u00ebrdit\u00ebsimi i PostgreSQL p\u00ebr t\u00eb eliminuar nj\u00eb vulnerabilitet. \u00c7lirimi i sistemit t\u00eb replikimit pgcat","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/about\/news\/2011\/\">Jan\u00eb formuar<\/a><\/noindex> p\u00ebrdit\u00ebsime korrigjuese p\u00ebr t\u00eb gjitha deg\u00ebt e mb\u00ebshtetura t\u00eb PostgreSQL: <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> dhe <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/release-9-4-26.html\">9.4.26<\/a><\/noindex>. L\u00ebshimi 9.4.26 \u00ebsht\u00eb p\u00ebrfundimtar \u2014 p\u00ebrgatitjet p\u00ebr azhurnimet e deg\u00ebs 9.4 <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/support\/versioning\/\">ka p\u00ebrfunduar<\/a><\/noindex>. Azhurnimet p\u00ebr deg\u00ebn 9.5 do t\u00eb formohen deri n\u00eb shkurt 2021, 9.6 \u2014 deri n\u00eb n\u00ebntor 2021, 10 \u2014 deri n\u00eb n\u00ebntor 2022, 11 \u2014 deri n\u00eb n\u00ebntor 2023, 12 \u2014 deri n\u00eb n\u00ebntor 2024. <\/p>\n<p>N\u00eb versionet e reja jan\u00eb rregulluar 75 gabime dhe \u00ebsht\u00eb eliminuar nj\u00eb vulnerabilitet<br \/>\n(CVE-2020-1720), shkaktuar nga mungesa e kontrollit t\u00eb autorizimit gjat\u00eb ekzekutimit t\u00eb komand\u00ebs \u00abALTER \u2026 DEPENDS ON EXTENSION\u00bb. N\u00ebn rrethana t\u00eb caktuara, vulnerabiliteti lejon nj\u00eb p\u00ebrdorues pa privilegje t\u00eb fshij\u00eb \u00e7do funksion, procedur\u00eb, materializim t\u00eb pamjes, indeks ose trigger. Sulmi \u00ebsht\u00eb i mundur n\u00ebse administrator\u00eb kan\u00eb instaluar ndonj\u00eb zgjerim dhe p\u00ebrdoruesi mund t\u00eb ekzekutoj\u00eb komand\u00ebn CREATE ose ndonj\u00eb pronar t\u00eb zgjerimit arrin ta bind\u00eb t\u00eb ekzekutoj\u00eb komand\u00ebn DROP EXTENSION.<\/p>\n<p>S\u00eb addition, mund t\u00eb theksohet shfaqja e nj\u00eb aplikacioni t\u00eb ri <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/kingluo\/pgcat\">pgcat<\/a><\/noindex>, q\u00eb lejon t\u00eb replikoni t\u00eb dh\u00ebnat nd\u00ebrmjet disa server\u00ebve PostgreSQL. Programi mb\u00ebshtet replikimin logjik p\u00ebrmes transmetimit dhe riprodhimit n\u00eb nj\u00eb host tjet\u00ebr t\u00eb fluksit t\u00eb komandave SQL q\u00eb kryejn\u00eb ndryshime n\u00eb t\u00eb dh\u00ebna. Kodi \u00ebsht\u00eb shkruar n\u00eb gjuh\u00ebn Go dhe <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/kingluo\/pgcat\">shp\u00ebrndahet<\/a><\/noindex> n\u00eb licenc\u00ebn Apache 2.0. Dallimet kryesore nga mekanizmi i integruar i replikimit logjik:<\/p>\n<ul>\n<li class=\"l\"> Mb\u00ebshtetje p\u00ebr \u00e7do lloj tabele t\u00eb synuar (pamje, fdw (Foreign Data Wrapper), tabela t\u00eb segmentuara, tabela t\u00eb shp\u00ebrndara citus);\n<li class=\"l\"> Mund\u00ebsia e riem\u00ebrimit t\u00eb emrave t\u00eb tabelave (replikimi nga nj\u00eb tabel\u00eb n\u00eb nj\u00eb tjet\u00ebr);\n<li class=\"l\"> Mb\u00ebshtetje p\u00ebr replikimin dykah\u00ebsh p\u00ebrmes transferimit vet\u00ebm t\u00eb ndryshimeve lokale duke injoruar replikimet q\u00eb vijn\u00eb nga jasht\u00eb;\n<li class=\"l\"> Prania e nj\u00eb sistemi t\u00eb zgjidhjes s\u00eb konflikteve t\u00eb bazuar n\u00eb algoritmin LWW (last-writer-win);\n<li class=\"l\"> Mund\u00ebsia e ruajtjes s\u00eb informacionit mbi p\u00ebrparimin e replikimit dhe replikat e pap\u00ebrdorura n\u00eb nj\u00eb tabel\u00eb t\u00eb ve\u00e7ant\u00eb, e cila mund t\u00eb p\u00ebrdoret p\u00ebr rikuperimin pas rikthimit t\u00eb funksionit t\u00eb nodit marr\u00ebs q\u00eb ishte p\u00ebrkoh\u00ebsisht i papranuesh\u00ebm.\n<\/ul>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Burimi: <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.2 - 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\/sq\/blog\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\/sq\/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\udd47P\u00ebrdit\u00ebsimi i PostgreSQL p\u00ebr t\u00eb eliminuar nj\u00eb vulnerabilitet. \u00c7lirimi i sistemit t\u00eb replikimit pgcat | ProHoster","description":"Jan\u00eb formuar p\u00ebrdit\u00ebsime korrigjuese p\u00ebr t\u00eb gjitha deg\u00ebt e mb\u00ebshtetura t\u00eb PostgreSQL:","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/obnovlenie-postgresql-s-ustraneniem-uyazvimosti-vypusk-sistemy-replikaczii-pgcat","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/42942","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=42942"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/42942\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=42942"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=42942"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=42942"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}