{"id":18807,"date":"2025-08-04T08:27:18","date_gmt":"2025-08-04T00:27:18","guid":{"rendered":"https:\/\/blog.ywdevops.cn\/?p=18807"},"modified":"2026-07-03T09:42:36","modified_gmt":"2026-07-03T01:42:36","slug":"kingbase","status":"publish","type":"post","link":"https:\/\/blog.ywdevops.cn\/index.php\/2025\/08\/04\/kingbase\/","title":{"rendered":"\u4eba\u5927\u91d1\u4ed3(Kingbase)\u6570\u636e\u5e93\u90e8\u7f72"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">KingBase\u6570\u636e\u5e93\u662f\u4e00\u6b3e\u56fd\u4ea7\u6570\u636e\u5e93\uff0c\u5168\u540d\u53eb\u4eba\u5927\u91d1\u4ed3\u6570\u636e\u5e93\uff0c\u76ee\u524d\u4e5f\u662f\u4fe1\u521b\u6570\u636e\u5e93\u4e4b\u4e00\uff0c\u5b98\u7f51\u6709\u591a\u4e2a\u7248\u672c\uff0c\u6709\u517c\u5bb9Mysql\u7684\uff0c\u6709\u517c\u5bb9Oracle\u7684\uff0c\u6211\u8fd9\u91cc\u9009\u62e9\u4e86\u7b2c\u4e00\u4e2a\uff0c\u9ed8\u8ba4\u7684\u7248\u672c\uff0cV9\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"659\" height=\"350\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1.png\" alt=\"\" class=\"wp-image-18810\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1.png 659w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-300x159.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-600x319.png 600w\" sizes=\"auto, (max-width: 659px) 100vw, 659px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u8fd9\u4e2a\u7248\u672c\u6839\u636e\u540e\u671f\u5b89\u88c5\u5b8c\u4f7f\u7528\u7684\u60c5\u51b5\u6765\u770b\uff0c\u5e94\u8be5\u662f\u4e00\u4e2apostgresql\u589e\u5f3a\u7248\uff0c\u6240\u4ee5\uff0c\u8fd9\u662f\u6df1\u5ea6\u4fee\u6539\u8fc7\u7684<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u6570\u636e\u5e93\u548c\u6388\u6743\u6587\u4ef6\u4e0b\u8f7d\u94fe\u63a5\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>https:&#47;&#47;www.kingbase.com.cn\/download.html\nhttps:\/\/www.kingbase.com.cn\/download.html#authorization?authorcurrV=V9R1C2B14<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">1\u3001\u521b\u5efa\u666e\u901a\u7528\u6237\uff0c\u4e0d\u5141\u8bb8\u4f7f\u7528root\u5b89\u88c5\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>useradd&nbsp;-m kingbase\npasswd kingbase<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">2\u3001\u521b\u5efa\u6302\u8f7d\u76ee\u5f55\u548c\u5b89\u88c5\u76ee\u5f55\uff0c\u8981\u5c06iso\u6587\u4ef6\u6302\u8f7d\u624d\u80fd\u5b89\u88c5\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>mkdir&nbsp;-p \/opt\/kingbase &nbsp; &nbsp;#\u6302\u8f7d\u76ee\u5f55\uff0cios\u6302\u8f7d\u5230\u8fd9\u91cc&nbsp;\nchown&nbsp;-R kingbase:kingbase \/opt\/kingbase\nmkdir&nbsp;-p \/data\/kingbase &nbsp; &nbsp;#\u5b89\u88c5\u76ee\u5f55&nbsp;\nchown&nbsp;-R kingbase:kingbase &nbsp;\/data\/kingbase<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">3\u3001\u4fee\u6539\u5185\u6838\u53c2\u6570\uff0cvim \/etc\/sysctl.conf \u7136\u540e\u6267\u884csysctl -p\u00a0\u751f\u6548\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>fs.aio-max-nr=1048576\nfs.file-max=&nbsp;6815744\nkernel.shmall=2097152\nkernel.shmmax=&nbsp;4294967295\nkernel.shmmni=&nbsp;4096\nkernel.sem=&nbsp;250&nbsp;32000&nbsp;100&nbsp;128\nnet.ipv4.ip_local_port_range=&nbsp;9000&nbsp;65500\nnet.core.rmem_default=&nbsp;262144\nnet.core.rmem_max=&nbsp;4194304\nnet.core.wmem_default=&nbsp;262144\nnet.core.wmem_max=&nbsp;1048576\n#sysctl -a \u53ef\u4ee5\u9a8c\u8bc1\u4fee\u6539\u662f\u5426\u751f\u6548&nbsp;<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">4\u3001\u628akingbase\u7684iso\u6587\u4ef6\u4e0a\u4f20\u5230\u670d\u52a1\u5668\u6302\u8f7d\u5230\/opt\/kingbase(root\u6302\u8f7d)\uff0c\u6302\u8f7d\u540e\u53ef\u4ee5\u770b\u5230\u6587\u4ef6\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"218\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-1.png\" alt=\"\" class=\"wp-image-18814\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-1.png 652w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-1-300x100.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-1-600x201.png 600w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/figure>\n\n\n\n<p class=\"has-luminous-vivid-amber-background-color has-background wp-block-paragraph\">\u6ce8\uff1a\u6388\u6743\u6587\u4ef6\u4e5f\u8981\u4e0a\u4f20\uff0c\u653e\u7684\u4f4d\u7f6e\u81ea\u5b9a\u4e49<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">5\u3001\u5b89\u88c5\u4e4b\u524d\u5148\u67e5\u770b\u4e0b\u5f53\u524d\u7cfb\u7edf\u8bed\u8a00\uff0c\u5982\u679c\u663e\u793a\u5982\u4e0b\u56fe\uff0c\u8868\u793a\u652f\u6301\u4e2d\u6587\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"653\" height=\"73\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3.png\" alt=\"\" class=\"wp-image-18816\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3.png 653w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-300x34.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-600x67.png 600w\" sizes=\"auto, (max-width: 653px) 100vw, 653px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">6\u3001\u5207\u6362\u5230kingbase\u7528\u6237\uff0c\u8fdb\u5165\u5230\/opt\/kingbase\u76ee\u5f55\uff0c\u6267\u884c\u5982\u4e0b\u547d\u4ee4\u5b89\u88c5\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>sh setup.sh&nbsp;-i&nbsp;console<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">\u4f1a\u63d0\u793a\u9605\u8bfb\u8bf4\u660e\u6587\u5b57\uff0c\u76f4\u63a5\u4e00\u76f4\u6309ENTER\u952e\u7ee7\u7eed\uff0c\u5728\u662f\u5426\u63a5\u53d7\u8bb8\u53ef\u534f\u8bae\u4f4d\u7f6e\u9009\u62e9Y\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"197\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4.png\" alt=\"\" class=\"wp-image-18817\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4.png 650w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-300x91.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-600x182.png 600w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b89\u88c5\u96c6\u4f4d\u7f6e\u9009\u62e9&#8221;\u5b8c\u5168\u5b89\u88c5&#8221;\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"649\" height=\"262\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/5.png\" alt=\"\" class=\"wp-image-18818\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/5.png 649w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/5-300x121.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/5-600x242.png 600w\" sizes=\"auto, (max-width: 649px) 100vw, 649px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u6307\u5b9a\u6388\u6743\u6587\u4ef6\u4f4d\u7f6e\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"646\" height=\"89\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/6.png\" alt=\"\" class=\"wp-image-18819\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/6.png 646w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/6-300x41.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/6-600x83.png 600w\" sizes=\"auto, (max-width: 646px) 100vw, 646px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u6307\u5b9a\u5b89\u88c5\u76ee\u5f55\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"653\" height=\"198\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-1.png\" alt=\"\" class=\"wp-image-18821\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-1.png 653w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-1-300x91.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-1-600x182.png 600w\" sizes=\"auto, (max-width: 653px) 100vw, 653px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u63a5\u4e0b\u6765\u90fd\u53ef\u4ee5\u9ed8\u8ba4\uff0c\u5305\u62ec\u7aef\u53e3\uff0c\u5982\u679c\u4e0d\u4fee\u6539\uff0c\u9ed8\u8ba4\u5c31\u662f54321\uff0c\u8bbe\u7f6e\u7ba1\u7406\u5458\u5bc6\u7801\uff0c\u5982\u679c\u4e0d\u8bbe\u7f6e\u7ba1\u7406\u5458\u9ed8\u8ba4\u5c31\u662fsystem\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"311\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-2.png\" alt=\"\" class=\"wp-image-18822\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-2.png 650w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-2-300x144.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-2-600x287.png 600w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u7f16\u7801\u9009\u62e9UTF8\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"650\" height=\"224\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-1.png\" alt=\"\" class=\"wp-image-18823\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-1.png 650w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-1-300x103.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-1-600x207.png 600w\" sizes=\"auto, (max-width: 650px) 100vw, 650px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u8bed\u8a00\u6839\u636e\u9700\u8981\u9009\u62e9\uff0c\u6211\u8fd9\u91cc\u9009\u62e9\u4e2d\u6587\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"651\" height=\"182\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-1.png\" alt=\"\" class=\"wp-image-18824\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-1.png 651w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-1-300x84.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-1-600x168.png 600w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u6570\u636e\u5e93\u517c\u5bb9\u6a21\u5f0f\u4f4d\u7f6e\uff0c\u53ef\u4ee5\u6839\u636e\u81ea\u5df1\u9700\u8981\u9009\u62e9\u4e86\uff0c\u6211\u8fd9\u91cc\u9009\u62e9Mysql\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"241\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/5-1.png\" alt=\"\" class=\"wp-image-18825\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/5-1.png 654w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/5-1-300x111.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/5-1-600x221.png 600w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Mysql\u6a21\u5f0f\u4e0b\u5927\u5c0f\u5199\u654f\u611f\u9700\u8981\u9009\u62e9\u5426\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"351\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/6-1.png\" alt=\"\" class=\"wp-image-18826\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/6-1.png 652w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/6-1-300x162.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/6-1-600x323.png 600w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u5b58\u50a8\u5757\u5927\u5c0f\uff0c\u8fd9\u91cc\u9009\u62e9Mysql\u7684\u9ed8\u8ba4\u503c16k\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"648\" height=\"246\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/7.png\" alt=\"\" class=\"wp-image-18827\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/7.png 648w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/7-300x114.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/7-600x228.png 600w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u8eab\u4efd\u8ba4\u8bc1\u65b9\u6cd5\uff0c\u8fd9\u91cc\u9009\u62e92\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"269\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/8.png\" alt=\"\" class=\"wp-image-18828\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/8.png 652w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/8-300x124.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/8-600x248.png 600w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u51e0\u79cd\u8ba4\u8bc1\u65b9\u6cd5\u7684\u533a\u522b\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table><tbody><tr><td class=\"has-text-align-center\" data-align=\"center\">\u540d\u79f0<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u7c7b\u578b<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u7528\u9014<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u56fd\u5bc6\u6807\u51c6<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">SCRAM-SHA-256<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u8ba4\u8bc1\u534f\u8bae+\u54c8\u5e0c\u7b97\u6cd5<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5bc6\u7801\u8ba4\u8bc1\uff08\u56fd\u9645\u901a\u7528\uff09<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u4e0d\u652f\u6301<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">SCRAM-SM3<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u8ba4\u8bc1\u534f\u8bae+\u54c8\u5e0c\u7b97\u6cd5<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5bc6\u7801\u8ba4\u8bc1\uff08\u4e2d\u56fd\u56fd\u5bc6\u66ff\u4ee3\u65b9\u6848\uff09<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u652f\u6301<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">SM3<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u54c8\u5e0c\u7b97\u6cd5<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6570\u636e\u5b8c\u6574\u6027\u6821\u9a8c\/\u6570\u5b57\u7b7e\u540d<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u652f\u6301<\/td><\/tr><tr><td class=\"has-text-align-center\" data-align=\"center\">SM4<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u5bf9\u79f0\u52a0\u5bc6\u7b97\u6cd5<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u6570\u636e\u52a0\u5bc6<\/td><td class=\"has-text-align-center\" data-align=\"center\">\u652f\u6301<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">\u63d0\u793a\u5df2\u7ecf\u5b89\u88c5\u6210\u529f\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"652\" height=\"248\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/9.png\" alt=\"\" class=\"wp-image-18829\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/9.png 652w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/9-300x114.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/9-600x228.png 600w\" sizes=\"auto, (max-width: 652px) 100vw, 652px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">7\u3001\u542f\u52a8kingbase\uff0c\u5148\u8fdb\u5165\u5230bin\u76ee\u5f55\u540e\u6267\u884c\u542f\u52a8\u547d\u4ee4\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>cd&nbsp;\/data\/kingbase\/KESRealPro\/V009R001C002B0014\/Server\/bin\n.\/sys_ctl start -D \/data\/kingbase\/data\/<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"657\" height=\"274\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-2.png\" alt=\"\" class=\"wp-image-18830\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-2.png 657w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-2-300x125.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/1-2-600x250.png 600w\" sizes=\"auto, (max-width: 657px) 100vw, 657px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">8\u3001\u6267\u884c\u547d\u4ee4\u767b\u5f55\u6570\u636e\u5e93\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>.\/ksql -U system -W&nbsp;test&nbsp; &nbsp;##test\u662f\u9ed8\u8ba4\u7684\u81ea\u5e26\u7684\u6570\u636e\u5e93<\/code><\/pre>\n\n\n\n<p class=\"wp-block-paragraph\">9\u3001\u67e5\u770b\u6570\u636e\u5e93\u4fe1\u606f\uff0c\u8fd9\u754c\u9762\uff0c\u8ddfpgsql\u57fa\u672c\u6ca1\u4e24\u6837\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"264\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-3.png\" alt=\"\" class=\"wp-image-18831\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-3.png 654w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-3-300x121.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/2-3-600x242.png 600w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">10\u3001\u521b\u5efa\u6570\u636e\u5e93\uff0c\u521b\u5efa\u8868\uff0c\u63d2\u5165\u6570\u636e\uff0c\u67e5\u8be2\u6570\u636e\uff0c\u5982\u56fe\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"651\" height=\"152\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-2.png\" alt=\"\" class=\"wp-image-18832\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-2.png 651w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-2-300x70.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/3-2-600x140.png 600w\" sizes=\"auto, (max-width: 651px) 100vw, 651px\" \/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"648\" height=\"243\" src=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-2.png\" alt=\"\" class=\"wp-image-18833\" srcset=\"https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-2.png 648w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-2-300x113.png 300w, https:\/\/blog.ywdevops.cn\/wp-content\/uploads\/2025\/08\/4-2-600x225.png 600w\" sizes=\"auto, (max-width: 648px) 100vw, 648px\" \/><\/figure>\n\n\n\n<p class=\"has-luminous-vivid-amber-background-color has-background wp-block-paragraph\">\u6ce8\uff1a\u5207\u6362\u6570\u636e\u5e93\u5c45\u7136\u4e5f\u8981\u8f93\u5165\u5bc6\u7801\uff0c\u4e0d\u592a\u7406\u89e3\u8fd9\u64cd\u4f5c\uff0c\u53cd\u6b63\u6570\u636e\u5bc6\u7801\u5c31\u80fd\u5207\u4e86<\/p>\n","protected":false},"excerpt":{"rendered":"<p>KingBase\u6570\u636e\u5e93\u662f\u4e00\u6b3e\u56fd\u4ea7\u6570\u636e\u5e93\uff0c\u5168\u540d\u53eb\u4eba\u5927\u91d1\u4ed3\u6570\u636e\u5e93\uff0c\u76ee\u524d\u4e5f\u662f\u4fe1\u521b\u6570\u636e\u5e93\u4e4b\u4e00\uff0c\u5b98\u7f51\u6709\u591a\u4e2a\u7248\u672c\uff0c\u6709\u517c\u5bb9M [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":18808,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[],"class_list":["post-18807","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[],"version":8}},"_links":{"self":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/18807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/comments?post=18807"}],"version-history":[{"count":8,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/18807\/revisions"}],"predecessor-version":[{"id":20531,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/posts\/18807\/revisions\/20531"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/media\/18808"}],"wp:attachment":[{"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/media?parent=18807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/categories?post=18807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ywdevops.cn\/index.php\/wp-json\/wp\/v2\/tags?post=18807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}