{"id":33324,"date":"2019-10-31T21:51:57","date_gmt":"2019-10-31T18:51:57","guid":{"rendered":"https:\/\/prohoster.info\/blog\/obnovlnenie-postgresql-11-3-10-8-9-6-13-9-5-17-i-9-4-22\/"},"modified":"2019-10-31T21:51:57","modified_gmt":"2019-10-31T18:51:57","slug":"obnovlnenie-postgresql-11-3-10-8-9-6-13-9-5-17-i-9-4-22","status":"publish","type":"post","link":"https:\/\/prohoster.info\/fr\/blog\/news\/obnovlnenie-postgresql-11-3-10-8-9-6-13-9-5-17-i-9-4-22","title":{"rendered":"Mise \u00e0 jour de PostgreSQL 11.3, 10.8, 9.6.13, 9.5.17 et 9.4.22","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/about\/news\/1939\/\">De nouvelles<\/a><\/noindex> mises \u00e0 jour correctives pour toutes les branches prises en charge de PostgreSQL : <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/current\/static\/release-11-3.html\">11.3<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"https:\/\/www.postgresql.org\/docs\/current\/static\/release-10-8.html\">10.8<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/release-9-6-13.html\">9.6.13<\/a><\/noindex>, <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/release-9-5-17.html\">9.5.17<\/a><\/noindex> et <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/docs\/current\/static\/release-9-4-22.html\">9.4.22<\/a><\/noindex>, qui pr\u00e9sente un lot de corrections de bogues. La sortie des mises \u00e0 jour pour la branche 9.4 <noindex><a rel=\"nofollow\" href=\"http:\/\/www.postgresql.org\/support\/versioning\/\">va durer<\/a><\/noindex>   jusqu'en d\u00e9cembre 2019, 9.5 jusqu'en janvier 2021, 9.6 \u2014 jusqu'en septembre 2021, 10 \u2014 jusqu'en octobre 2022, 11 \u2014 jusqu'en novembre 2023. <\/p>\n<p>Les nouvelles versions corrigent plus de 60 bogues et r\u00e9solvent quatre vuln\u00e9rabilit\u00e9s :<\/p>\n<ul>\n<li class=\"l\">  Deux vuln\u00e9rabilit\u00e9s (CVE-2019-10127, CVE-2019-10128) sont sp\u00e9cifiques \u00e0 la plateforme Windows et se manifestent dans les installateurs des entreprises EnterpriseDB et BigSQL, qui n'ont pas appliqu\u00e9 de droits d'acc\u00e8s appropri\u00e9s sur le r\u00e9pertoire de donn\u00e9es, permettant \u00e0 tout utilisateur Windows non privil\u00e9gi\u00e9 d'initier l'ex\u00e9cution de code au niveau du service PostgreSQL.\n<li class=\"l\"> La vuln\u00e9rabilit\u00e9 CVE-2019-10129 se manifeste dans PostgreSQL 11 et permet \u00e0 un utilisateur de lire des zones de m\u00e9moire arbitraires du processus serveur en envoyant une requ\u00eate INSERT sp\u00e9cialement format\u00e9e \u00e0 une table partitionn\u00e9e.\n<li class=\"l\"> La vuln\u00e9rabilit\u00e9 CVE-2019-10130 permet de lire des valeurs d'enregistrements auxquels l'acc\u00e8s est restreint.\n<\/ul>\n<p>Parmi les erreurs corrig\u00e9es, on peut noter la corruption du catalogue lors de l'ex\u00e9cution de \u00ab ALTER TABLE \u00bb sur une table partitionn\u00e9e, le crash du serveur en cas d'erreur lors de la tentative de sauvegarde du curseur entre les validations de transaction, des probl\u00e8mes de performance lors de la restitution de transactions impliquant un grand nombre de tables, l'absence de prise en charge de l'expression \u00ab CREATE TABLE IF NOT EXISTS .. AS EXECUTE .. \u00bb, et des fuites de m\u00e9moire.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"link\"><\/a><\/noindex><\/p>\n<p>Source : <a \ncontent=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/www.opennet.ru\/opennews\/art.shtml?num=50660\">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: 11.3, 10.8, 9.6.13, 9.5.17 \u0438 9.4.22, \u0432 \u043a\u043e\u0442\u043e\u0440\u044b\u0445 \u043f\u0440\u0435\u0434\u0441\u0442\u0430\u0432\u043b\u0435\u043d\u0430 \u043f\u043e\u0440\u0446\u0438\u044f \u0438\u0441\u043f\u0440\u0430\u0432\u043b\u0435\u043d\u0438\u0439 \u043e\u0448\u0438\u0431\u043e\u043a. \u0412\u044b\u043f\u0443\u0441\u043a \u043e\u0431\u043d\u043e\u0432\u043b\u0435\u043d\u0438\u0439 \u0434\u043b\u044f \u0432\u0435\u0442\u043a\u0438 9.4 \u043f\u0440\u043e\u0434\u043b\u0438\u0442\u0441\u044f \u0434\u043e \u0434\u0435\u043a\u0430\u0431\u0440\u044f 2019 \u0433., 9.5 \u0434\u043e \u044f\u043d\u0432\u0430\u0440\u044f 2021 \u0433., 9.6 &#8212; \u0434\u043e \u0441\u0435\u043d\u0442\u044f\u0431\u0440\u044f 2021 \u0433\u043e\u0434\u0430, 10 &#8212; \u0434\u043e \u043e\u043a\u0442\u044f\u0431\u0440\u044f 2022 \u0433\u043e\u0434\u0430, 11 &#8212; \u0434\u043e \u043d\u043e\u044f\u0431\u0440\u044f 2023 \u0433\u043e\u0434\u0430. \u0412 \u043d\u043e\u0432\u044b\u0445 [&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":[702],"tags":[],"class_list":["post-33324","post","type-post","status-publish","format-standard","hentry","category-news"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.2.1 - 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\/fr\/blog\/news\/obnovlnenie-postgresql-11-3-10-8-9-6-13-9-5-17-i-9-4-22\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"fr_FR\" \/>\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\u043d\u0435\u043d\u0438\u0435 PostgreSQL 11.3, 10.8, 9.6.13, 9.5.17 \u0438 9.4.22 | 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\/fr\/blog\/news\/obnovlnenie-postgresql-11-3-10-8-9-6-13-9-5-17-i-9-4-22\" \/>\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=\"2019-10-31T18:51:57+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2019-10-31T18:51:57+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\udd47Mise \u00e0 jour PostgreSQL 11.3, 10.8, 9.6.13, 9.5.17 et 9.4.22 | ProHoster","description":"Des mises \u00e0 jour correctives ont \u00e9t\u00e9 form\u00e9es pour toutes les branches prises en charge de PostgreSQL :","canonical_url":"https:\/\/prohoster.info\/fr\/blog\/news\/obnovlnenie-postgresql-11-3-10-8-9-6-13-9-5-17-i-9-4-22","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"fr_FR","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\u043d\u0435\u043d\u0438\u0435 PostgreSQL 11.3, 10.8, 9.6.13, 9.5.17 \u0438 9.4.22 | 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\/fr\/blog\/news\/obnovlnenie-postgresql-11-3-10-8-9-6-13-9-5-17-i-9-4-22","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":"2019-10-31T18:51:57+00:00","article:modified_time":"2019-10-31T18:51:57+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"33324","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":"2026-01-21 14:48:19","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-03-01 02:42:25","updated":"2026-01-21 14:48:19","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/33324","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/comments?post=33324"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/posts\/33324\/revisions"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/media?parent=33324"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/categories?post=33324"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/fr\/wp-json\/wp\/v2\/tags?post=33324"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}