{"id":13100,"date":"2025-04-10T08:02:23","date_gmt":"2025-04-10T00:02:23","guid":{"rendered":"https:\/\/www.gbase8.cn\/?p=13100"},"modified":"2025-04-21T09:48:22","modified_gmt":"2025-04-21T01:48:22","slug":"cloudberry-%e5%a4%9a%e8%8a%82%e7%82%b9%e9%9b%86%e7%be%a4%e5%ae%89%e8%a3%85%e9%83%a8%e7%bd%b2%e8%bf%87%e7%a8%8b","status":"publish","type":"post","link":"https:\/\/www.gbase8.cn\/en\/13100","title":{"rendered":"cloudberry \u591a\u8282\u70b9\u96c6\u7fa4\u5b89\u88c5\u90e8\u7f72\u8fc7\u7a0b"},"content":{"rendered":"<p>Greenplum \u65b0\u7248\u672c\u843d\u6237apache\uff0c\u6539\u540dcloudberry, \u672c\u6587\u4ecb\u7ecd\u57284\u53f0centos 8.5\uff0c\u90e8\u7f72Cloudberry 1.6.0 build 1 \u7248\u672c\u7684\u8fc7\u7a0b\u3002<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Directory Navigation<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a2c45561c111\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewbox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewbox=\"0 0 24 24\" version=\"1.2\" baseprofile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a2c45561c111\"  aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E7%8E%AF%E5%A2%83\" >\u73af\u5883<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%87%86%E5%A4%87\" >\u51c6\u5907<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E4%B8%BB%E6%9C%BA%E5%90%8D%E8%A7%A3%E6%9E%90hosts\" >\u4e3b\u673a\u540d\u89e3\u6790hosts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#etcsecuritylimitsconf\" >\/etc\/security\/limits.conf<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%88%9B%E5%BB%BA%E7%94%A8%E6%88%B7\" >\u521b\u5efa\u7528\u6237<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AEsegment%E7%9B%AE%E5%BD%95%E5%B9%B6%E6%8E%88%E6%9D%83\" >\u521b\u5efa\u6570\u636esegment\u76ee\u5f55\u5e76\u6388\u6743<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%88%9B%E5%BB%BAgpadmin%E7%94%A8%E6%88%B7%E4%BA%92%E4%BF%A1\" >\u521b\u5efagpadmin\u7528\u6237\u4e92\u4fe1<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%AE%89%E8%A3%85RPM\" >\u5b89\u88c5RPM<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E9%85%8D%E7%BD%AEcoordinator%E5%92%8Csegment\" >\u914d\u7f6ecoordinator\u548csegment<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E6%89%80%E6%9C%89%E8%8A%82%E7%82%B9_all_hosts%E5%88%97%E8%A1%A8\" >\u6240\u6709\u8282\u70b9 all_hosts\u5217\u8868<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E6%89%80%E6%9C%89segment%E8%8A%82%E7%82%B9%E5%88%97%E8%A1%A8\" >\u6240\u6709segment\u8282\u70b9\u5217\u8868<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%88%9B%E5%BB%BAsegment%E7%9A%84primary%E5%92%8Cmirror\" >\u521b\u5efasegment\u7684primary\u548cmirror<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E9%85%8D%E7%BD%AEcoordinatorstandby%E7%9A%84%E6%95%B0%E6%8D%AE%E7%9B%AE%E5%BD%95\" >\u914d\u7f6ecoordinator+standby\u7684\u6570\u636e\u76ee\u5f55<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E9%85%8D%E7%BD%AE%E7%8E%AF%E5%A2%83%E5%8F%98%E9%87%8Fcoordinatorstandby\" >\u914d\u7f6e\u73af\u5883\u53d8\u91cfcoordinator+standby<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%88%9D%E5%A7%8B%E5%8C%96\" >\u521d\u59cb\u5316<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%88%9D%E5%A7%8B%E5%8C%96%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6\" >\u521d\u59cb\u5316\u914d\u7f6e\u6587\u4ef6<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E5%88%9D%E5%A7%8B%E5%8C%96-2\" >\u521d\u59cb\u5316<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E6%9F%A5%E7%9C%8B%E9%9B%86%E7%BE%A4%E7%8A%B6%E6%80%81_gpstate\" >\u67e5\u770b\u96c6\u7fa4\u72b6\u6001 gpstate<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.gbase8.cn\/en\/13100\/#%E7%99%BB%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93\" >\u767b\u5f55\u6570\u636e\u5e93<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%8E%AF%E5%A2%83\"><\/span>\u73af\u5883<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u91c7\u75284\u53f0\u865a\u62df\u673a\uff0c\u56e0\u81ea\u5df1\u673a\u5668\u5185\u5b58\u5c11\uff0c\u6240\u4ee5\u53ea\u5206\u914d\u4e862G\u5185\u5b58\uff0c2C\u7684CPU\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>10.0.2.181  vm181\n10.0.2.182  vm182\n10.0.2.183  vm183\n10.0.2.184  vm184<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>OS \u7248\u672c\uff1aCentOS 8.5.2111 X86 64<\/li><li>CPU: 2\u6838<\/li><li>\u5185\u5b58\uff1a2GB<\/li><li>cloudberry\u7248\u672c 1.6.0 build1(\u5185\u7f6ePostgreSQL\u7248\u672c 14.4)<\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%87%86%E5%A4%87\"><\/span>\u51c6\u5907<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E4%B8%BB%E6%9C%BA%E5%90%8D%E8%A7%A3%E6%9E%90hosts\"><\/span>\u4e3b\u673a\u540d\u89e3\u6790hosts<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6bcf\u53f0\u673a\u5668\u90fd\u914d\u7f6e\u4e0a\uff0c\u540e\u9762\u7528\u4e3b\u673a\u540d\u90e8\u7f72\u670d\u52a1\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;root@vm184 ~]# cat \/etc\/hosts\n127.0.0.1   localhost localhost.localdomain localhost4 localhost4.localdomain4\n::1         localhost localhost.localdomain localhost6 localhost6.localdomain6\n10.0.2.181  vm181\n10.0.2.182  vm182\n10.0.2.183  vm183\n10.0.2.184  vm184<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"etcsecuritylimitsconf\"><\/span>\/etc\/security\/limits.conf<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6bcf\u53f0\u673a\u5668\u589e\u52a0\u5982\u4e0b\u914d\u7f6e<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>* soft nofile 524288\n* hard nofile 524288\n* soft nproc 131072\n* hard nproc 131072<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA%E7%94%A8%E6%88%B7\"><\/span>\u521b\u5efa\u7528\u6237<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6bcf\u53f0\u673a\u5668\u4e0a\u521b\u5efagpadmin\u7528\u6237<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;root@vm180 ~]# useradd gpadmin\n&#91;root@vm180 ~]# passwd gpadmin<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BA%E6%95%B0%E6%8D%AEsegment%E7%9B%AE%E5%BD%95%E5%B9%B6%E6%8E%88%E6%9D%83\"><\/span>\u521b\u5efa\u6570\u636esegment\u76ee\u5f55\u5e76\u6388\u6743<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u6bcf\u53f0\u673a\u5668\u90fd\u64cd\u4f5c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;root@vm181 ~]# mkdir -p \/data0\n&#91;root@vm181 ~]# chown -R gpadmin:gpadmin \/data0<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BAgpadmin%E7%94%A8%E6%88%B7%E4%BA%92%E4%BF%A1\"><\/span>\u521b\u5efagpadmin\u7528\u6237\u4e92\u4fe1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5728\u4e00\u53f0\u673a\u5668\u4e0a\u64cd\u4f5c\u5373\u53ef\uff0c\u672c\u4f8b\u4e3a\u7b2c\u4e00\u53f0vm181\u4e0a\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;root@vm181 ~]# su - gpadmin\n&#91;gpadmin@vm181 ~]$ ssh-keygen -t rsa\nGenerating public\/private rsa key pair.\nEnter file in which to save the key (\/home\/gpadmin\/.ssh\/id_rsa):\nCreated directory '\/home\/gpadmin\/.ssh'.\nEnter passphrase (empty for no passphrase):\nEnter same passphrase again:\nYour identification has been saved in \/home\/gpadmin\/.ssh\/id_rsa.\nYour public key has been saved in \/home\/gpadmin\/.ssh\/id_rsa.pub.\nThe key fingerprint is:\nSHA256:JT1DExhwyLcvbRzFWAOY96bZvinq8Csylb7GdSIHOM0 gpadmin@vm181\nThe key's randomart image is:\n+---&#91;RSA 3072]----+\n|     ..oo==*o    |\n|      o.=oo.o.   |\n|     + ..o=o     |\n|    o E .o.oo    |\n|     . oS+ *     |\n|      + = O .    |\n|     +.+ = .     |\n|    o =o  . ..   |\n|     +.+=o .o.   |\n+----&#91;SHA256]-----+\n&#91;gpadmin@vm181 ~]$ ssh-copy-id gpadmin@10.0.2.181\n\/usr\/bin\/ssh-copy-id: INFO: Source of key(s) to be installed: \"\/home\/gpadmin\/.ssh\/id_rsa.pub\"\nThe authenticity of host '10.0.2.181 (10.0.2.181)' can't be established.\nECDSA key fingerprint is SHA256:JR5GC+5F4EX7GB4k+9T8royjkdrrUdqCvChLwh\/NZUw.\nAre you sure you want to continue connecting (yes\/no\/&#91;fingerprint])? yes\n\/usr\/bin\/ssh-copy-id: INFO: attempting to log in with the new key(s), to filter out any that are already installed\n\/usr\/bin\/ssh-copy-id: INFO: 1 key(s) remain to be installed -- if you are prompted now it is to install the new keys\ngpadmin@10.0.2.181's password:\n\nNumber of key(s) added: 1\n\nNow try logging into the machine, with:   \"ssh 'gpadmin@10.0.2.181'\"\nand check to make sure that only the key(s) you wanted were added.\n\n&#91;gpadmin@vm181 ~]$ ssh-copy-id gpadmin@10.0.2.182\n&#91;gpadmin@vm181 ~]$ ssh-copy-id gpadmin@10.0.2.183\n&#91;gpadmin@vm181 ~]$ ssh-copy-id gpadmin@10.0.2.184\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%AE%89%E8%A3%85RPM\"><\/span>\u5b89\u88c5RPM<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u6bcf\u53f0\u673a\u5668\uff0c\u7528root\u7528\u6237\u8fd0\u884c\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;root@vm181 ~]# cd \/home\/gpadmin\/\n&#91;root@vm181 gpadmin]# yum install .\/cloudberry-db-1.6.0-1.el8.x86_64.rpm<\/code><\/pre>\n\n\n\n<p>\u671f\u95f4\u4f1a\u6709\u5927\u91cf\u4f9d\u8d56\u5e93\u8981\u4e0b\u8f7d\u548c\u66f4\u65b0\u3002\u5982\u679crepo\u8fde\u4e0d\u4e0a\uff0c\u53ef\u4ee5\u6539\u6210aliyun\u7684\uff0c\u5e76\u628a\u4ee5\u524d\u7684\u90fd\u5220\u4e86\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>wget -O \/etc\/yum.repos.d\/CentOS-Base.repo https:\/\/mirrors.aliyun.com\/repo\/Centos-vault-8.5.2111.repo\nrm -f \/etc\/yum.repos.d\/CentOS-Linux-*\nyum clean all\nyum makecache<\/code><\/pre>\n\n\n\n<p>\u66f4\u65b0\u5b89\u88c5\u76ee\u5f55\u7684\u5c5e\u4e3b<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>chown -R gpadmin:gpadmin \/usr\/local\/cloudberry*<\/code><\/pre>\n\n\n\n<p>\u5b9e\u9645\u5f71\u54cd\u7684\u662f\u5982\u4e0b2\u4e2a\u6587\u4ef6\u548c\u5b50\u76ee\u5f55<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ ll \/usr\/local\/cloudberry* -d\nlrwxrwxrwx 1 gpadmin gpadmin  30 Sep  3  2024 \/usr\/local\/cloudberry-db -&gt; \/usr\/local\/cloudberry-db-1.6.0\ndrwxr-xr-x 9 gpadmin gpadmin 135 Apr  8 10:03 \/usr\/local\/cloudberry-db-1.6.0\n&#91;gpadmin@vm181 ~]$<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%85%8D%E7%BD%AEcoordinator%E5%92%8Csegment\"><\/span>\u914d\u7f6ecoordinator\u548csegment<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5728\u67d0\u53f0\u673a\u5668\uff0c\u672c\u6587\u4e3avm181\uff0c\u6267\u884c\u672c\u8282\u64cd\u4f5c\u3002<\/p>\n\n\n\n<p>\u672c\u4f8b\u4e2d\uff0c4\u4e2a\u8282\u70b9\u5168\u90e8\u7528\u4e8esegment\uff0c\u524d2\u4e2a\u7528\u4e8ecoordinator\u548cstandby<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%89%80%E6%9C%89%E8%8A%82%E7%82%B9_all_hosts%E5%88%97%E8%A1%A8\"><\/span>\u6240\u6709\u8282\u70b9 all_hosts\u5217\u8868<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ cat all_hosts\nvm181\nvm182\nvm183\nvm184<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%89%80%E6%9C%89segment%E8%8A%82%E7%82%B9%E5%88%97%E8%A1%A8\"><\/span>\u6240\u6709segment\u8282\u70b9\u5217\u8868<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ cat seg_hosts\nvm181\nvm182\nvm183\nvm184<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9B%E5%BB%BAsegment%E7%9A%84primary%E5%92%8Cmirror\"><\/span>\u521b\u5efasegment\u7684primary\u548cmirror<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>source\u4e00\u4e0b\u8def\u5f84\uff0c\u540e\u9762\u4f1a\u5c06\u5176\u52a0\u5165\u5230\u73af\u5883\u53d8\u91cf\u91cc\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>\n&#91;gpadmin@vm180 ~]$ source \/usr\/local\/cloudberry-db\/greenplum_path.sh\n\n&#91;gpadmin@vm181 ~]$ gpssh -f seg_hosts\n=&gt; mkdir -p \/data0\/primary\/\n&#91;vm181]\n&#91;vm184]\n&#91;vm182]\n&#91;vm183]\n=&gt; mkdir -p \/data0\/mirror\/\n&#91;vm181]\n&#91;vm184]\n&#91;vm182]\n&#91;vm183]\n\n=&gt; exit<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%85%8D%E7%BD%AEcoordinatorstandby%E7%9A%84%E6%95%B0%E6%8D%AE%E7%9B%AE%E5%BD%95\"><\/span>\u914d\u7f6ecoordinator+standby\u7684\u6570\u636e\u76ee\u5f55<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>standby\u7528gpssh\u5efa\u7684\u76ee\u5f55\uff0c\u4e5f\u53ef\u4ee5\u76f4\u63a5\u8fdevm182\u8fc7\u53bb\u5efa\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ mkdir -p \/data0\/coordinator\/\n\n&#91;gpadmin@vm181 ~]$ gpssh -h vm182 -e 'mkdir -p \/data0\/coordinator\/'<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E9%85%8D%E7%BD%AE%E7%8E%AF%E5%A2%83%E5%8F%98%E9%87%8Fcoordinatorstandby\"><\/span>\u914d\u7f6e\u73af\u5883\u53d8\u91cfcoordinator+standby<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u53ea\u5728coordinator\u548cstandby\u8fd92\u4e2a\u8282\u70b9\u7684~\/.bashrc\u7684\u672b\u5c3e\u589e\u52a0\u5982\u4e0b\u5185\u5bb9<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>source \/usr\/local\/cloudberry-db\/greenplum_path.sh\nexport COORDINATOR_DATA_DIRECTORY=\/data0\/coordinator\/gpseg-1<\/code><\/pre>\n\n\n\n<p>source\u751f\u6548<\/p>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ source ~\/.bashrc<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9D%E5%A7%8B%E5%8C%96\"><\/span>\u521d\u59cb\u5316<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>\u5728coordinator \u8282\u70b9vm181\u4e0a\u6267\u884c\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9D%E5%A7%8B%E5%8C%96%E9%85%8D%E7%BD%AE%E6%96%87%E4%BB%B6\"><\/span>\u521d\u59cb\u5316\u914d\u7f6e\u6587\u4ef6<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>\u5982\u4e0b\u5e26\u989c\u8272\u90e8\u5206\u662f\u6539\u52a8\u7684\u5185\u5bb9<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>DATA_DIRECTORY  Segment \u8ba1\u7b97\u8282\u70b9\u7684\u6570\u636e\u76ee\u5f55\u3002\u6bcf\u4e2a\u76ee\u5f55\u4f1a\u521b\u5efa1\u4e2asegment\u3002\u76ee\u5f55\u53ef\u4ee5\u76f8\u540c(\u653e\u4e00\u5757)\uff0c\u4e5f\u53ef\u4ee5\u4e0d\u540c\u3002<\/li><li>COORDINATOR_HOSTNAME \u4e3b\u8282\u70b9\u7684\u4e3b\u673a\u540d\u5b57<\/li><li>COORDINATOR_DIRECTORY \u4e3b\u8282\u70b9\u6570\u636e\u5b58\u50a8\u76ee\u5f55<\/li><li>MIRROR_PORT_BASE \u5907\u8282\u70b9\u7aef\u53e3<\/li><li>MIRROR_DATA_DIRECTORY \u5907\u8282\u70b9\u6570\u636e\u76ee\u5f55<\/li><li>DATABASE_NAME  \u521d\u59cb\u5316\u5b8c\u6210\u540e\uff0c\u521b\u5efa\u8fd9\u4e2a\u6570\u636e\u5e93<\/li><\/ul>\n\n\n\n<p>\u5176\u5b83\u53c2\u6570\u7528\u9ed8\u8ba4\u5373\u53ef\uff0c\u4ecb\u7ecd\u5982\u4e0b<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>SEG_PREFIX \u00a0\u8fd9\u6307\u5b9a\u4e86\u4e00\u4e2a\u524d\u7f00\uff0c\u7528\u4e8e\u547d\u540dMaster\u548cSegment\u5b9e\u4f8b\u4e0a\u7684\u6570\u636e\u76ee\u5f55\u3002Greenplum\u6570\u636e\u5e93\u7cfb\u7edf\u4e2d\u6570\u636e\u76ee\u5f55\u7684\u547d\u540d\u7ea6\u5b9a\u662f<var>SEG_PREFIXnumber<\/var>\uff0c\u5176\u4e2d<var>number<\/var>\u5bf9Segment\u5b9e\u4f8b\u4ece0\u5f00\u59cb\uff08Master\u59cb\u7ec8\u4e3a-1\uff09\u3002\u56e0\u6b64\uff0c\u5982\u679c\u7528\u6237\u9009\u62e9\u524d\u7f00<samp>gpseg<\/samp>\uff0c\u5219\u7528\u6237\u7684Master\u5b9e\u4f8b\u6570\u636e\u76ee\u5f55\u5c06\u4f1a\u88ab\u547d\u540d\u4e3a<samp>gpseg-1<\/samp>\uff0c\u5e76\u4e14Segment\u5b9e\u4f8b\u5c06\u88ab\u547d\u540d\u4e3a<samp>gpseg0<\/samp>\u3001<samp>gpseg1<\/samp>\u3001<samp>gpseg2<\/samp>\u3001<samp>gpseg3<\/samp>\u7b49\u7b49\u3002<\/li><li>PORT_BASE \u00a0\u8fd9\u6307\u5b9a\u8ba1\u7b97\u4e3bSegment\u7aef\u53e3\u7528\u5230\u7684\u57fa\u7840\u6570\u5b57\u3002\u4e3b\u673a\u4e0a\u7684\u7b2c\u4e00\u4e2a\u4e3bSegment\u7aef\u53e3\u88ab\u8bbe\u7f6e\u4e3a<samp>PORT_BASE<\/samp>\uff0c\u7136\u540e\u5bf9\u8be5\u4e3b\u673a\u4e0a\u7684\u6bcf\u4e2a\u989d\u5916\u4e3bSegment\u90fd\u52a0\u4e00\u3002<\/li><li>COORDINATOR_PORT Master\u5b9e\u4f8b\u7684\u7aef\u53e3\u53f7\u3002\u8fd9\u662f\u8bbf\u95eecloundberry\u6570\u636e\u5e93\u7cfb\u7edf\u65f6\u7528\u6237\u548c\u5ba2\u6237\u7aef\u8fde\u63a5\u5c06\u4f7f\u7528\u7684\u7aef\u53e3\u53f7\u3002\u5bf9\u5e94Greenplum\u91cc\u9762\u7684MASTER_PORT<\/li><li>TRUSTED_SHELL \u00a0<samp>gpinitsystem<\/samp>\u00a0\u5de5\u5177\u7528\u6765\u5728\u8fdc\u7a0b\u4e3b\u673a\u4e0a\u6267\u884c\u547d\u4ee4\u7684shell\u3002\u5141\u8bb8\u7684\u503c\u4e3a<samp>ssh<\/samp>\u3002\u7528\u6237\u5fc5\u987b\u5728\u8fd0\u884c<samp>gpinitsystem<\/samp>\u00a0\u5de5\u5177\u4e4b\u524d\u8bbe\u7f6e\u7528\u6237\u7684\u53ef\u4fe1\u4e3b\u673a\u73af\u5883\u3002<\/li><li>ENCODING \u00a0\u8981\u4f7f\u7528\u7684\u5b57\u7b26\u96c6\u7f16\u7801\u3002\u548cPostgreSQL\u76f8\u540c\u3002<\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ cp $GPHOME\/docs\/cli_help\/gpconfigs\/gpinitsystem_config .\n\n&#91;gpadmin@vm181 ~]$ vi gpinitsystem_config\n&#91;gpadmin@vm181 ~]$ grep -v ^# gpinitsystem_config |grep -v '^$'\nSEG_PREFIX=gpseg\nPORT_BASE=6000\n<span class=\"has-inline-color has-luminous-vivid-orange-color\">declare -a DATA_DIRECTORY=(\/data0\/primary)<\/span>\n<span class=\"has-inline-color has-luminous-vivid-orange-color\">COORDINATOR_HOSTNAME=vm181<\/span>\n<span class=\"has-inline-color has-luminous-vivid-orange-color\">COORDINATOR_DIRECTORY=\/data0\/coordinator<\/span>\nCOORDINATOR_PORT=5432\nTRUSTED_SHELL=ssh\nENCODING=UNICODE\n<span class=\"has-inline-color has-luminous-vivid-orange-color\">MIRROR_PORT_BASE=7000\ndeclare -a MIRROR_DATA_DIRECTORY=(\/data0\/mirror)\nDATABASE_NAME=warehouse<\/span>\n&#91;gpadmin@vm181 ~]$<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E5%88%9D%E5%A7%8B%E5%8C%96-2\"><\/span>\u521d\u59cb\u5316<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ gpinitsystem -c  gpinitsystem_config -h \/home\/gpadmin\/seg_hosts\n20250408:10:45:46:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Checking configuration parameters, please wait...\n20250408:10:45:46:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Reading CloudberryDB configuration file gpinitsystem_config\n20250408:10:45:46:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Locale has not been set in gpinitsystem_config, will set to default value\n20250408:10:45:46:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-COORDINATOR_MAX_CONNECT not set, will set to default value 250\n20250408:10:45:46:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Checking configuration parameters, Completed\n20250408:10:45:46:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Commencing multi-home checks, please wait...\n....\n20250408:10:45:48:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Configuring build for standard array\n20250408:10:45:49:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Commencing multi-home checks, Completed\n20250408:10:45:49:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Building primary segment instance array, please wait...\n....\n20250408:10:45:51:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Building group mirror array type , please wait...\n....\n20250408:10:45:54:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Checking Coordinator host\n20250408:10:45:54:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Checking new segment hosts, please wait...\n........\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Checking new segment hosts, Completed\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Cloudberry Database Creation Parameters\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:---------------------------------------\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator Configuration\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:---------------------------------------\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator hostname       = vm181\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator port           = 5432\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator instance dir   = \/data0\/coordinator\/gpseg-1\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator LOCALE         =\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-CloudberryDB segment prefix   = gpseg\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator Database       = warehouse\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator connections    = 250\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator buffers        = 128000kB\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Segment connections        = 750\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Segment buffers            = 128000kB\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Encoding                   = UNICODE\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Postgres param file        = Off\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Initdb to be used          = \/usr\/local\/cloudberry-db-1.6.0\/bin\/initdb\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-GP_LIBRARY_PATH is         = \/usr\/local\/cloudberry-db-1.6.0\/lib\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-HEAP_CHECKSUM is           = on\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-HBA_HOSTNAMES is           = 0\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Ulimit check               = Passed\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Array host connect type    = Single hostname per node\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator IP address &#91;1]      = ::1\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator IP address &#91;2]      = 10.0.2.181\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator IP address &#91;3]      = 192.168.122.1\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Coordinator IP address &#91;4]      = fe80::edea:b0b9:f4e4:fee\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Standby Coordinator             = Not Configured\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Number of primary segments = 1\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Total Database segments    = 4\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Trusted shell              = ssh\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Number segment hosts       = 4\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Mirror port base           = 7000\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Number of mirror segments  = 1\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Mirroring config           = ON\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Mirroring type             = Group\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:----------------------------------------\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-CloudberryDB Primary Segment Configuration\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:----------------------------------------\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-vm181       6000    vm181   \/data0\/primary\/gpseg0   2\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-vm182       6000    vm182   \/data0\/primary\/gpseg1   3\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-vm183       6000    vm183   \/data0\/primary\/gpseg2   4\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-vm184       6000    vm184   \/data0\/primary\/gpseg3   5\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:---------------------------------------\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-CloudberryDB Mirror Segment Configuration\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:---------------------------------------\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-vm182       7000    vm182   \/data0\/mirror\/gpseg0    6\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-vm183       7000    vm183   \/data0\/mirror\/gpseg1    7\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-vm184       7000    vm184   \/data0\/mirror\/gpseg2    8\n20250408:10:46:06:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-vm181       7000    vm181   \/data0\/mirror\/gpseg3    9\n\nContinue with CloudberryDB creation Yy|Nn (default=N):\n&gt; y\n20250408:10:46:15:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Building the Coordinator instance database, please wait...\n20250408:10:46:19:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Starting the Coordinator in admin mode\n20250408:10:46:20:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Commencing parallel build of primary segment instances\n20250408:10:46:20:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Spawning parallel processes    batch &#91;1], please wait...\n....\n20250408:10:46:20:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Waiting for parallel processes batch &#91;1], please wait...\n..............................................\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:------------------------------------------------\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Parallel process exit status\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:------------------------------------------------\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Total processes marked as completed           = 4\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Total processes marked as killed              = 0\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Total processes marked as failed              = 0\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:------------------------------------------------\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Removing back out file\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-No errors generated from parallel processes\n20250408:10:47:07:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Restarting the CloudberryDB instance in production mode\n20250408:10:47:07:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Starting gpstop with args: -a -l \/home\/gpadmin\/gpAdminLogs -m -d \/data0\/coordinator\/gpseg-1\n20250408:10:47:07:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Gathering information and validating the environment...\n20250408:10:47:07:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Obtaining CloudberryDB Coordinator catalog information\n20250408:10:47:07:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Obtaining Segment details from coordinator...\n20250408:10:47:07:059778 gpstop:vm181:gpadmin-&#91;INFO]:-CloudberryDB Version: 'postgres (Cloudberry Database) 1.6.0 build 1'\n20250408:10:47:07:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Commencing Coordinator instance shutdown with mode='smart'\n20250408:10:47:07:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Coordinator segment instance directory=\/data0\/coordinator\/gpseg-1\n20250408:10:47:07:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Stopping coordinator segment and waiting for user connections to finish ...\nserver shutting down\n20250408:10:47:08:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Attempting forceful termination of any leftover coordinator process\n20250408:10:47:08:059778 gpstop:vm181:gpadmin-&#91;INFO]:-Terminating processes for segment \/data0\/coordinator\/gpseg-1\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Starting gpstart with args: -a -l \/home\/gpadmin\/gpAdminLogs -d \/data0\/coordinator\/gpseg-1\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Gathering information and validating the environment...\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-CloudberryDB Binary Version: 'postgres (Cloudberry Database) 1.6.0 build 1'\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-CloudberryDB Catalog Version: '302407192'\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Starting Coordinator instance in admin mode\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-CoordinatorStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=None $GPHOME\/bin\/pg_ctl -D \/data0\/coordinator\/gpseg-1 -l \/data0\/coordinator\/gpseg-1\/log\/startup.log -w -t 600 -o \" -p 5432 -c gp_role=utility \" start\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Obtaining CloudberryDB Coordinator catalog information\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Obtaining Segment details from coordinator...\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Setting new coordinator era\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Coordinator Started...\n20250408:10:47:09:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Shutting down coordinator\n20250408:10:47:10:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Commencing parallel segment instance startup, please wait...\n.\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Process results...\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-   Successful segment starts                                            = 4\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-   Failed segment starts                                                = 0\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-   Skipped segment starts (segments are marked down in configuration)   = 0\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Successfully started 4 of 4 segment instances\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Starting Coordinator instance vm181 directory \/data0\/coordinator\/gpseg-1\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-CoordinatorStart pg_ctl cmd is env GPSESSID=0000000000 GPERA=76a3c4e31c2dd425_250408104709 $GPHOME\/bin\/pg_ctl -D \/data0\/coordinator\/gpseg-1 -l \/data0\/coordinator\/gpseg-1\/log\/startup.log -w -t 600 -o \" -p 5432 -c gp_role=dispatch \" start\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Command pg_ctl reports Coordinator vm181 instance active\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Connecting to db template1 on host localhost\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-No standby coordinator configured.  skipping...\n20250408:10:47:11:059805 gpstart:vm181:gpadmin-&#91;INFO]:-Database successfully started\n20250408:10:47:11:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Completed restart of CloudberryDB instance in production mode\n20250408:10:47:11:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Creating core GPDB extensions\n20250408:10:47:20:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Commencing parallel build of mirror segment instances\n20250408:10:47:20:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Spawning parallel processes    batch &#91;1], please wait...\n....\n20250408:10:47:20:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Waiting for parallel processes batch &#91;1], please wait...\n...........................................................\n20250408:10:48:21:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:------------------------------------------------\n20250408:10:48:21:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Parallel process exit status\n20250408:10:48:21:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:------------------------------------------------\n20250408:10:48:21:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Total processes marked as completed           = 4\n20250408:10:48:21:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Total processes marked as killed              = 0\n20250408:10:48:21:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Total processes marked as failed              = 0\n20250408:10:48:21:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:------------------------------------------------\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;WARN]:\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;WARN]:-Failed to start CloudberryDB instance; please review gpinitsystem log to determine failure.\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Scanning utility log file for any warning messages\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;WARN]:-*******************************************************\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;WARN]:-Scan of log file indicates that some warnings or errors\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;WARN]:-were generated during the array creation\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Please review contents of log file\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-\/home\/gpadmin\/gpAdminLogs\/gpinitsystem_20250408.log\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-To determine level of criticality\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-These messages could be from a previous run of the utility\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-that was called today!\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;WARN]:-*******************************************************\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Cloudberry Database instance successfully created\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-------------------------------------------------------\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-To complete the environment configuration, please\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-update gpadmin .bashrc file with the following\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-1. Ensure that the greenplum_path.sh file is sourced\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-2. Add \"export COORDINATOR_DATA_DIRECTORY=\/data0\/coordinator\/gpseg-1\"\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-   to access the CloudberryDB scripts for this instance:\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-   or, use -d \/data0\/coordinator\/gpseg-1 option for the CloudberryDB scripts\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-   Example gpstate -d \/data0\/coordinator\/gpseg-1\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Script log file = \/home\/gpadmin\/gpAdminLogs\/gpinitsystem_20250408.log\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-To remove instance, run gpdeletesystem utility\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-To initialize a Standby Coordinator Segment for this CloudberryDB instance\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-Review options for gpinitstandby\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-------------------------------------------------------\n20250408:10:48:23:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-The Coordinator \/data0\/coordinator\/gpseg-1\/pg_hba.conf post gpinitsystem\n20250408:10:48:24:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-has been configured to allow all hosts within this new\n20250408:10:48:24:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-array to intercommunicate. Any hosts external to this\n20250408:10:48:24:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-new array must be explicitly added to this file\n20250408:10:48:24:053136 gpinitsystem:vm181:gpadmin-&#91;INFO]:-------------------------------------------------------\n&#91;gpadmin@vm181 ~]$\n<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E6%9F%A5%E7%9C%8B%E9%9B%86%E7%BE%A4%E7%8A%B6%E6%80%81_gpstate\"><\/span>\u67e5\u770b\u96c6\u7fa4\u72b6\u6001 gpstate<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ gpstate\n20250408:10:51:17:061988 gpstate:vm181:gpadmin-&#91;INFO]:-Starting gpstate with args:\n20250408:10:51:17:061988 gpstate:vm181:gpadmin-&#91;INFO]:-local CloudberryDB Version: 'postgres (Cloudberry Database) 1.6.0 build 1'\n20250408:10:51:17:061988 gpstate:vm181:gpadmin-&#91;INFO]:-coordinator CloudberryDB Version: 'PostgreSQL 14.4 (Cloudberry Database 1.6.0 build 1) on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-22), 64-bit compiled on Sep  3 2024 07:22:14'\n20250408:10:51:17:061988 gpstate:vm181:gpadmin-&#91;INFO]:-Obtaining Segment details from coordinator...\n20250408:10:51:17:061988 gpstate:vm181:gpadmin-&#91;INFO]:-Gathering data from segments...\n.\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-CloudberryDB instance status summary\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Coordinator instance                                      = Active\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Coordinator standby                                       = No coordinator standby configured\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total segment instance count from metadata                = 8\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Primary Segment Status\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total primary segments                                    = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total primary segment valid (at coordinator)              = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total primary segment failures (at coordinator)           = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of postmaster.pid files missing              = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of postmaster.pid files found                = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of postmaster.pid PIDs missing               = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of postmaster.pid PIDs found                 = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of \/tmp lock files missing                   = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of \/tmp lock files found                     = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number postmaster processes missing                 = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number postmaster processes found                   = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Mirror Segment Status\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total mirror segments                                     = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total mirror segment valid (at coordinator)               = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total mirror segment failures (at coordinator)            = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of postmaster.pid files missing              = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of postmaster.pid files found                = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of postmaster.pid PIDs missing               = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of postmaster.pid PIDs found                 = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of \/tmp lock files missing                   = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number of \/tmp lock files found                     = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number postmaster processes missing                 = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number postmaster processes found                   = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number mirror segments acting as primary segments   = 0\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-   Total number mirror segments acting as mirror segments    = 4\n20250408:10:51:19:061988 gpstate:vm181:gpadmin-&#91;INFO]:-----------------------------------------------------\n&#91;gpadmin@vm181 ~]$<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"%E7%99%BB%E5%BD%95%E6%95%B0%E6%8D%AE%E5%BA%93\"><\/span>\u767b\u5f55\u6570\u636e\u5e93<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<pre class=\"wp-block-code has-small-font-size\"><code>&#91;gpadmin@vm181 ~]$ psql warehouse\npsql (14.4, server 14.4)\nType \"help\" for help.\n\nwarehouse=# SELECT * FROM gp_segment_configuration;\n dbid | content | role | preferred_role | mode | status | port | hostname | address |          datadir           | warehouseid\n------+---------+------+----------------+------+--------+------+----------+---------+----------------------------+-------------\n    1 |      -1 | p    | p              | n    | u      | 5432 | vm181    | vm181   | \/data0\/coordinator\/gpseg-1 |           0\n    3 |       1 | p    | p              | s    | u      | 6000 | vm182    | vm182   | \/data0\/primary\/gpseg1      |           0\n    7 |       1 | m    | m              | s    | u      | 7000 | vm183    | vm183   | \/data0\/mirror\/gpseg1       |           0\n    4 |       2 | p    | p              | s    | u      | 6000 | vm183    | vm183   | \/data0\/primary\/gpseg2      |           0\n    8 |       2 | m    | m              | s    | u      | 7000 | vm184    | vm184   | \/data0\/mirror\/gpseg2       |           0\n   10 |      -1 | m    | m              | s    | u      | 5432 | vm182    | vm182   | \/data0\/coordinator\/gpseg-1 |           0\n    9 |       3 | p    | m              | s    | u      | 7000 | vm181    | vm181   | \/data0\/mirror\/gpseg3       |           0\n    5 |       3 | m    | p              | s    | u      | 6000 | vm184    | vm184   | \/data0\/primary\/gpseg3      |           0\n    6 |       0 | p    | m              | s    | u      | 7000 | vm182    | vm182   | \/data0\/mirror\/gpseg0       |           0\n    2 |       0 | m    | p              | s    | u      | 6000 | vm181    | vm181   | \/data0\/primary\/gpseg0      |           0\n(10 rows)\n\nwarehouse=#<\/code><\/pre>","protected":false},"excerpt":{"rendered":"<p>Greenplum \u65b0\u7248\u672c\u843d\u6237apache\uff0c\u6539\u540dcloudberry, \u672c\u6587\u4ecb\u7ecd\u57284\u53f0centos 8.5\uff0c\u90e8\u7f72Cloudberry 1.6.0 build 1 \u7248\u672c\u7684\u8fc7\u7a0b\u3002<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[79],"tags":[126],"class_list":["post-13100","post","type-post","status-publish","format-standard","hentry","category-79","tag-cloudberry"],"_links":{"self":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/13100","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/comments?post=13100"}],"version-history":[{"count":45,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/13100\/revisions"}],"predecessor-version":[{"id":13150,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/posts\/13100\/revisions\/13150"}],"wp:attachment":[{"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/media?parent=13100"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/categories?post=13100"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gbase8.cn\/en\/wp-json\/wp\/v2\/tags?post=13100"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}