{"id":115374,"date":"2024-04-08T12:43:32","date_gmt":"2024-04-08T04:43:32","guid":{"rendered":"http:\/\/www.zhushiyao.com\/?p=115374"},"modified":"2024-04-08T12:43:32","modified_gmt":"2024-04-08T04:43:32","slug":"windows-server-%e5%ae%89%e8%a3%85postgresql-1112-%e5%87%ba%e9%94%99-postgresql%e6%9c%8d%e5%8a%a1%e6%97%a0%e6%b3%95%e5%90%af%e5%8a%a8","status":"publish","type":"post","link":"http:\/\/www.zhushiyao.com\/?p=115374","title":{"rendered":"windows server \u5b89\u88c5PostgreSQL 11,12 \u51fa\u9519 PostgreSQL\u670d\u52a1\u65e0\u6cd5\u542f\u52a8"},"content":{"rendered":"\n

\u4f1a\u51fa\u73b0\u8fd9\u4e2a\u8b66\u544a\uff0c\u610f\u601d\u662f\u6570\u636e\u5e93\u76ee\u5f55\u521d\u59cb\u5316\u5931\u8d25\uff0c\u8fd9\u4e5f\u662fPostgreSQL\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\u7684\u6839\u672c\u539f\u56e0<\/strong><\/p>\n\n\n\n

\u6211\u4eec\u7ee7\u7eed\u70b9ok\uff0c\u5b89\u88c5\u5b8c\u6bd5\u3002<\/p>\n\n\n\n

\u4e0b\u4e00\u6b65cmd\u53f3\u952e\u4ee5\u7ba1\u7406\u5458\u8eab\u4efd\u8fd0\u884c<\/p>\n\n\n\n

cd\u5b9a\u4f4d\u5230\u4f60\u5b89\u88c5\u597d\u7684postgresql\u7684bin\u76ee\u5f55\uff1acd \/d F:\\PostgreSQL\\bin<\/p>\n\n\n\n

\u5173\u952e\u70b9\uff1a\u4e0b\u9762\u8fd9\u4e2aCMD\u6307\u4ee4\u662f\u521d\u59cb\u5316\u6570\u636e\u5e93\u76ee\u5f55\uff01\u4fee\u590d\u4e0a\u9762\u7684\u8b66\u544a
\u6ca1\u6709\u521d\u59cb\u5316\u6570\u636e\u5e93\u6570\u636e\u96c6\u5c31\u65e0\u6cd5\u542f\u52a8\u670d\u52a1
\/\/\u6267\u884c\u4e0b\u9762\u7684\u6307\u4ee4\uff0c..\/data\u6307\u7684\u662fpostgresql\u7684\u6570\u636e\u5e93\u76ee\u5f55\uff0c\u6211\u4eec\u6267\u884c\u521d\u59cb\u5316
initdb.exe -D ..\/data<\/strong><\/p>\n\n\n\n

\u6267\u884c\u5b8c\u6bd5\u4e4b\u540e\u6211\u4eec\u7684data\u76ee\u5f55\u4f1a\u51fa\u73b0\u5f88\u591a\u521d\u59cb\u5316\u6587\u4ef6\uff0c\u8fd9\u65f6\u5019\u6211\u4eec\u91cd\u542f\u6216\u542f\u52a8postgresql\u670d\u52a1
\u91cd\u542f\u6216\u542f\u52a8\u5931\u8d25\u662f\u6ca1\u6709postgresql\u670d\u52a1\uff0c\u8fd9\u65f6\u5019\u9700\u8981\u5728 CMD \u547d\u4ee4\u884c\u4e2d\u624b\u52a8\u6ce8\u518c\u670d\u52a1<\/strong>
\/\/\u540c\u6837\u5728CMD\u91cc\u6267\u884c\u4e0b\u9762\u6307\u4ee4\u6ce8\u518c\u670d\u52a1\uff01\uff08\u4f60\u7684CMD\u4e00\u5b9a\u8981CD\u5230PostgreSQL\u4e2d\u7684bin\u76ee\u5f55\uff09<\/p>\n\n\n\n

pg_ctl.exe register -N “\u670d\u52a1\u540d” -D PostgreSQL\u4e2d\u7684data\uff08\u6570\u636e\u5e93\uff09\u76ee\u5f55\u7684\u7edd\u5bf9\u8def\u5f84<\/p>\n\n\n\n

pg_ctl.exe register -N “pgsql” -D F:\\PostgreSQL\\data<\/strong><\/p>\n\n\n\n


7.\u542f\u52a8postgresql\u670d\u52a1\uff08\u65e0\u6cd5\u542f\u52a8\u662f\u56e0\u4e3a\u6ca1\u6709\u521d\u59cb\u5316\u6570\u636e\u5e93initdb.exe -D ..\/data\uff09<\/p>\n\n\n\n

8.\u8fde\u63a5\u6570\u636e\u5e93\uff08\u672c\u4eba\u4f7f\u7528Navicat\u8fde\u63a5\uff09<\/p>\n\n\n\n

\u53d1\u73b0\u62a5\u9519\u8fde\u4e0d\u4e0a\uff0c\u5982\u4e0b<\/p>\n\n\n\n

\uff01\uff01\uff01\u6570\u636e\u5e93\u8fde\u63a5\u7528\u6237\u540d\u5176\u5b9e\u662f\u4f60 win\u672c\u5730\u8d26\u53f7\u7684\u7528\u6237\u540d\uff01\uff01\uff01<\/p>\n\n\n\n

\u76f4\u63a5\u4f7f\u7528kaou\u5f53\u4f5c\u7528\u6237\u540d\u65e2\u53ef\u8fde\u63a5\u6570\u636e\u5e93\uff0c\u5982\u679c\u4e0d\u884c\u53ef\u4ee5\u6309\u7167\u4e0b\u9762\u7684\u64cd\u4f5c\u521b\u5efa\u4e00\u4e2a<\/p>\n\n\n\n

\u68c0\u67e5\u7528\u6237\u662f\u5426\u5b58\u5728\u95ee\u9898
\uff08CMD\u7a97\u53e3\uff09F:\\postgresql\\bin>psql -U postgres
\uff08powershell\u7a97\u53e3\uff09F:\\postgresql\\bin> .\\psql -U postgres<\/p>\n\n\n\n

postgres\u4e0d\u5b58\u5728\uff0c\u6211\u4eec\u90a3\u5c31\u521b\u5efa\u8fd9\u4e2a\u7528\u6237
\u521b\u5efa\u7528\u6237
\uff08CMD\u7a97\u53e3\uff09F:\\postgresql\\bin>createuser -s -r postgres<\/strong>
\uff08powershell\u7a97\u53e3\uff09F:\\postgresql\\bin> .\\createuser -s -r postgres
\u7136\u540e\u5c31\u53ef\u4ee5\u8fde\u63a5\uff0c\u6210\u529f\u4e86\uff01
\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014\u2014<\/p>\n\n\n\n

\u539f\u6587\u94fe\u63a5\uff1ahttps:\/\/blog.csdn.net\/qq_38863151\/article\/details\/120819021<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4f1a\u51fa\u73b0\u8fd9\u4e2a\u8b66\u544a\uff0c\u610f\u601d\u662f\u6570\u636e\u5e93\u76ee\u5f55\u521d\u59cb\u5316\u5931\u8d25\uff0c\u8fd9\u4e5f\u662fPostgreSQL\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\u7684\u6839\u672c\u539f\u56e0 \u6211\u4eec\u7ee7\u7eed\u70b9ok\uff0c … \u7ee7\u7eed\u9605\u8bfb\u201cwindows server \u5b89\u88c5PostgreSQL 11,12 \u51fa\u9519 PostgreSQL\u670d\u52a1\u65e0\u6cd5\u542f\u52a8\u201d<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[9],"_links":{"self":[{"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=\/wp\/v2\/posts\/115374"}],"collection":[{"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=115374"}],"version-history":[{"count":1,"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=\/wp\/v2\/posts\/115374\/revisions"}],"predecessor-version":[{"id":115375,"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=\/wp\/v2\/posts\/115374\/revisions\/115375"}],"wp:attachment":[{"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=115374"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=115374"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.zhushiyao.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=115374"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}