{"id":3596,"date":"2023-09-27T14:22:25","date_gmt":"2023-09-27T06:22:25","guid":{"rendered":"http:\/\/www.gzwangan.com\/?p=3596"},"modified":"2023-09-27T14:24:02","modified_gmt":"2023-09-27T06:24:02","slug":"pgadmin4-%e8%bf%9c%e7%a8%8b%e5%91%bd%e4%bb%a4%e6%89%a7%e8%a1%8c%e6%bc%8f%e6%b4%9e","status":"publish","type":"post","link":"http:\/\/www.gzwangan.com\/?p=3596","title":{"rendered":"pgAdmin4 \u8fdc\u7a0b\u547d\u4ee4\u6267\u884c\u6f0f\u6d1e"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"3596\" class=\"elementor elementor-3596\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-7fa7e0e4 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7fa7e0e4\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-7947b4fb\" data-id=\"7947b4fb\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-11b7d8cc elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"11b7d8cc\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-3b8ab618\" data-id=\"3b8ab618\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-52440af4 elementor-widget elementor-widget-heading\" data-id=\"52440af4\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u5b89\u5168\u52a8\u6001<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-3d4a5bbc elementor-section-full_width xi elementor-section-height-default elementor-section-height-default\" data-id=\"3d4a5bbc\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-5e3ad8dc\" data-id=\"5e3ad8dc\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-653a96b0 elementor-widget elementor-widget-heading\" data-id=\"653a96b0\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><a href=\"\/?page_id=561\">\u884c\u4e1a\u52a8\u6001<\/a><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-5a48ae0b elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"5a48ae0b\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-7138b384\" data-id=\"7138b384\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-5f62b378 elementor-widget elementor-widget-heading\" data-id=\"5f62b378\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\"><a href=\"\/?page_id=566\">\u6f0f\u6d1e\u52a8\u6001<\/a><\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-inner-section elementor-element elementor-element-66a5b85d elementor-section-full_width elementor-section-height-default elementor-section-height-default\" data-id=\"66a5b85d\" data-element_type=\"section\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-inner-column elementor-element elementor-element-56948a39\" data-id=\"56948a39\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-3d96b980 elementor-widget elementor-widget-heading\" data-id=\"3d96b980\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">\u8054\u7cfb\u65b9\u5f0f<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-1c9c14ad elementor-widget elementor-widget-text-editor\" data-id=\"1c9c14ad\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p>\u5730\u5740\uff1a\u00a0\u5e7f\u5dde\u5e02\u8d8a\u79c0\u533a\u4e1c\u98ce\u4e1c\u8def750\u53f7\u5e7f\u8054\u5927\u53a613\u697c1307-1309\u5ba4<br \/>\u7535\u8bdd\uff1a18898400087<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<div class=\"elementor-column elementor-col-50 elementor-top-column elementor-element elementor-element-18d848b\" data-id=\"18d848b\" data-element_type=\"column\" data-settings=\"{&quot;background_background&quot;:&quot;classic&quot;}\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-67d819f3 elementor-widget elementor-widget-text-editor\" data-id=\"67d819f3\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul><li style=\"text-align: left;\"><span style=\"color: #000000;\">\u6f0f\u6d1e\u7f16\u53f7\uff1aCVE-2023-5002<\/span><span style=\"color: #000000;\"><br \/><\/span><\/li><li><span style=\"color: #000000;\">\u6f0f\u6d1e\u7c7b\u578b\uff1a\u8fdc\u7a0b\u547d\u4ee4\u6267\u884c(RCE)<\/span><\/li><li><span style=\"color: #000000;\">\u6f0f\u6d1e\u7b49\u7ea7\uff1a\u4e2d\u5371<\/span><\/li><li><span style=\"color: #000000;\">\u53d1\u5e03\u65f6\u95f4\uff1a2023-09-22<\/span><\/li><\/ul><p><span style=\"color: #000000;\">\u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0 \u00a0\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"color: #000000;\">\u6f0f\u6d1e\u63cf\u8ff0\uff1a<\/span><\/p><p style=\"padding-left: 40px;\">pgAdmin \u662f PostgreSQL \u9886\u5148\u7684\u5f00\u6e90\u56fe\u5f62\u5316\u7ba1\u7406\u5de5\u5177\u3002pgAdmin 4 \u65e8\u5728\u6ee1\u8db3\u65b0\u624b\u548c\u6709\u7ecf\u9a8c\u7684 Postgres \u7528\u6237\u7684\u9700\u6c42\uff0c\u63d0\u4f9b\u5f3a\u5927\u7684\u56fe\u5f62\u754c\u9762\uff0c\u7b80\u5316\u4e86\u6570\u636e\u5e93\u5bf9\u8c61\u7684\u521b\u5efa\u3001\u7ef4\u62a4\u548c\u4f7f\u7528\u3002<\/p><p style=\"padding-left: 40px;\">pgAdmin 4 v7.6\u53ca\u4e4b\u524d\u7248\u672c\u4e2d\u5b58\u5728\u4e00\u5904\u8fdc\u7a0b\u4ee3\u7801\u6267\u884c\u6f0f\u6d1e\uff0c\u5728\u4ee5\u670d\u52a1\u5668\u6a21\u5f0f\u8fd0\u884cpgAdmin\u65f6\uff0cpgAdmin \u670d\u52a1\u5668\u4f7f\u7528\u7528\u6237\u901a\u8fc7HTTP API \u4f20\u5165\u7684 PostgreSQL\u7a0b\u5e8f\u547d\u4ee4\u8def\u5f84\u4f5c\u4e3aPostgreSQL \u6267\u884c\u8def\u5f84\uff0c\u7ecf\u8fc7\u8eab\u4efd\u9a8c\u8bc1\u7684\u653b\u51fb\u8005\u901a\u8fc7\u4f20\u5165\u4f2a\u9020\u7684\u7a0b\u5e8f\u547d\u4ee4\u53ef\u5bfc\u81f4\u547d\u4ee4\u6ce8\u5165\uff0c\u5b9e\u73b0\u5728pgAdmin 4\u670d\u52a1\u5668\u4e0a\u6267\u884c\u547d\u4ee4\u3002<\/p><p><span style=\"color: #000000;\">\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"color: #000000;\">\u5f71\u54cd\u7248\u672c\uff1a<\/span><\/p><div class=\"effect-version-item\" data-v-27da897c=\"\"><p class=\"effect-version-item-type effect-version-item-product\" style=\"padding-left: 40px;\" data-v-27da897c=\"\">pgAdmin 4&lt;=7.6<\/p><\/div><p><span style=\"color: #000000;\">\u00a0<\/span><\/p><p style=\"padding-left: 40px;\"><span style=\"color: #000000;\">\u4fee\u590d\u5efa\u8bae<\/span><\/p><p style=\"padding-left: 40px;\">\u5b98\u65b9\u5df2\u4fee\u590d\u8be5\u6f0f\u6d1e\uff0c\u5efa\u8bae\u7528\u6237\u66f4\u65b0\u5230\u5b89\u5168\u7248\u672c\u3002<br \/>\u5b89\u5168\u7248\u672c:<br \/>pgAdmin 4 &gt;= 7.7<br \/>\u4e0b\u8f7d\u94fe\u63a5\uff1a<br \/>https:\/\/www.pgadmin.org\/docs\/pgadmin4\/7.7\/release_notes_7_7.html<\/p><p>\u00a0<\/p><p style=\"padding-left: 40px;\"><br \/>\u53c2\u8003\u94fe\u63a5:<\/p><pre data-v-271c8389=\"\">https:\/\/bugzilla.redhat.com\/show_bug.cgi?id=2239164\nhttps:\/\/github.com\/pgadmin-org\/pgadmin4\/issues\/6763<\/pre><div>\u00a0<\/div><div>\u00a0<\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-269730a6 elementor-widget elementor-widget-post-navigation\" data-id=\"269730a6\" data-element_type=\"widget\" data-widget_type=\"post-navigation.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-post-navigation\">\n\t\t\t<div class=\"elementor-post-navigation__prev elementor-post-navigation__link\">\n\t\t\t\t<a href=\"http:\/\/www.gzwangan.com\/?p=3590\" rel=\"prev\"><span class=\"post-navigation__arrow-wrapper post-navigation__arrow-prev\"><i class=\"fa fa-angle-left\" aria-hidden=\"true\"><\/i><span class=\"elementor-screen-only\">Prev<\/span><\/span><span class=\"elementor-post-navigation__link__prev\"><span class=\"post-navigation__prev--title\">\u6cdb\u5fae E-Office 10 \u8fdc\u7a0b\u4ee3\u7801\u6267\u884c\u6f0f\u6d1e<\/span><\/span><\/a>\t\t\t<\/div>\n\t\t\t\t\t\t<div class=\"elementor-post-navigation__next elementor-post-navigation__link\">\n\t\t\t\t<a href=\"http:\/\/www.gzwangan.com\/?p=3602\" rel=\"next\"><span class=\"elementor-post-navigation__link__next\"><span class=\"post-navigation__next--title\">Windows \u5185\u6838\u6743\u9650\u63d0\u5347\u6f0f\u6d1e<\/span><\/span><span class=\"post-navigation__arrow-wrapper post-navigation__arrow-next\"><i class=\"fa fa-angle-right\" aria-hidden=\"true\"><\/i><span class=\"elementor-screen-only\">Next<\/span><\/span><\/a>\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2bcd1a74 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2bcd1a74\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-88b41b6\" data-id=\"88b41b6\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>\u5b89\u5168\u52a8\u6001 \u884c\u4e1a\u52a8\u6001 \u6f0f\u6d1e\u52a8\u6001 \u8054\u7cfb\u65b9\u5f0f \u5730\u5740\uff1a\u00a0\u5e7f\u5dde\u5e02\u8d8a\u79c0\u533a\u4e1c\u98ce\u4e1c\u8def750\u53f7\u5e7f\u8054\u5927\u53a613\u697c1307-1309\u5ba4&hellip; <a class=\"more-link\" href=\"http:\/\/www.gzwangan.com\/?p=3596\">\u7ee7\u7eed\u9605\u8bfb<span class=\"screen-reader-text\">pgAdmin4 \u8fdc\u7a0b\u547d\u4ee4\u6267\u884c\u6f0f\u6d1e<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"elementor_header_footer","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-3596","post","type-post","status-publish","format-standard","hentry","category-security","entry"],"_links":{"self":[{"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=\/wp\/v2\/posts\/3596","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3596"}],"version-history":[{"count":5,"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=\/wp\/v2\/posts\/3596\/revisions"}],"predecessor-version":[{"id":3601,"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=\/wp\/v2\/posts\/3596\/revisions\/3601"}],"wp:attachment":[{"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3596"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gzwangan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}