{"id":272,"date":"2021-01-14T19:46:08","date_gmt":"2021-01-14T13:46:08","guid":{"rendered":"http:\/\/www.jichangqing.net\/wordpress\/?p=272"},"modified":"2021-01-14T19:46:08","modified_gmt":"2021-01-14T13:46:08","slug":"postgresql-13-1-%e5%ae%89%e8%a3%85%e8%af%a6%e7%bb%86%e6%ad%a5%e9%aa%a4%ef%bc%88win10%ef%bc%89pgadmin-4-%e6%b5%8f%e8%a7%88%e5%99%a8%e6%89%93%e5%bc%80%e5%8d%a1%e5%9c%a8%e5%9c%88%e5%9c%88%e7%9a%84","status":"publish","type":"post","link":"http:\/\/www.jichangqing.net\/wordpress\/?p=272","title":{"rendered":"PostgreSQL 13.1 \u5b89\u88c5\u8be6\u7ec6\u6b65\u9aa4\uff08Win10\uff09pgadmin 4 \u6d4f\u89c8\u5668\u6253\u5f00\u5361\u5728\u5708\u5708\u7684\u4f4d\u7f6e"},"content":{"rendered":"<h3 style=\"font-weight: bold; color: #4f4f4f;\">\u68a6\u7fd4\u513f\u5728\u88c5\u5230\u6700\u540e\u5361\u5728\u5708\u5708\u7684\u4f4d\u7f6e\uff0c\u89e3\u51b3\u662f<\/h3>\n<p><span style=\"color: #4d4d4d;\">\u5b89\u88c5\u6b65\u4e2d\uff0c\u9009\u62e9\u6570\u636e\u5e93\u5b58\u50a8\u533a\u57df\u7684\u8fd0\u884c\u65f6\u8bed\u8a00\u73af\u5883\uff08\u5b57\u7b26\u7f16\u7801\u683c\u5f0f\uff09\u3002\u4e00\u5b9a\u8981<span style=\"color: #ff0000;\">\u9009\u62e9C<\/span>\u3002\u5426\u5219pgadmin 4\u7684browse\u754c\u9762\u4f1a\u753b\u5708\u5708\u4e0d\u52a8\u3002<\/span><br style=\"color: #4d4d4d;\" \/>\u5982\u679c\u8fd8\u5361\u7740\u5c31\uff1a<\/p>\n<p style=\"color: #4d4d4d;\">1. \u6253\u5f00\u6ce8\u518c\u8868 Win+R cmd<\/p>\n<p style=\"color: #4d4d4d;\">2. \u5728HKEY_CLASSES_ROOT\u4e0b<\/p>\n<p style=\"color: #4d4d4d;\">3.\u627e\u5230.js\uff0c\u5355\u51fb.js\uff0c\u770b\u53f3\u8fb9\u7684Content Type\uff0c\u628a\u503ctext\/*** \u6539\u4e3a<span style=\"color: #ff0000;\">text\/javascript<\/span><\/p>\n<p style=\"color: #4d4d4d;\">4.\u6258\u76d8\u56fe\u6807\u91cc\uff0c\u53f3\u952e\u5c0f\u8c61\uff0cshutdown, \u518d\u5f00\u59cb\u83dc\u5355\u91cc\u91cd\u65b0\u6253\u5f00\uff0c\u5373\u91cd\u542f\u4e00\u4e0b pgadmin 4.<\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\">\uff1d\uff1d\uff1d\uff1d\u5177\u4f53\u5b89\u88c5\uff1d\uff1d\uff1d<\/h3>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><span style=\"font-weight: normal; color: #3399ea;\">1. \u83b7\u53d6\u5b89\u88c5\u5305<\/span><\/h3>\n<p>1.\u4e0b\u8f7d\uff1a<\/p>\n<p>https:\/\/www.enterprisedb.com\/downloads\/postgres-postgresql-downloads<\/p>\n<p>\u76f4\u8fbe\uff1a<\/p>\n<p>https:\/\/get.enterprisedb.com\/postgresql\/postgresql-13.1-1-windows-x64.exe<\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><span style=\"font-weight: normal; color: #3399ea;\">2. \u5f00\u59cb\u5b89\u88c5<\/span><\/h3>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/2018090913540156\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t3\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t3\"><\/a><span style=\"font-weight: normal; color: #3399ea;\">3. \u9009\u62e9\u7a0b\u5e8f\u5b89\u88c5\u76ee\u5f55<\/span><\/h3>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909135538903\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t4\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t4\"><\/a><span style=\"font-weight: normal; color: #3399ea;\">4\u3001\u9009\u62e9\u6570\u636e\u5b58\u653e\u76ee\u5f55<\/span><\/h3>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909140509459\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t5\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t5\"><\/a><span style=\"font-weight: normal; color: #3399ea;\">5\u3001\u8f93\u5165\u6570\u636e\u5e93\u8d85\u7ea7\u7528\u6237\u548c\u521b\u5efa\u7684OS\u7528\u6237\u7684\u5bc6\u7801<\/span><\/h3>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909140642714\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<p style=\"color: #4d4d4d;\">\u6ce8\uff1a\u6570\u636e\u5e93\u8d85\u7ea7\u7528\u6237\u662f\u4e00\u4e2a\u975e\u7ba1\u7406\u5458\u8d26\u6237\uff0c\u8fd9\u662f\u4e3a\u4e86\u51cf\u5c11\u9ed1\u5ba2\u5229\u7528\u5728 PostgreSQL \u53d1\u73b0\u7684\u7f3a\u9677\u5bf9\u7cfb\u7edf\u9020\u6210\u635f\u5bb3\uff0c\u56e0\u6b64\u9700\u8981\u5bf9\u6570\u636e\u5e93\u8d85\u7ea7\u7528\u6237\u8bbe\u7f6e\u5bc6\u7801\u3002<\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t6\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t6\"><\/a><span style=\"font-weight: normal; color: #3399ea;\">6\u3001\u8bbe\u7f6e\u670d\u52a1\u76d1\u542c\u7aef\u53e3\uff0c\u9ed8\u8ba4\u4e3a5432<\/span><\/h3>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909140807896\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t7\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t7\"><\/a><span style=\"font-weight: normal; color: #3399ea;\">7\u3001\u9009\u62e9\u8fd0\u884c\u65f6\u8bed\u8a00\u73af\u5883<\/span><\/h3>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/2018090914084126\" alt=\"\" width=\"549\" height=\"431\" \/><\/p>\n<p style=\"color: #4d4d4d;\">\u6ce8\uff1a\u9009\u62e9\u6570\u636e\u5e93\u5b58\u50a8\u533a\u57df\u7684\u8fd0\u884c\u65f6\u8bed\u8a00\u73af\u5883\uff08\u5b57\u7b26\u7f16\u7801\u683c\u5f0f\uff09\u3002<br \/>\n\u5728\u9009\u62e9\u8bed\u8a00\u73af\u5883\u65f6\uff0c\u82e5\u9009\u62e9&#8221;default locale&#8221;\u4f1a\u5bfc\u81f4\u5b89\u88c5\u4e0d\u6b63\u786e\uff1b\u540c\u65f6\uff0cPostgreSQL \u4e0d\u652f\u6301 GBK \u548c GB18030 \u4f5c\u4e3a\u5b57\u7b26\u96c6\uff0c\u5982\u679c\u9009\u62e9\u5176\u5b83\u56db\u4e2a\u4e2d\u6587\u5b57\u7b26\u96c6\uff1a\u4e2d\u6587\u7e41\u4f53 \u9999\u6e2f\uff08Chinese[Traditional], Hong Kong S.A.R.\uff09\u3001\u4e2d\u6587\u7b80\u4f53 \u65b0\u52a0\u5761\uff08Chinese[Simplified], Singapore\uff09\u3001\u4e2d\u6587\u7e41\u4f53 \u53f0\u6e7e\uff08Chinese[Traditional], Taiwan\uff09\u548c\u4e2d\u6587\u7e41\u4f53 \u6fb3\u95e8\uff08Chinese[Traditional], Marco S.A.R.\uff09\uff0c\u4f1a\u5bfc\u81f4\u67e5\u8be2\u7ed3\u679c\u548c\u6392\u5e8f\u6548\u679c\u4e0d\u6b63\u786e\u3002\u5efa\u8bae\u9009\u62e9&#8221;C&#8221;\uff0c\u5373\u4e0d\u4f7f\u7528\u533a\u57df\u3002<\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t8\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t8\"><\/a><span style=\"font-weight: normal; color: #3399ea;\">8\u3001\u5b89\u88c5\u8fc7\u7a0b<\/span><\/h3>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/2018090914112254\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909141145717\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909141209273\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<h3 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t9\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t9\"><\/a><span style=\"font-weight: normal; color: #3399ea;\">9\u3001\u5b89\u88c5\u5b8c\u6210<\/span><\/h3>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909141308466\" alt=\"\" width=\"552\" height=\"432\" \/><\/p>\n<hr \/>\n<p style=\"color: #4d4d4d;\"><span style=\"font-weight: bold;\"><span style=\"color: #e579b6;\">\u5b89\u88c5\u5b8c\u6210\u540e\uff0c\u4ece\u5f00\u59cb\u6587\u4ef6\u5939\u53ef\u4ee5\u770b\u5230<\/span><\/span><\/p>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909141524608\" alt=\"\" width=\"249\" height=\"343\" \/><\/p>\n<p style=\"color: #4d4d4d;\"><span style=\"font-weight: bold;\"><span style=\"color: #e579b6;\">\u5b89\u88c5\u76ee\u5f55\u53ef\u4ee5\u770b\u5230<\/span><\/span><\/p>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909141645548\" alt=\"\" width=\"291\" height=\"396\" \/><\/p>\n<p style=\"color: #4d4d4d;\"><span style=\"color: #f33b45;\">\u5176\u4e2d\uff1adata\u5b58\u653e\u6570\u636e\u6587\u4ef6\u3001\u65e5\u5fd7\u6587\u4ef6\u3001\u63a7\u5236\u6587\u4ef6\u3001\u914d\u7f6e\u6587\u4ef6\u7b49\u3002uninstall-postgresql.exe\u7528\u4e8e\u5378\u8f7d\u5df2\u5b89\u88c5\u7684\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\u3002<\/span><\/p>\n<hr \/>\n<h2 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t10\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t10\"><\/a><span style=\"font-weight: normal; color: #f33b45;\">\u4e8c\u3001pgAdmin\uff08\u5927\u8c61\uff09<\/span><\/h2>\n<p style=\"color: #4d4d4d;\">PostgreSQL\u5c31\u6709\u597d\u51e0\u6b3e\u6d41\u884c\u7684\u7ba1\u7406\u5de5\u5177\uff0c\u4f8b\u5982\uff1apgAdmin\u3001navicat_pgsql\u3001phppgsql\u7b49\u3002<br \/>\npgAdmin\u662f\u4e00\u4e2a\u9488\u5bf9PostgreSQL\u6570\u636e\u5e93\u7684\u8bbe\u8ba1\u548c\u7ba1\u7406\u63a5\u53e3\uff0c\u53ef\u4ee5\u5728\u5927\u591a\u6570\u64cd\u4f5c\u7cfb\u7edf\u4e0a\u8fd0\u884c\u3002\u8f6f\u4ef6\u7528C++\u7f16\u5199\uff0c\u5177\u6709\u5f88\u4f18\u79c0\u7684\u6027\u80fd\u3002<br \/>\npgadmin \u662f\u4e0e Postgres \u5206\u5f00\u53d1\u5e03\u7684\uff0c\u53ef\u4ee5\u4ece<a style=\"color: #6795b5;\" href=\"http:\/\/www.pgadmin.org\/\">www.pgadmin.org<\/a>\u4e0b\u8f7d\u3002\u76ee\u524d\u88c5\u4e2a\u5168\u529f\u80fd\u7684PostgreSQL\u6570\u636e\u5e93\uff0c\u81ea\u5e26\u8be5\u7ba1\u7406\u5de5\u5177\u3002<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909143132597\" alt=\"\" width=\"249\" height=\"343\" \/><\/p>\n<p style=\"color: #4d4d4d;\"><span style=\"color: #e579b6;\"><span style=\"font-weight: bold;\">\u6253\u5f00\u7684\u8fc7\u7a0b\u9700\u8981\u8f93\u5165\u5bc6\u7801\uff0c\u5373\u8f93\u5165\u4e4b\u524d\u5b89\u88c5PostgreSQL \u7684\u5bc6\u7801\u5373\u53ef\u3002\u663e\u793a\u5982\u4e0b\u6548\u679c<\/span><\/span><\/p>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909143005711\" alt=\"\" width=\"1200\" height=\"635\" \/><\/p>\n<p style=\"color: #4d4d4d;\"><span style=\"color: #e579b6;\">\u6570\u636e\u5e93\u4e2d\uff0c\u9ed8\u8ba4\u5df2\u6709\u4e00\u4e2apostgres\u6570\u636e\u5e93\u3002<\/span><\/p>\n<h2 style=\"font-weight: bold; color: #4f4f4f;\"><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t11\"><\/a><a style=\"font-weight: normal; color: #4ea1db;\" name=\"t11\"><\/a><span style=\"font-weight: normal; color: #f33b45;\">\u4e09\u3001psql<\/span><\/h2>\n<p style=\"color: #4d4d4d;\">\u6bcf\u79cd\u6570\u636e\u5e93\u7ba1\u7406\u7cfb\u7edf\uff0c\u90fd\u4f1a\u63d0\u4f9b\u4e00\u4e2a\u547d\u4ee4\u884c\u7ba1\u7406\u63a5\u53e3\uff0c\u4f8b\u5982Oracle\u7684sqlplus\uff0cSQL Server\u7684isql\u548cosql\u7b49\u3002<br \/>\n\u51e1\u662f\u7528\u56fe\u5f62\u7ba1\u7406\u754c\u9762\u53ef\u4ee5\u5b9e\u73b0\u7684\u529f\u80fd\u539f\u5219\u4e0a\u90fd\u53ef\u4ee5\u901a\u8fc7\u547d\u4ee4\u884c\u754c\u9762\u547d\u4ee4\u5b9e\u73b0\u3002\u4e24\u8005\u5404\u6709\u4f18\u7f3a\u70b9\uff0c\u4f7f\u7528\u573a\u5408\u4e0d\u540c\u3002\u5728windows\u4e0b\u5f53\u7136\u5e38\u7528\u56fe\u5f62\u7ba1\u7406\u754c\u9762\uff0c\u56e0\u4e3a\u5728\u56fe\u50cf\u7ba1\u7406\u754c\u9762\u4e2d\u5f80\u5f80\u90fd\u5d4c\u6709\u547d\u4ee4\u884c\u5de5\u5177\uff0c\u800c\u5728unix\u548clinux\u4e0b\uff0c\u5f53\u7136\u5c31\u5e38\u7528\u547d\u4ee4\u884c\u5de5\u5177\u4e86\uff0c\u9664\u4e86\u6211\u4eec\u5728\u7c7bunix\u4e0b\u4e3b\u8981\u4f7f\u7528\u5b57\u7b26\u754c\u9762\u7684\u539f\u56e0\u5916\uff0c\u8fd8\u56e0\u4e3a\u5927\u90e8\u5206\u60c5\u51b5\u4e0b\u6211\u4eec\u53ea\u80fd\u901a\u8fc7telnet\u6216ssh\u5de5\u5177\u8fdc\u7a0b\u8fde\u63a5\u670d\u52a1\u5668\u8fdb\u884c\u64cd\u4f5c\uff0c\u6b64\u65f6\u4e5f\u53ea\u80fd\u4f7f\u7528\u547d\u4ee4\u884c\u4e86\u3002<br \/>\n<span style=\"color: #e579b6;\"><span style=\"font-weight: bold;\">\u4ece\u5f00\u59cb\u76ee\u5f55\u6253\u5f00SQL shell\uff08psql\uff09\uff0c\u8f93\u5165\u5bc6\u7801\u5f97\u5230\u5982\u4e0b\u56fe\u754c\u9762\uff1a<\/span><\/span><\/p>\n<p style=\"color: #4d4d4d;\"><img loading=\"lazy\" decoding=\"async\" class=\"has\" src=\"https:\/\/img-blog.csdn.net\/20180909144228791\" alt=\"\" width=\"979\" height=\"512\" \/><\/p>\n<p>\u90e8\u5206\u53c2\u8003\u81ea\uff1a<\/p>\n<p>https:\/\/blog.csdn.net\/u012325865\/article\/details\/81951916<\/p>\n<p>https:\/\/blog.csdn.net\/lishun1422840684\/article\/details\/111874268<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u68a6\u7fd4\u513f\u5728\u88c5\u5230\u6700\u540e\u5361\u5728\u5708\u5708\u7684\u4f4d\u7f6e\uff0c\u89e3\u51b3\u662f \u5b89\u88c5\u6b65\u4e2d\uff0c\u9009\u62e9\u6570\u636e\u5e93\u5b58\u50a8\u533a\u57df\u7684\u8fd0\u884c\u65f6\u8bed\u8a00\u73af\u5883\uff08\u5b57\u7b26\u7f16\u7801\u683c\u5f0f\uff09\u3002\u4e00\u5b9a\u8981\u9009\u62e9C\u3002\u5426\u5219pgadmin 4\u7684browse\u754c\u9762\u4f1a\u753b\u5708\u5708\u4e0d\u52a8\u3002\u5982\u679c\u8fd8\u5361\u7740\u5c31\uff1a 1. \u6253\u5f00\u6ce8\u518c\u8868 Win+R cmd 2. \u5728HKEY &#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-272","post","type-post","status-publish","format-standard","hentry","category-16"],"_links":{"self":[{"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/272","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=272"}],"version-history":[{"count":1,"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/272\/revisions"}],"predecessor-version":[{"id":273,"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/272\/revisions\/273"}],"wp:attachment":[{"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=272"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jichangqing.net\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}