{"id":195,"date":"2024-05-22T16:51:40","date_gmt":"2024-05-22T08:51:40","guid":{"rendered":"http:\/\/www.bigqq.com\/?p=195"},"modified":"2024-08-23T11:10:32","modified_gmt":"2024-08-23T03:10:32","slug":"pg%e6%95%b0%e6%8d%ae%e5%ba%93windows%e5%ae%9a%e6%97%b6%e4%bb%bb%e5%8a%a1pgagent","status":"publish","type":"post","link":"http:\/\/www.bigqq.com\/?p=195","title":{"rendered":"PG\u6570\u636e\u5e93windows\u5b9a\u65f6\u4efb\u52a1pgAgent"},"content":{"rendered":"\n<p>pgAdmin\u5b89\u88c5\u540e\u4f1a\u6709Application Stack Builder\u7ec4\u4ef6\uff0c\u4f7f\u7528\u8be5\u7ec4\u4ef6\u5b89\u88c5pgAgent<\/p>\n\n\n\n<p>\u5b89\u88c5\u540epgAdmin\u767b\u5f55\u540e\u6709\u5b9a\u65f6\u4efb\u52a1\uff0c\u4f46\u53ea\u80fd\u8bbf\u95eepostgre\u6570\u636e\u5e93\uff1f<\/p>\n\n\n\n<p>\u6682\u65f6\u7528dblink\u65b9\u5f0f\u5b9e\u73b0\u8de8\u5e93\u8c03\u7528\uff0c\u4f7f\u7528create extension dblink;\u547d\u4ee4\u5b89\u88c5dblink<\/p>\n\n\n\n<p>CREATE VIEW log_dblink AS<br>SELECT * FROM dblink(&#8216;hostaddr=127.0.0.1 port=5432 dbname=LOG user=log password=Log2023&#8217;, &#8216;SELECT auto_log\uff08)&#8217;) AS t(id int);<\/p>\n\n\n\n<p>\u5982\u5b9a\u65f6\u4efb\u52a1\u672a\u8fd0\u884c\uff0c\u9700\u8981\u67e5\u770b\u670d\u52a1\u4e2d\u7684Agent\u662f\u5426\u542f\u52a8<\/p>\n","protected":false},"excerpt":{"rendered":"<p>pgAdmin\u5b89\u88c5\u540e\u4f1a\u6709Applicat [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/195"}],"collection":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=195"}],"version-history":[{"count":2,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/195\/revisions"}],"predecessor-version":[{"id":220,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=\/wp\/v2\/posts\/195\/revisions\/220"}],"wp:attachment":[{"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=195"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bigqq.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}