{"id":641,"date":"2026-06-16T11:44:19","date_gmt":"2026-06-16T03:44:19","guid":{"rendered":"https:\/\/julyclyde.org\/?p=641"},"modified":"2026-06-16T11:44:19","modified_gmt":"2026-06-16T03:44:19","slug":"%e6%98%a8%e5%a4%a9%e5%8f%a6%e8%a3%85%e4%ba%86%e4%b8%aavps%ef%bc%8c%e8%bf%81%e7%a7%bb%e7%b3%bb%e7%bb%9f%ef%bc%8c%e9%81%87%e5%88%b0%e4%ba%86%e5%be%88%e5%a4%9a%e9%97%ae%e9%a2%98","status":"publish","type":"post","link":"https:\/\/julyclyde.org\/?p=641","title":{"rendered":"\u6628\u5929\u53e6\u88c5\u4e86\u4e2aVPS\uff0c\u8fc1\u79fb\u7cfb\u7edf\uff0c\u9047\u5230\u4e86\u5f88\u591a\u95ee\u9898"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">\u611f\u53f9\uff0c\u786e\u5b9e\u554a\u4e0d\u80fd\u603b\u662f\u672c\u5730\u5347\u7ea7\uff0c\u8fd8\u662f\u8981\u7ecf\u5e38\u8fdb\u884c\u5168\u65b0\u5b89\u88c5\u548c\u6570\u636e\u8f6c\u79fb\u7684\uff0c\u5426\u5219\u603b\u662f\u505c\u7559\u5728\u517c\u5bb9\u6a21\u5f0f\uff0c\u89c1\u8bc6\u4e0d\u5230\u884c\u4e1a\u7684\u53d1\u5c55\u3002<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><br>\u6628\u5929\u9047\u5230\u51e0\u4e2a\u95ee\u9898\uff0c\u5148\u8bf4\u81ea\u5df1\u7684<strong>\u8d23\u4efb\u4e8b\u6545<\/strong>\uff1a<br>\u7528rsync\u4f20\u8f93home\u76ee\u5f55\uff0c\u628a\u666e\u901a\u7528\u6237\u7684home\u76ee\u5f55\u641e\u6210owned uid=0\u4e86\uff0c\u8fd9\u7528\u6237\u767b\u5f55\u4e4b\u540e\u8fdb\u4e0d\u53bb\u81ea\u5df1\u7684\u76ee\u5f55\uff0c\u5c31\u53bb\u4e86\u6839\u76ee\u5f55\u3002\u7136\u540e\u6211sudo chown\u4e86<em>\u5f53\u524d<\/em>\u76ee\u5f55\uff0c\u628a\u7cfb\u7edfbin\u76ee\u5f55\u91cc\u7684\u6587\u4ef6\u90fdchown\u4e86\uff0c\u6b64\u65f6\u5e94\u8be5\u5df2\u7ecf\u4e22\u5931\u4e86\u5f88\u591asetuid\u3002\u8d76\u7d27\u7528\u53e6\u4e00\u4e2a\u5df2\u7ecfsudo\u7684\u7a97\u53e3\u53bbchown\u56de\u6765\uff0c\u5e76\u7ed9su\u548csudo\u589e\u52a0setuid\u3002\u7136\u540e\u518d\u6267\u884cdpkg &#8211;verify\uff0c\u5374\u53d1\u73b0\u6ca1\u68c0\u67e5\u51fa\u591a\u5c11\u7ed3\u679c\u6765\uff0c\u4e0d\u77e5\u9053\u662f\u4e0d\u662fdpkg\u6839\u672c\u6ca1\u8bb0\u5f55\u539f\u59cb\u7684mode\u4fe1\u606f\uff1f\u6211\u8bb0\u5f97\u4ee5\u524drpm &#8211;verify\u5e94\u8be5\u662f\u53ef\u4ee5\u7684\u3002\u6298\u817e\u4e86\u4e00\u4f1a\u603b\u611f\u89c9\u54ea\u91cc\u4e0d\u5bf9\u52b2\uff0c\u6bd4\u5982\u7528vi\u7f16\u8f91\u6587\u4ef6\u65e0\u6cd5\u5b58\u76d8\uff0c\u7528nano\u5374\u53ef\u4ee5\u5b58\u76d8\u7b49\u73b0\u8c61\u3002\u6700\u540e\u51b3\u5b9a\u91cd\u88c5\u3002<br><br>\u518d\u8bf4\u51e0\u4ef6\u517c\u5bb9\u6027\u95ee\u9898\uff1a<br>\u6211\u5984\u56fe\u628awordpress\u7684\u6570\u636e\u5e93\u6362\u6210Postgres\uff0c\u4e8e\u662f\u7ed9wordpress\u5b89\u88c5\u4e86pg4wp\u63d2\u4ef6\u3002\u68c0\u67e5\u8fd9\u63d2\u4ef6\u53d1\u73b0\u5b83\u662f\u8fd0\u884c\u65f6\u52ab\u6301\u9a71\u52a8\u7684\uff0c\u7c7b\u4f3c\u4e8epyMySQL monkey patch\u7684\u505a\u6cd5\uff0c\u5e76\u8fdb\u884c\u4e86SQL\u65b9\u8a00\u7ffb\u8bd1\u3002\u6211\u7528pgloader\u8f6c\u79fb\u6570\u636e\u7684\u65f6\u5019\u53d1\u73b0\u51e0\u4e2a\u95ee\u9898\uff1a<br>\u4e00\u3001\u5b57\u6bb5\u540d\u5b57\u7684\u5927\u5c0f\u5199\u95ee\u9898\uff0c\u6709\u4e9bid\u6709\u4e9bID<br>\u4e8c\u3001Ubuntu\u91ccpgloader\u7248\u672c\u592a\u6587\u7269\u4e86\uff0c\u5305\u7248\u672c\u867d\u7136\u53eb3.6.10\u4f46\u5b9e\u9645\u4e0a\u662f3.6.4\uff0c\u4e0d\u652f\u6301\u67d0\u4e9b\u5b57\u6bb5\u7c7b\u578b\u3002\u641c\u52302020\u5e74\u7684issue\u8bf4\u8ba9\u5347\u7ea7\u2026\u2026<br>\u4e09\u3001MySQL\u4ece8\u7248\u672c\u5f00\u59cb\u6539\u7528\u7c7b\u4f3c\u4e8ePostgres\u548cMicrosoft SQL server\u7684\u9a8c\u8bc1\u65b9\u5f0f\uff0c\u4eceunix domain socket\u8fde\u63a5\u7684\u65f6\u5019\u76f4\u63a5\u9a8c\u8bc1\u201c\u5bf9\u65b9\u201d\u7684\u7528\u6237\u540d\uff1b\u4f46\u662fpgloader\u65e2\u4e0d\u652f\u6301unix domain socket\u4e5f\u4e0d\u652f\u6301mysql\u65b0\u7248\u672c\u7684caching sha2 password\u3002\u4e8e\u662f\u6211\u53c8\u73b0\u573a\u5b66\u4e60\u4e8630\u5e74\u524d\u5b66\u4e60\u8fc7\u4e00\u904d\u7684\u5173\u4e8emysql\u8eab\u4efd\u9a8c\u8bc1\u7684\u77e5\u8bc6\uff0c\u5e76\u6210\u529f\u7684\u628aMySQL 8\u964d\u7ea7\u5230pgloader\u80fd\u591f\u652f\u6301\u7684mysql native password\u2026\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7136\u540e\u624b\u5de5\u4fee\u6539\u5927\u5c0f\u5199\uff0c\u52c9\u5f3a\u6574\u7406\u5230\u80fd\u591f\u663e\u793a\u535a\u5ba2\u5185\u5bb9\uff0c\u4f46\u662f\u767b\u5f55\u540e\u76f4\u63a5\u8df3\u8f6c\u56de\u767b\u5f55\u9875\uff0c\u4e5f\u6ca1\u9519\u8bef\u4fe1\u606f\u4e5f\u6ca1\u9519\u8bef\u65e5\u5fd7\u2026\u2026\u4e8e\u662f\u5207\u6362\u56deMySQL\u505a\u4e86\u4e00\u4e0bWordPress\u6570\u636e\u5e93\u5347\u7ea7\uff0c\u518dpgloader\u5230Postgres\uff0c\u8fd9\u4e0b\u5f7b\u5e95\u663e\u793a\u4e0d\u4e86\u4e86\u3002\u653e\u5f03\u2026\u2026<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u611f\u53f9\uff0c\u786e\u5b9e\u554a\u4e0d\u80fd\u603b\u662f\u672c\u5730\u5347\u7ea7\uff0c\u8fd8\u662f\u8981\u7ecf\u5e38\u8fdb\u884c\u5168\u65b0\u5b89\u88c5\u548c\u6570\u636e\u8f6c\u79fb\u7684\uff0c\u5426\u5219\u603b\u662f\u505c\u7559\u5728\u517c\u5bb9\u6a21\u5f0f\uff0c\u89c1\u8bc6\u4e0d\u5230\u884c\u4e1a\u7684\u53d1\u5c55\u3002 \u6628\u5929\u9047\u5230\u51e0\u4e2a\u95ee\u9898\uff0c\u5148\u8bf4\u81ea\u5df1\u7684\u8d23\u4efb\u4e8b\u6545\uff1a\u7528rsync\u4f20\u8f93home\u76ee\u5f55\uff0c\u628a\u666e\u901a\u7528\u6237\u7684home\u76ee\u5f55\u641e\u6210owned uid=0\u4e86\uff0c\u8fd9\u7528\u6237\u767b\u5f55\u4e4b\u540e\u8fdb\u4e0d\u53bb\u81ea\u5df1\u7684\u76ee\u5f55\uff0c\u5c31\u53bb\u4e86\u6839\u76ee\u5f55\u3002\u7136\u540e\u6211sudo chown\u4e86\u5f53\u524d\u76ee\u5f55\uff0c\u628a\u7cfb\u7edfbin\u76ee\u5f55\u91cc\u7684\u6587\u4ef6\u90fdchown\u4e86\uff0c\u6b64\u65f6\u5e94\u8be5\u5df2\u7ecf\u4e22\u5931\u4e86\u5f88\u591asetuid\u3002\u8d76\u7d27\u7528\u53e6\u4e00\u4e2a\u5df2\u7ecfsudo\u7684\u7a97\u53e3\u53bbchown\u56de\u6765\uff0c\u5e76\u7ed9su\u548csudo\u589e\u52a0setuid\u3002\u7136\u540e\u518d\u6267\u884cdpkg &#8211;verify\uff0c\u5374\u53d1\u73b0\u6ca1\u68c0\u67e5\u51fa\u591a\u5c11\u7ed3\u679c\u6765\uff0c\u4e0d\u77e5\u9053\u662f\u4e0d\u662fdpkg\u6839\u672c\u6ca1\u8bb0\u5f55\u539f\u59cb\u7684mode\u4fe1\u606f\uff1f\u6211\u8bb0\u5f97\u4ee5\u524drpm &#8211;verify\u5e94\u8be5\u662f\u53ef\u4ee5\u7684\u3002\u6298\u817e\u4e86\u4e00\u4f1a\u603b\u611f\u89c9\u54ea\u91cc\u4e0d\u5bf9\u52b2\uff0c\u6bd4\u5982\u7528vi\u7f16\u8f91\u6587\u4ef6\u65e0\u6cd5\u5b58\u76d8\uff0c\u7528nano\u5374\u53ef\u4ee5\u5b58\u76d8\u7b49\u73b0\u8c61\u3002\u6700\u540e\u51b3\u5b9a\u91cd\u88c5\u3002 \u518d\u8bf4\u51e0\u4ef6\u517c\u5bb9\u6027\u95ee\u9898\uff1a\u6211\u5984\u56fe\u628awordpress\u7684\u6570\u636e\u5e93\u6362\u6210Postgres\uff0c\u4e8e\u662f\u7ed9wordpress\u5b89\u88c5\u4e86pg4wp\u63d2\u4ef6\u3002\u68c0\u67e5\u8fd9\u63d2\u4ef6\u53d1\u73b0\u5b83\u662f\u8fd0\u884c\u65f6\u52ab\u6301\u9a71\u52a8\u7684\uff0c\u7c7b\u4f3c\u4e8epyMySQL monkey patch\u7684\u505a\u6cd5\uff0c\u5e76\u8fdb\u884c\u4e86SQL\u65b9\u8a00\u7ffb\u8bd1\u3002\u6211\u7528pgloader\u8f6c\u79fb\u6570\u636e\u7684\u65f6\u5019\u53d1\u73b0\u51e0\u4e2a\u95ee\u9898\uff1a\u4e00\u3001\u5b57\u6bb5\u540d\u5b57\u7684\u5927\u5c0f\u5199\u95ee\u9898\uff0c\u6709\u4e9bid\u6709\u4e9bID\u4e8c\u3001Ubuntu\u91ccpgloader\u7248\u672c\u592a\u6587\u7269\u4e86\uff0c\u5305\u7248\u672c\u867d\u7136\u53eb3.6.10\u4f46\u5b9e\u9645\u4e0a\u662f3.6.4\uff0c\u4e0d\u652f\u6301\u67d0\u4e9b\u5b57\u6bb5\u7c7b\u578b\u3002\u641c\u52302020\u5e74\u7684issue\u8bf4\u8ba9\u5347\u7ea7\u2026\u2026\u4e09\u3001MySQL\u4ece8\u7248\u672c\u5f00\u59cb\u6539\u7528\u7c7b\u4f3c\u4e8ePostgres\u548cMicrosoft SQL server\u7684\u9a8c\u8bc1\u65b9\u5f0f\uff0c\u4eceunix domain socket\u8fde\u63a5\u7684\u65f6\u5019\u76f4\u63a5\u9a8c\u8bc1\u201c\u5bf9\u65b9\u201d\u7684\u7528\u6237\u540d\uff1b\u4f46\u662fpgloader\u65e2\u4e0d\u652f\u6301unix domain socket\u4e5f\u4e0d\u652f\u6301mysql\u65b0\u7248\u672c\u7684caching sha2 password\u3002\u4e8e\u662f\u6211\u53c8\u73b0\u573a\u5b66\u4e60\u4e8630\u5e74\u524d\u5b66\u4e60\u8fc7\u4e00\u904d\u7684\u5173\u4e8emysql\u8eab\u4efd\u9a8c\u8bc1\u7684\u77e5\u8bc6\uff0c\u5e76\u6210\u529f\u7684\u628aMySQL 8\u964d\u7ea7\u5230pgloader\u80fd\u591f\u652f\u6301\u7684mysql native password\u2026\u2026 \u7136\u540e\u624b\u5de5\u4fee\u6539\u5927\u5c0f\u5199\uff0c\u52c9\u5f3a\u6574\u7406\u5230\u80fd\u591f\u663e\u793a\u535a\u5ba2\u5185\u5bb9\uff0c\u4f46\u662f\u767b\u5f55\u540e\u76f4\u63a5\u8df3\u8f6c\u56de\u767b\u5f55\u9875\uff0c\u4e5f\u6ca1\u9519\u8bef\u4fe1\u606f\u4e5f\u6ca1\u9519\u8bef\u65e5\u5fd7\u2026\u2026\u4e8e\u662f\u5207\u6362\u56deMySQL\u505a\u4e86\u4e00\u4e0bWordPress\u6570\u636e\u5e93\u5347\u7ea7\uff0c\u518dpgloader\u5230Postgres\uff0c\u8fd9\u4e0b\u5f7b\u5e95\u663e\u793a\u4e0d\u4e86\u4e86\u3002\u653e\u5f03\u2026\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[10,15,88,87],"class_list":["post-641","post","type-post","status-publish","format-standard","hentry","category-default","tag-linux","tag-mysql","tag-postgresql","tag-wordpress"],"_links":{"self":[{"href":"https:\/\/julyclyde.org\/index.php?rest_route=\/wp\/v2\/posts\/641","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/julyclyde.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/julyclyde.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/julyclyde.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/julyclyde.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=641"}],"version-history":[{"count":0,"href":"https:\/\/julyclyde.org\/index.php?rest_route=\/wp\/v2\/posts\/641\/revisions"}],"wp:attachment":[{"href":"https:\/\/julyclyde.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=641"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/julyclyde.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=641"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/julyclyde.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=641"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}