TDSQL for PostgreSQL（原 TBase）集群安装
Tags： TBaseTDSQLTDSQL for PostgreSQL分布式数据库集群部署高可用
👉 本文共约4540个字，系统预计阅读时间或需18分钟。
简介
2020年12月腾讯云数据库品牌升级，腾讯云原有的TDSQL、TBase、CynosDB三大产品线将统一升级为“腾讯云企业级分布式数据库TDSQL”。全新升级后的腾讯云TDSQL将涵盖分布式、分析型、云原生等多引擎融合的完整数据库产品体系。
TDSQL MySQL版为原TDSQL，TDSQL PostgreSQL版为原TBase OLTP版及HTAP版；TDSQL-A PostgreSQL 版为原TBase OLAP版，并新增 ClickHouse 版；TDSQL-C为原CynosDB。
TDSQL MySQL版是基于 MariaDB 内核 ，结合 mysql-proxy、ZooKeeper 等开源组件实现的数据库集群系统，并且基于 MySQL 半同步的机制。
拥有自主研发的企业级分布式数据库TDSQL，100%兼容MySQL和PostgreSQL，Oracle兼容性达95%以上，包含三大产品系列，分别为分析型数据库TDSQL-A （Tencent Analytical Database）、云原生数据库TDSQL-C （Tencent CloudNative Database）和分布式数据库TDSQL （Tencent DistributedDatabase），全方位满足政企业务需求。
TDSQL for MySQL
https://cloud.tencent.com/product/dcdb
TDSQL MySQL 版（TDSQL for MySQL）是腾讯打造的一款分布式数据库产品，具备强一致高可用、全球部署架构、分布式水平扩展、高性能、企业级安全等特性，同时提供智能 DBA、自动化运营、监控告警等配套设施，为客户提供完整的分布式数据库解决方案。目前 TDSQL 已经为超过500+的政企和金融机构提供数据库的公有云及私有云服务，客户覆盖银行、保险、证券、互联网金融、计费、第三方支付、物联网、互联网+、政务等领域。TDSQL MySQL 版亦凭借其高质量的产品及服务，获得了多项国际和国家认证，得到了客户及行业的一致认可。
TDSQL for PostgreSQL， 原 TBase（开源）
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
官网：http://tbase.qq.com 、 https://cloud.tencent.com/product/tbase
GitHub：http://github.com/Tencent/TBase
文档：https://github.com/Tencent/TBase/wiki/
TBase is an enterprise-level distributed HTAP database. Through a single database cluster to provide users with highly consistent distributed database services and high-performance data warehouse services, a set of integrated enterprise-level solutions is formed.
TDSQL PostgreSQL 版（TDSQL for PostgreSQL， 原 TBase）是腾讯自主研发的分布式数据库系统，具备高 SQL 兼容度、完整分布式事务、高安全、高扩展、多级容灾等能力，成功应用在金融、政府、电信等行业核心业务中。同时提供完善的容灾、备份、监控、审计等全套方案，适用于GB～PB级海量 HTAP 场景。
产品特性
TDSQL PostgreSQL 版适用于哪些业务场景？
HTAP 业务系统： 在数据库系统应用中，OLTP 场景涉及数据量小，但对返回实时性要求高；OLAP 类场景涉及的数据量和计算量大，但是对实时性要求不高。一套系统里能同时覆盖 OLTP 以及 OLAP 场景是业务对数据库系统的一个很强烈的诉求，TDSQL PostgreSQL 版 特有的架构设计，刚好满足此诉求，且已经有了不少的 HTAP 业务场景的落地案例。
物联网地理信息系统：在物联网场景中，很多的传感器接入数据（热点 WIFI 数据、车辆行驶数轨迹数据等）都包含一些点位信息（经度和纬度）。TDSQL PostgreSQL 版结合这些位置信息和已有的地理信息进行关联分析，可以得到价值很高的数据。TDSQL PostgreSQL 版支持最先进的开源地理信息引擎 PostGIS，可以提供丰富高效的地理信息处理能力。
实时高并发事务系统： 互联网、移动话联网、电商等业务的蓬勃发展，使客户量不断增长，业务核心系统需经受高并发访问的考验。TDSQL PostgreSQL 版的 share nothing 架构可以在线平滑地扩展实例规模，从容应对此类场景；同时，TDSQL PostgreSQL 版提供的分布式事务一致性能力能保证高并发场景下的分布式系统事务一致性。
TDSQL PostgreSQL 版的 SQL 兼容度如何？
TDSQL PostgreSQL 版兼容绝大多数的 PostgreSQL 语法，包括复杂查询、外键、触发器、视图、存储过程等等，满足大部分企业用户的诉求。同时，TDSQL PostgreSQL 版还兼容大部分的 Oracle 类型、函数，用户可轻松将 Oracle 业务迁移到 TDSQL PostgreSQL 版中。
数据库架构
TDSQL PostgreSQL版 采用无共享 share nothing 架构。数据库实例分为三种节点：
- 协调节点（Coordinator，CN）：是数据库服务的对外入口即业务访问入口，负责数据的分发和查询规划，多个节点位置对等。在功能上CN上只存储系统的全局元数据，并不存储实际的业务数据。
- 数据节点（Datanode，DN） ：负责执行协调节点分发的执行请求，实际存储业务数据。
- 全局事务管理器（GlobalTransactionManager，GTM）：负责全局事务管理，同时管理集群的全局对象，比如序列等。
TDSQL PostgreSQL版 数据节点部署在强大硬件之上，底层存储使用本地 NVMe SSD 硬盘，提供强大的 IO 性能。
常见问题
https://cloud.tencent.com/document/product/1129/37327
Oracle 数据库能迁移至 TDSQL PostgreSQL版 数据库吗？
TDSQL PostgreSQL版 作为去 O 的最佳选择之一，支持复杂子查询、存储过程、窗口函数等很多企业级的特性，并在内核级支持很多 Oracle 语法以及函数，使得业务代码几乎不用进行修改或极少的修改便能够在 TDSQL 上实现业务的快速迁移。
具体的 Oracle 兼容性说明请参见 Oracle 兼容语法。
TDSQL PostgreSQL版 对 PostgreSQL 的兼容度如何？
- 在功能上，TDSQL PostgreSQL版 与 PostgreSQL 一样实现了 SQL 2011 标准所规定的大部分功能，支持 SELECT、UPDATE、INSERT、JOIN、GROUP BY 等基础功能，以及支持外键约束、check、主键、触发器、视图、存储过程、多级事务、多版本并发控制等高级功能。
- 在数据类型上，TDSQL PostgreSQL版 支持常见的数字、字符串，时间类型，以及支持自增序列、货币、几何、UUID、Array、JSON、Range等类型。
- 在接口上，TDSQL PostgreSQL版 支持 JDBC、ODBC、shell、C、Python、PHP、.NET 等大多数语言的 API。
用户完全可以像使用单机 PostgreSQL 一样使用 TDSQL PostgreSQL版，无需额外的学习成本。
TDSQL PostgreSQL版 支持强同步复制吗？
支持。强同步复制是在节点级保证每个节点的主从数据完全一致，是整个容灾体系的基础，在主节点故障发生时，数据库可以切换到从机提供服务并且无任何数据丢失。
TDSQL PostgreSQL版 如何进行高效的分布式 JOIN？
- 在执行方式上，协调节点接收到用户的 SQL 请求，根据收集的集群统计信息，生成最优的集群级分布式查询计划，并下发到参与计算的数据节点上进行执行，即协调节点下发的是执行计划，数据节点负责执行该计划。
- 在数据交互上，数据节点之间建立了高效数据交换通道，可以高效的进行交换数据，数据交换的过程在 TDSQL PostgreSQL版 里称之数据重分布（Data Redistribution）。
基于高效的全局查询计划和数据重分布的技术支撑，TDSQL PostgreSQL版 能充分发挥并行计算的优势，高效完成 JOIN 过程。
TDSQL PostgreSQL版 支持审计吗？
支持。TDSQL PostgreSQL版 从多个维度提供全方位的审计能力，审计采用旁路检测方式，对数据库运行影响极小。
参考
https://cloud.tencent.com/developer/article/1635680
https://cloud.tencent.com/developer/article/1847790
TDSQL for PostgreSQL（原 TBase）集群安装
环境申请
| 节点名称 | IP | port | 数据目录 |
|---|---|---|---|
| GTM主机 | 172.72.6.100 | 5001 | /data/tbase/gtm |
| GTM从机 | 172.72.6.101 | 5001 | /data/tbase/gtm |
| CN1 | 172.72.6.100 | 3004 | /data/tbase/coord |
| CN2 | 172.72.6.101 | 3004 | /data/tbase/coord |
| DN1主 | 172.72.6.100 | 4004 | /data/tbase/dn001 |
| DN1从 | 172.72.6.101 | 5004 | /data/tbase/dn001 |
| DN2主 | 172.72.6.101 | 4004 | /data/tbase/dn002 |
| DN2从 | 172.72.6.100 | 5004 | /data/tbase/dn002 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | -- 网卡 docker network create --subnet=172.72.6.0/24 pg-network docker rm -f lhrtbase100 docker run -d --name lhrtbase100 -h lhrtbase100 \ --net=pg-network --ip 172.72.6.100 \ -p 64003:30004 -p 64004:40004 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/lhrcentos76:8.8 \ /usr/sbin/init docker rm -f lhrtbase101 docker run -d --name lhrtbase101 -h lhrtbase101 \ --net=pg-network --ip 172.72.6.101 \ -p 64005:30004 -p 64006:40004 \ -v /sys/fs/cgroup:/sys/fs/cgroup \ --privileged=true lhrbest/lhrcentos76:8.8 \ /usr/sbin/init |
基本配置
所有节点都需要操作：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | yum install -y git readline-devel uuid zlib zlib-devel openssl-devel bison gcc gcc-g++ make flex flex-devel uuid-devel useradd tbase mkdir -p /opt/tbase mkdir -p /data/tbase chown -R tbase.tbase /opt/tbase chown -R tbase.tbase /data/tbase echo "tbase:lhr" | chpasswd cat >> /home/tbase/.bashrc << 'EOF' export TBASE_HOME=/opt/tbase export PATH="$PATH:$TBASE_HOME/bin" export LD_LIBRARY_PATH="$LD_LIBRARY_PATH:$TBASE_HOME/lib" EOF source /home/tbase/.bashrc |
编译安装TBase
只在节点1操作：
1 2 3 4 5 6 7 8 9 10 11 12 13 | cd /soft git clone https://github.com/Tencent/TBase cd TBase/ chmod +x configure* ./configure --prefix=/opt/tbase --enable-user-switch --with-openssl --with-ossp-uuid CFLAGS=-g make clean make -sj make install chmod +x contrib/pgxc_ctl/make_signature cd contrib make -sj make install |
配置ssh互信
只在节点1操作：
1 2 3 | ./sshUserSetup.sh -user tbase -hosts "lhrtbase100 lhrtbase101" -advanced exverify -confirm sudo chmod 600 /home/tbase/.ssh/config |
集群安装
只在节点1操作：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 | cat > /tmp/pgxc_ctl.conf <<"EOF00" #!/bin/bash m1=172.72.6.100 m2=172.72.6.101 pgxcInstallDir=/opt/tbase pgxcOwner=tbase defaultDatabase=postgres pgxcUser=$pgxcOwner tmpDir=/tmp localTmpDir=$tmpDir configBackup=n configBackupHost=pgxc-linker configBackupDir=$HOME/pgxc configBackupFile=pgxc_ctl.bak #---- GTM ---------- gtmName=gtm gtmMasterServer=$m1 gtmMasterPort=50001 gtmMasterDir=/data/tbase/gtm gtmExtraConfig=none gtmMasterSpecificExtraConfig=none gtmSlave=y # 新增,否则slave配置中为null gtmSlaveName=gtm gtmSlaveServer=$m2 gtmSlavePort=50001 gtmSlaveDir=/data/tbase/gtm gtmSlaveSpecificExtraConfig=none #---- Coordinators ------- coordMasterDir=/data/tbase/coord coordArchLogDir=/data/tbase/coord_archlog coordNames=(cn001 cn002 ) coordPorts=(30004 30004 ) poolerPorts=(31110 31110 ) coordPgHbaEntries=(0.0.0.0/0) coordMasterServers=($m1 $m2) coordMasterDirs=($coordMasterDir $coordMasterDir) coordMaxWALsernder=2 coordMaxWALSenders=($coordMaxWALsernder $coordMaxWALsernder ) coordSlave=n coordSlaveSync=n coordArchLogDirs=($coordArchLogDir $coordArchLogDir) coordExtraConfig=coordExtraConfig cat > $coordExtraConfig <<EOF #================================================ # Added to all the coordinator postgresql.conf # Original: $coordExtraConfig # 此处适应性修改后 dn slave可正常启动 listen_addresses = '0.0.0.0' max_connections = 500 max_pool_size = 65535 shared_buffers = 1GB max_prepared_transactions = 2000 maintenance_work_mem = 256MB wal_level = logical max_wal_senders = 64 max_wal_size = 1GB min_wal_size = 256MB log_destination = 'csvlog' logging_collector = on log_directory = 'log' log_filename = 'postgresql-%A-%H.log' synchronous_commit = local synchronous_standby_names = '' EOF coordSpecificExtraConfig=(none none) coordExtraPgHba=coordExtraPgHba cat > $coordExtraPgHba <<EOF local all all trust host all all 0.0.0.0/0 trust host replication all 0.0.0.0/0 trust host all all ::1/128 trust host replication all ::1/128 trust host replication all $m1/32 trust host all all $m1/32 trust host replication all $m2/32 trust host all all $m2/32 trust host all all 0.0.0.0/0 md5 EOF coordSpecificExtraPgHba=(none none) coordAdditionalSlaves=n cad1_Sync=n #---- Datanodes --------------------- dn1MstrDir=/data/tbase/dn001 dn2MstrDir=/data/tbase/dn002 dn1SlvDir=/data/tbase/dn001 dn2SlvDir=/data/tbase/dn002 dn1ALDir=/data/tbase/datanode_archlog dn2ALDir=/data/tbase/datanode_archlog primaryDatanode=dn001 datanodeNames=(dn001 dn002) datanodePorts=(40004 40004) datanodePoolerPorts=(41110 41110) datanodePgHbaEntries=(0.0.0.0/0) datanodeMasterServers=($m1 $m2) datanodeMasterDirs=($dn1MstrDir $dn2MstrDir) dnWALSndr=4 datanodeMaxWALSenders=($dnWALSndr $dnWALSndr) datanodeSlave=y datanodeSlaveServers=($m2 $m1) datanodeSlavePorts=(50004 50004) datanodeSlavePoolerPorts=(51110 51110) datanodeSlaveSync=n datanodeSlaveDirs=($dn1SlvDir $dn2SlvDir) datanodeArchLogDirs=($dn1ALDir/dn001 $dn2ALDir/dn002) datanodeExtraConfig=datanodeExtraConfig cat > $datanodeExtraConfig <<EOF #================================================ # Added to all the coordinator postgresql.conf # Original: $datanodeExtraConfig # 此处适应性修改后 dn slave可正常启动 listen_addresses = '0.0.0.0' max_connections = 500 max_pool_size = 65535 shared_buffers = 1GB max_prepared_transactions = 2000 maintenance_work_mem = 256MB wal_level = logical max_wal_senders = 64 max_wal_size = 1GB min_wal_size = 256MB log_destination = 'csvlog' logging_collector = on log_directory = 'log' log_filename = 'postgresql-%A-%H.log' synchronous_commit = local synchronous_standby_names = '' EOF datanodeSpecificExtraConfig=(none none) datanodeExtraPgHba=datanodeExtraPgHba cat > $datanodeExtraPgHba <<EOF local all all trust host all all 0.0.0.0/0 trust host replication all 0.0.0.0/0 trust host all all ::1/128 trust host replication all ::1/128 trust host replication all $m1/32 trust host all all $m1/32 trust host replication all $m2/32 trust host all all $m2/32 trust host all all 0.0.0.0/0 md5 EOF datanodeSpecificExtraPgHba=(none none) datanodeAdditionalSlaves=n walArchive=n EOF00 |
初始化数据库
只在节点1操作：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | # 分发二进制包：在一个节点配置好配置文件后，需要预先将二进制包部署到所有节点所在的机器上，这个可以使用pgxc_ctl工具，执行deploy all命令来完成。 pgxc_ctl -c /tmp/pgxc_ctl.conf # 二进制分发 > deploy all # 集群初始化 > init all # 显示配置 > show config all # 启停服务 > stop all -m fast > start all # 监控集群 > monitor all # 清除集群：用于重新部署 > clean all -- d [root@lhrtbase101 tbase]# netstat -tulnp | grep "gtm\|postgres" tcp 0 0 0.0.0.0:50004 0.0.0.0:* LISTEN 25052/postgres tcp 0 0 0.0.0.0:30004 0.0.0.0:* LISTEN 6094/postgres tcp 0 0 0.0.0.0:40004 0.0.0.0:* LISTEN 15412/postgres tcp 0 0 0.0.0.0:50001 0.0.0.0:* LISTEN 5599/gtm tcp6 0 0 :::30004 :::* LISTEN 6094/postgres tcp6 0 0 :::40004 :::* LISTEN 15412/postgres tcp6 0 0 :::50001 :::* LISTEN 5599/gtm |
过程：
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 285 286 287 288 289 290 291 292 293 294 295 296 297 298 299 300 301 302 303 304 305 306 307 308 309 310 311 312 313 314 315 316 317 318 319 320 321 322 323 324 325 326 327 328 329 330 331 332 333 334 335 336 337 338 339 340 341 342 343 344 345 346 347 348 349 350 351 352 353 354 355 356 357 358 359 360 361 362 363 364 365 366 367 368 369 370 371 372 373 374 375 376 377 378 379 380 381 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 399 400 401 402 403 404 405 406 407 408 409 410 411 412 413 414 415 416 417 418 419 420 421 422 423 424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448 449 450 451 452 453 454 455 456 457 458 459 460 461 462 463 464 465 466 467 468 469 470 471 472 473 474 475 476 477 478 479 480 481 482 483 484 485 486 487 488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526 527 528 529 530 531 532 533 534 535 536 537 538 539 540 541 542 543 544 545 546 547 548 549 550 551 552 553 554 555 556 557 558 559 560 561 562 563 564 565 566 567 568 569 570 571 572 573 574 575 576 577 578 579 580 581 582 583 584 585 586 587 588 589 590 591 592 593 594 595 596 597 598 599 600 601 602 603 604 605 606 607 608 609 610 611 612 613 614 615 616 617 618 619 620 621 622 623 624 625 626 627 628 629 630 631 632 633 634 635 636 637 638 639 640 641 642 643 644 645 646 647 648 649 650 651 652 653 654 655 656 657 658 659 660 661 662 663 664 665 666 667 668 669 670 671 672 673 674 675 676 677 678 679 680 681 682 683 684 685 686 687 688 689 690 691 692 693 694 695 696 697 698 699 700 701 702 703 704 705 706 707 708 709 710 711 712 713 714 715 716 717 718 719 720 721 722 723 724 725 726 727 728 729 730 731 732 733 734 735 736 737 738 739 740 741 742 743 744 745 746 747 748 749 750 751 752 753 754 755 756 757 758 759 760 761 762 763 764 765 766 767 768 769 770 771 772 773 774 775 776 777 778 779 780 781 782 783 784 785 786 787 788 789 790 791 792 793 794 795 796 797 798 799 800 801 802 803 804 805 806 807 808 809 810 811 812 813 814 815 816 817 818 819 820 821 822 823 824 825 826 827 828 829 830 831 832 833 834 835 836 837 838 839 840 841 842 843 844 845 846 847 848 849 850 851 852 853 | [tbase@lhrtbase100 ~]$ pgxc_ctl --help /usr/bin/bash pgxc_ctl [option ...] [command] option: -c or --configuration conf_file: Specify configruration file. -v or --verbose: Specify verbose output. -V or --version: Print version and exit. -l or --logdir log_directory: specifies what directory to write logs. -L or --logfile log_file: Specifies log file. --home home_direcotry: Specifies pgxc_ctl work director. -i or --infile input_file: Specifies inptut file. -o or --outfile output_file: Specifies output file. -h or --help: Prints this message and exits. For more deatils, refer to pgxc_ctl reference manual included in postgres-xc reference manual. [tbase@lhrtbase100 ~]$ pgxc_ctl -c /tmp/pgxc_ctl.conf /usr/bin/bash Installing pgxc_ctl_bash script as /home/tbase/pgxc_ctl/pgxc_ctl_bash. Installing pgxc_ctl_bash script as /home/tbase/pgxc_ctl/pgxc_ctl_bash. Reading configuration using /home/tbase/pgxc_ctl/pgxc_ctl_bash --home /home/tbase/pgxc_ctl --configuration /tmp/pgxc_ctl.conf Finished reading configuration. ******** PGXC_CTL START *************** Current directory: /home/tbase/pgxc_ctl PGXC deploy all Deploying Postgres-XL components to all the target servers. Prepare tarball to deploy ... Deploying to the server 172.72.6.100. Deploying to the server 172.72.6.101. Deployment done. PGXC init all Initialize GTM master The files belonging to this GTM system will be owned by user "tbase". This user must also own the server process. fixing permissions on existing directory /data/tbase/gtm ... ok creating configuration files ... ok creating xlog dir ... ok Success. 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData context: LOCATION: GTM_PrintControlData, gtm_xlog.c:2055 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->gtm_control_version = 20180716 LOCATION: GTM_PrintControlData, gtm_xlog.c:2056 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->xlog_seg_size = 2097152 LOCATION: GTM_PrintControlData, gtm_xlog.c:2057 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->xlog_blcksz = 4096 LOCATION: GTM_PrintControlData, gtm_xlog.c:2058 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->state = 1 LOCATION: GTM_PrintControlData, gtm_xlog.c:2059 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->CurrBytePos = 4080 LOCATION: GTM_PrintControlData, gtm_xlog.c:2060 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->PrevBytePos = 4080 LOCATION: GTM_PrintControlData, gtm_xlog.c:2061 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->thisTimeLineID = 1 LOCATION: GTM_PrintControlData, gtm_xlog.c:2062 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->prevCheckPoint = 0/0 LOCATION: GTM_PrintControlData, gtm_xlog.c:2063 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->checkPoint = 0/1000 LOCATION: GTM_PrintControlData, gtm_xlog.c:2064 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->gts = 1000000000 LOCATION: GTM_PrintControlData, gtm_xlog.c:2065 4260030272:2022-04-11 16:34:54.359 CST -LOG: ControlData->time = 1649666094 LOCATION: GTM_PrintControlData, gtm_xlog.c:2066 waiting for server to shut down.....TBase create 15 worker thread. Start sever loop start thread count 24 running thread count 24. TBase GTM is ready to go!! done server stopped Done. Start GTM master server starting 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData context: LOCATION: GTM_PrintControlData, gtm_xlog.c:2055 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->gtm_control_version = 20180716 LOCATION: GTM_PrintControlData, gtm_xlog.c:2056 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->xlog_seg_size = 2097152 LOCATION: GTM_PrintControlData, gtm_xlog.c:2057 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->xlog_blcksz = 4096 LOCATION: GTM_PrintControlData, gtm_xlog.c:2058 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->state = 1 LOCATION: GTM_PrintControlData, gtm_xlog.c:2059 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->CurrBytePos = 4178000 LOCATION: GTM_PrintControlData, gtm_xlog.c:2060 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->PrevBytePos = 4177920 LOCATION: GTM_PrintControlData, gtm_xlog.c:2061 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->thisTimeLineID = 1 LOCATION: GTM_PrintControlData, gtm_xlog.c:2062 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->prevCheckPoint = 0/200000 LOCATION: GTM_PrintControlData, gtm_xlog.c:2063 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->checkPoint = 0/400000 LOCATION: GTM_PrintControlData, gtm_xlog.c:2064 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->gts = 1301235568 LOCATION: GTM_PrintControlData, gtm_xlog.c:2065 3935549248:2022-04-11 16:34:58.522 CST -LOG: ControlData->time = 1649666096 LOCATION: GTM_PrintControlData, gtm_xlog.c:2066 Initialize GTM slave The files belonging to this GTM system will be owned by user "tbase". This user must also own the server process. fixing permissions on existing directory /data/tbase/gtm ... ok creating configuration files ... ok creating xlog dir ... ok Success. Done. Start GTM slaveserver starting 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData context: LOCATION: GTM_PrintControlData, gtm_xlog.c:2055 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->gtm_control_version = 20180716 LOCATION: GTM_PrintControlData, gtm_xlog.c:2056 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->xlog_seg_size = 2097152 LOCATION: GTM_PrintControlData, gtm_xlog.c:2057 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->xlog_blcksz = 4096 LOCATION: GTM_PrintControlData, gtm_xlog.c:2058 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->state = 1 LOCATION: GTM_PrintControlData, gtm_xlog.c:2059 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->CurrBytePos = 4080 LOCATION: GTM_PrintControlData, gtm_xlog.c:2060 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->PrevBytePos = 4080 LOCATION: GTM_PrintControlData, gtm_xlog.c:2061 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->thisTimeLineID = 1 LOCATION: GTM_PrintControlData, gtm_xlog.c:2062 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->prevCheckPoint = 0/0 LOCATION: GTM_PrintControlData, gtm_xlog.c:2063 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->checkPoint = 0/1000 LOCATION: GTM_PrintControlData, gtm_xlog.c:2064 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->gts = 1000000000 LOCATION: GTM_PrintControlData, gtm_xlog.c:2065 236943168:2022-04-11 16:35:01.928 CST -LOG: ControlData->time = 1649666101 LOCATION: GTM_PrintControlData, gtm_xlog.c:2066 Done. Initialize all the coordinator masters. Initialize coordinator master cn001. Initialize coordinator master cn002. get master gtm nodename:gtm. get master gtm ip:172.72.6.100. get master gtm port:50001. The files belonging to this database system will be owned by user "tbase". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /data/tbase/coord ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... 2022-04-11 16:35:04.858 CST [19034,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:05.402 CST [19034,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:05.402 CST [19034,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:05.402 CST [19034,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:05.402 CST [19034,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 0 xid 3 partition 0 2022-04-11 16:35:05.402 CST [19034,coord(0.0)] LOG: startup CLOG next xid 3 latest page number 0 2022-04-11 16:35:05.402 CST [19034,coord(0.0)] LOG: Trim CLOG next xid 3 latest page number 0 2022-04-11 16:35:05.761 CST [19034,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:295 2022-04-11 16:35:05.761 CST [19034,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:05.761 CST [19034,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:05.761 CST [19034,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:05.761 CST [19034,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:05.761 CST [19034,coord(0.0)] LOG: shutdown committs ok performing post-bootstrap initialization ... creating cluster information ... 2022-04-11 16:35:05.922 CST [19041,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:06.446 CST [19041,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:06.446 CST [19041,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:06.544 CST [19041,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:06.544 CST [19041,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:06.544 CST [19041,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:06.544 CST [19041,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 0 xid 3 partition 0 2022-04-11 16:35:06.545 CST [19041,coord(0.0)] LOG: startup CLOG next xid 3 latest page number 0 2022-04-11 16:35:06.545 CST [19041,coord(0.0)] LOG: Trim CLOG next xid 3 latest page number 0 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:1014 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:07.856 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:12 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:07.910 CST [19041,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:08.298 CST [19041,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:3 2022-04-11 16:35:08.298 CST [19041,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:08.298 CST [19041,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:08.298 CST [19041,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:08.298 CST [19041,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:08.298 CST [19041,coord(0.0)] LOG: shutdown committs ok syncing data to disk ... ok freezing database template0 ... 2022-04-11 16:35:08.760 CST [19050,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:09.303 CST [19050,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:09.303 CST [19050,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:09.396 CST [19050,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:09.396 CST [19050,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:09.396 CST [19050,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:09.396 CST [19050,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:09.397 CST [19050,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:09.397 CST [19050,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:09.464 CST [19050,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:25 2022-04-11 16:35:09.464 CST [19050,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:09.464 CST [19050,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:09.464 CST [19050,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:09.464 CST [19050,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:09.465 CST [19050,coord(0.0)] LOG: shutdown committs ok freezing database template1 ... 2022-04-11 16:35:09.608 CST [19057,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:10.170 CST [19057,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:10.170 CST [19057,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:10.287 CST [19057,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:10.287 CST [19057,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:10.287 CST [19057,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:10.287 CST [19057,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:10.288 CST [19057,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:10.288 CST [19057,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:10.353 CST [19057,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:16 2022-04-11 16:35:10.353 CST [19057,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:10.353 CST [19057,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:10.353 CST [19057,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:10.353 CST [19057,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:10.353 CST [19057,coord(0.0)] LOG: shutdown committs ok freezing database postgres ... 2022-04-11 16:35:10.499 CST [19064,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:10.925 CST [19064,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:10.925 CST [19064,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:11.026 CST [19064,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:11.026 CST [19064,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:11.026 CST [19064,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:11.026 CST [19064,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:11.027 CST [19064,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:11.027 CST [19064,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:11.098 CST [19064,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:16 2022-04-11 16:35:11.098 CST [19064,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:11.098 CST [19064,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:11.098 CST [19064,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:11.098 CST [19064,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:11.099 CST [19064,coord(0.0)] LOG: shutdown committs ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. get master gtm nodename:gtm. get master gtm ip:172.72.6.100. get master gtm port:50001. The files belonging to this database system will be owned by user "tbase". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /data/tbase/coord ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... 2022-04-11 16:35:04.719 CST [5765,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:05.302 CST [5765,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:05.302 CST [5765,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:05.302 CST [5765,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:05.302 CST [5765,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 0 xid 3 partition 0 2022-04-11 16:35:05.302 CST [5765,coord(0.0)] LOG: startup CLOG next xid 3 latest page number 0 2022-04-11 16:35:05.302 CST [5765,coord(0.0)] LOG: Trim CLOG next xid 3 latest page number 0 2022-04-11 16:35:05.599 CST [5765,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:295 2022-04-11 16:35:05.599 CST [5765,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:05.599 CST [5765,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:05.599 CST [5765,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:05.599 CST [5765,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:05.600 CST [5765,coord(0.0)] LOG: shutdown committs ok performing post-bootstrap initialization ... creating cluster information ... 2022-04-11 16:35:05.717 CST [5772,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:06.284 CST [5772,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:06.284 CST [5772,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:06.375 CST [5772,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:06.375 CST [5772,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:06.375 CST [5772,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:06.375 CST [5772,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 0 xid 3 partition 0 2022-04-11 16:35:06.376 CST [5772,coord(0.0)] LOG: startup CLOG next xid 3 latest page number 0 2022-04-11 16:35:06.376 CST [5772,coord(0.0)] LOG: Trim CLOG next xid 3 latest page number 0 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:1014 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:07.658 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:12 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:07.710 CST [5772,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:07.757 CST [5772,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:3 2022-04-11 16:35:07.757 CST [5772,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:07.757 CST [5772,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:07.757 CST [5772,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:07.757 CST [5772,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:07.757 CST [5772,coord(0.0)] LOG: shutdown committs ok syncing data to disk ... ok freezing database template0 ... 2022-04-11 16:35:08.367 CST [5781,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:08.935 CST [5781,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:08.935 CST [5781,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:09.058 CST [5781,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:09.058 CST [5781,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:09.058 CST [5781,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:09.058 CST [5781,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:09.058 CST [5781,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:09.058 CST [5781,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:09.153 CST [5781,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:25 2022-04-11 16:35:09.153 CST [5781,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:09.153 CST [5781,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:09.153 CST [5781,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:09.153 CST [5781,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:09.154 CST [5781,coord(0.0)] LOG: shutdown committs ok freezing database template1 ... 2022-04-11 16:35:09.325 CST [5788,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:09.857 CST [5788,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:09.857 CST [5788,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:09.949 CST [5788,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:09.949 CST [5788,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:09.949 CST [5788,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:09.949 CST [5788,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:09.949 CST [5788,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:09.949 CST [5788,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:10.015 CST [5788,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:16 2022-04-11 16:35:10.015 CST [5788,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:10.015 CST [5788,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:10.015 CST [5788,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:10.015 CST [5788,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:10.015 CST [5788,coord(0.0)] LOG: shutdown committs ok freezing database postgres ... 2022-04-11 16:35:10.164 CST [5795,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:10.733 CST [5795,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:10.733 CST [5795,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:10.833 CST [5795,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:10.833 CST [5795,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:10.833 CST [5795,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:10.833 CST [5795,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:10.834 CST [5795,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:10.834 CST [5795,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:10.901 CST [5795,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:16 2022-04-11 16:35:10.901 CST [5795,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:10.901 CST [5795,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:10.901 CST [5795,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:10.901 CST [5795,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:10.902 CST [5795,coord(0.0)] LOG: shutdown committs ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. Done. Starting coordinator master. Starting coordinator master cn001 Starting coordinator master cn002 2022-04-11 16:35:14.598 CST [19445,coord(19445.0)] LOG: listening on IPv4 address "0.0.0.0", port 30004 2022-04-11 16:35:14.598 CST [19445,coord(19445.0)] LOG: listening on IPv6 address "::", port 30004 2022-04-11 16:35:14.640 CST [19445,coord(19445.0)] LOG: listening on Unix socket "/tmp/.s.PGSQL.30004" 2022-04-11 16:35:14.734 CST [19445,coord(19445.0)] LOG: init committs shmem. 2022-04-11 16:35:14.960 CST [19445,coord(19445.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:14.960 CST [19445,coord(19445.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:15.189 CST [19445,coord(19445.0)] LOG: redirecting log output to logging collector process 2022-04-11 16:35:15.189 CST [19445,coord(19445.0)] HINT: Future log output will appear in directory "log". 2022-04-11 16:35:14.598 CST [6094,coord(6094.0)] LOG: listening on IPv4 address "0.0.0.0", port 30004 2022-04-11 16:35:14.598 CST [6094,coord(6094.0)] LOG: listening on IPv6 address "::", port 30004 2022-04-11 16:35:14.640 CST [6094,coord(6094.0)] LOG: listening on Unix socket "/tmp/.s.PGSQL.30004" 2022-04-11 16:35:14.734 CST [6094,coord(6094.0)] LOG: init committs shmem. 2022-04-11 16:35:14.960 CST [6094,coord(6094.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:14.960 CST [6094,coord(6094.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:15.189 CST [6094,coord(6094.0)] LOG: redirecting log output to logging collector process 2022-04-11 16:35:15.189 CST [6094,coord(6094.0)] HINT: Future log output will appear in directory "log". Done. Initialize all the datanode masters. Initialize the datanode master dn001. Initialize the datanode master dn002. get master gtm nodename:gtm. get master gtm ip:172.72.6.100. get master gtm port:50001. The files belonging to this database system will be owned by user "tbase". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /data/tbase/dn001 ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... 2022-04-11 16:35:18.664 CST [21384,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:19.264 CST [21384,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:19.264 CST [21384,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:19.264 CST [21384,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:19.264 CST [21384,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 0 xid 3 partition 0 2022-04-11 16:35:19.265 CST [21384,coord(0.0)] LOG: startup CLOG next xid 3 latest page number 0 2022-04-11 16:35:19.265 CST [21384,coord(0.0)] LOG: Trim CLOG next xid 3 latest page number 0 2022-04-11 16:35:19.550 CST [21384,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:295 2022-04-11 16:35:19.550 CST [21384,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:19.550 CST [21384,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:19.550 CST [21384,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:19.551 CST [21384,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:19.551 CST [21384,coord(0.0)] LOG: shutdown committs ok performing post-bootstrap initialization ... creating cluster information ... 2022-04-11 16:35:19.675 CST [22092,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:20.240 CST [22092,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:20.240 CST [22092,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:20.336 CST [22092,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:20.336 CST [22092,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:20.336 CST [22092,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:20.336 CST [22092,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 0 xid 3 partition 0 2022-04-11 16:35:20.337 CST [22092,coord(0.0)] LOG: startup CLOG next xid 3 latest page number 0 2022-04-11 16:35:20.337 CST [22092,coord(0.0)] LOG: Trim CLOG next xid 3 latest page number 0 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:1014 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:21.622 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:12 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:21.707 CST [22092,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.788 CST [22092,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:3 2022-04-11 16:35:21.788 CST [22092,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:21.788 CST [22092,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:21.788 CST [22092,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:21.788 CST [22092,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:21.789 CST [22092,coord(0.0)] LOG: shutdown committs ok syncing data to disk ... ok freezing database template0 ... 2022-04-11 16:35:23.032 CST [24125,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:23.526 CST [24125,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:23.526 CST [24125,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:23.625 CST [24125,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:23.625 CST [24125,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:23.625 CST [24125,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:23.625 CST [24125,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:23.625 CST [24125,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:23.625 CST [24125,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:23.698 CST [24125,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:25 2022-04-11 16:35:23.698 CST [24125,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:23.698 CST [24125,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:23.698 CST [24125,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:23.698 CST [24125,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:23.699 CST [24125,coord(0.0)] LOG: shutdown committs ok freezing database template1 ... 2022-04-11 16:35:23.842 CST [24579,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:24.377 CST [24579,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:24.377 CST [24579,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:24.469 CST [24579,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:24.469 CST [24579,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:24.469 CST [24579,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:24.469 CST [24579,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:24.470 CST [24579,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:24.470 CST [24579,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:24.534 CST [24579,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:16 2022-04-11 16:35:24.534 CST [24579,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:24.534 CST [24579,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:24.534 CST [24579,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:24.534 CST [24579,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:24.534 CST [24579,coord(0.0)] LOG: shutdown committs ok freezing database postgres ... 2022-04-11 16:35:24.679 CST [25043,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:25.248 CST [25043,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:25.248 CST [25043,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:25.346 CST [25043,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:25.346 CST [25043,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:25.346 CST [25043,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:25.346 CST [25043,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:25.347 CST [25043,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:25.347 CST [25043,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:25.415 CST [25043,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:16 2022-04-11 16:35:25.415 CST [25043,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:25.415 CST [25043,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:25.415 CST [25043,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:25.415 CST [25043,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:25.416 CST [25043,coord(0.0)] LOG: shutdown committs ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. get master gtm nodename:gtm. get master gtm ip:172.72.6.100. get master gtm port:50001. The files belonging to this database system will be owned by user "tbase". This user must also own the server process. The database cluster will be initialized with locale "en_US.UTF-8". The default database encoding has accordingly been set to "UTF8". The default text search configuration will be set to "english". Data page checksums are disabled. fixing permissions on existing directory /data/tbase/dn002 ... ok creating subdirectories ... ok selecting default max_connections ... 100 selecting default shared_buffers ... 128MB selecting dynamic shared memory implementation ... posix creating configuration files ... ok running bootstrap script ... 2022-04-11 16:35:18.675 CST [8019,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:19.250 CST [8019,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:19.250 CST [8019,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:19.250 CST [8019,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:19.250 CST [8019,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 0 xid 3 partition 0 2022-04-11 16:35:19.251 CST [8019,coord(0.0)] LOG: startup CLOG next xid 3 latest page number 0 2022-04-11 16:35:19.251 CST [8019,coord(0.0)] LOG: Trim CLOG next xid 3 latest page number 0 2022-04-11 16:35:19.540 CST [8019,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:295 2022-04-11 16:35:19.540 CST [8019,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:19.540 CST [8019,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:19.540 CST [8019,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:19.540 CST [8019,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:19.540 CST [8019,coord(0.0)] LOG: shutdown committs ok performing post-bootstrap initialization ... creating cluster information ... 2022-04-11 16:35:19.664 CST [8604,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:20.229 CST [8604,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:20.229 CST [8604,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:20.330 CST [8604,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:20.330 CST [8604,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:20.330 CST [8604,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:20.330 CST [8604,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 0 xid 3 partition 0 2022-04-11 16:35:20.331 CST [8604,coord(0.0)] LOG: startup CLOG next xid 3 latest page number 0 2022-04-11 16:35:20.331 CST [8604,coord(0.0)] LOG: Trim CLOG next xid 3 latest page number 0 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:1014 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:21.625 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE template0 IS_TEMPLATE = true ALLOW_CONNECTIONS = false; 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:12 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:21.699 CST [8604,coord(0.0)] STATEMENT: CREATE DATABASE postgres; 2022-04-11 16:35:21.772 CST [8604,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:3 2022-04-11 16:35:21.772 CST [8604,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:21.772 CST [8604,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:21.772 CST [8604,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:21.772 CST [8604,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:21.773 CST [8604,coord(0.0)] LOG: shutdown committs ok syncing data to disk ... ok freezing database template0 ... 2022-04-11 16:35:23.032 CST [10613,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:23.596 CST [10613,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:23.596 CST [10613,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:23.719 CST [10613,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:23.719 CST [10613,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:23.719 CST [10613,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:23.719 CST [10613,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:23.719 CST [10613,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:23.719 CST [10613,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:23.799 CST [10613,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:25 2022-04-11 16:35:23.799 CST [10613,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:23.799 CST [10613,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:23.799 CST [10613,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:23.799 CST [10613,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:23.799 CST [10613,coord(0.0)] LOG: shutdown committs ok freezing database template1 ... 2022-04-11 16:35:23.943 CST [11184,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:24.480 CST [11184,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:24.480 CST [11184,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:24.588 CST [11184,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:24.588 CST [11184,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:24.588 CST [11184,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:24.588 CST [11184,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:24.589 CST [11184,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:24.589 CST [11184,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:24.666 CST [11184,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:16 2022-04-11 16:35:24.666 CST [11184,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:24.666 CST [11184,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:24.666 CST [11184,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:24.666 CST [11184,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:24.666 CST [11184,coord(0.0)] LOG: shutdown committs ok freezing database postgres ... 2022-04-11 16:35:24.827 CST [11690,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:25.253 CST [11690,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:25.253 CST [11690,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:25.348 CST [11690,coord(0.0)] LOG: read latestCommitTs 1 read latestGTS 1 2022-04-11 16:35:25.348 CST [11690,coord(0.0)] LOG: startup commitTS. 2022-04-11 16:35:25.348 CST [11690,coord(0.0)] LOG: activate commit ts. 2022-04-11 16:35:25.348 CST [11690,coord(0.0)] LOG: ActivateCommitTs: committs latest page number 1 xid 599 partition 1 2022-04-11 16:35:25.348 CST [11690,coord(0.0)] LOG: startup CLOG next xid 599 latest page number 0 2022-04-11 16:35:25.348 CST [11690,coord(0.0)] LOG: Trim CLOG next xid 599 latest page number 0 2022-04-11 16:35:25.415 CST [11690,coord(0.0)] LOG: CHECKPOINT:in one round, buffer crypted write:0, normal buffer write:16 2022-04-11 16:35:25.415 CST [11690,coord(0.0)] LOG: detail for workers:id:0-bufs:0, 2022-04-11 16:35:25.415 CST [11690,coord(0.0)] LOG: detail for workers:id:1-bufs:0, 2022-04-11 16:35:25.415 CST [11690,coord(0.0)] LOG: detail for workers:id:2-bufs:0, 2022-04-11 16:35:25.415 CST [11690,coord(0.0)] LOG: detail for workers:id:3-bufs:0, 2022-04-11 16:35:25.415 CST [11690,coord(0.0)] LOG: shutdown committs ok WARNING: enabling "trust" authentication for local connections You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb. Success. Done. Starting all the datanode masters. Starting datanode master dn001. Starting datanode master dn002. 2022-04-11 16:35:31.137 CST [29046,coord(0.0)] LOG: listening on IPv4 address "0.0.0.0", port 40004 2022-04-11 16:35:31.137 CST [29046,coord(0.0)] LOG: listening on IPv6 address "::", port 40004 2022-04-11 16:35:31.199 CST [29046,coord(0.0)] LOG: listening on Unix socket "/tmp/.s.PGSQL.40004" 2022-04-11 16:35:31.285 CST [29046,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:31.614 CST [29046,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:31.614 CST [29046,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:31.829 CST [29046,coord(0.0)] LOG: redirecting log output to logging collector process 2022-04-11 16:35:31.829 CST [29046,coord(0.0)] HINT: Future log output will appear in directory "log". 2022-04-11 16:35:31.137 CST [15412,coord(0.0)] LOG: listening on IPv4 address "0.0.0.0", port 40004 2022-04-11 16:35:31.137 CST [15412,coord(0.0)] LOG: listening on IPv6 address "::", port 40004 2022-04-11 16:35:31.199 CST [15412,coord(0.0)] LOG: listening on Unix socket "/tmp/.s.PGSQL.40004" 2022-04-11 16:35:31.287 CST [15412,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:31.617 CST [15412,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:31.618 CST [15412,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:31.832 CST [15412,coord(0.0)] LOG: redirecting log output to logging collector process 2022-04-11 16:35:31.832 CST [15412,coord(0.0)] HINT: Future log output will appear in directory "log". Done. Initialize all the datanode slaves. Initialize datanode slave dn001 Initialize datanode slave dn002 ERROR: target directory (/data/tbase/dn001) exists and not empty. Skip Datanode initilialization Starting all the datanode slaves. Starting datanode slave dn001. Starting datanode slave dn002. 2022-04-11 16:35:40.438 CST [25052,coord(0.0)] LOG: listening on IPv4 address "0.0.0.0", port 50004 2022-04-11 16:35:40.487 CST [25052,coord(0.0)] LOG: listening on Unix socket "/tmp/.s.PGSQL.50004" 2022-04-11 16:35:40.557 CST [25052,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:40.861 CST [25052,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:40.861 CST [25052,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:41.061 CST [25052,coord(0.0)] LOG: redirecting log output to logging collector process 2022-04-11 16:35:41.061 CST [25052,coord(0.0)] HINT: Future log output will appear in directory "log". 2022-04-11 16:35:40.438 CST [6482,coord(0.0)] LOG: listening on IPv4 address "0.0.0.0", port 50004 2022-04-11 16:35:40.487 CST [6482,coord(0.0)] LOG: listening on Unix socket "/tmp/.s.PGSQL.50004" 2022-04-11 16:35:40.557 CST [6482,coord(0.0)] LOG: init committs shmem. 2022-04-11 16:35:40.883 CST [6482,coord(0.0)] LOG: could not open file "global/pg_crypt_key.map":No such file or directory for bufFile merging. 2022-04-11 16:35:40.883 CST [6482,coord(0.0)] LOG: could not open file "global/pg_rel_crypt.map":No such file or directory for bufFile merging. 2022-04-11 16:35:41.117 CST [6482,coord(0.0)] LOG: redirecting log output to logging collector process 2022-04-11 16:35:41.117 CST [6482,coord(0.0)] HINT: Future log output will appear in directory "log". Done. ALTER NODE cn001 WITH (HOST='172.72.6.100', PORT=30004); ALTER NODE CREATE NODE cn002 WITH (TYPE='coordinator', HOST='172.72.6.101', PORT=30004); CREATE NODE CREATE NODE dn001 WITH (TYPE='datanode', HOST='172.72.6.100', PORT=40004, PRIMARY, PREFERRED); CREATE NODE CREATE NODE dn002 WITH (TYPE='datanode', HOST='172.72.6.101', PORT=40004); CREATE NODE SELECT pgxc_pool_reload(); pgxc_pool_reload ------------------ t (1 row) CREATE NODE cn001 WITH (TYPE='coordinator', HOST='172.72.6.100', PORT=30004); CREATE NODE ALTER NODE cn002 WITH (HOST='172.72.6.101', PORT=30004); ALTER NODE CREATE NODE dn001 WITH (TYPE='datanode', HOST='172.72.6.100', PORT=40004, PRIMARY); CREATE NODE CREATE NODE dn002 WITH (TYPE='datanode', HOST='172.72.6.101', PORT=40004, PREFERRED); CREATE NODE SELECT pgxc_pool_reload(); pgxc_pool_reload ------------------ t (1 row) Done. EXECUTE DIRECT ON (dn001) 'CREATE NODE cn001 WITH (TYPE=''coordinator'', HOST=''172.72.6.100'', PORT=30004)'; EXECUTE DIRECT EXECUTE DIRECT ON (dn001) 'CREATE NODE cn002 WITH (TYPE=''coordinator'', HOST=''172.72.6.101'', PORT=30004)'; EXECUTE DIRECT EXECUTE DIRECT ON (dn001) 'ALTER NODE dn001 WITH (TYPE=''datanode'', HOST=''172.72.6.100'', PORT=40004, PRIMARY, PREFERRED)'; EXECUTE DIRECT EXECUTE DIRECT ON (dn001) 'CREATE NODE dn002 WITH (TYPE=''datanode'', HOST=''172.72.6.101'', PORT=40004, PREFERRED)'; EXECUTE DIRECT EXECUTE DIRECT ON (dn001) 'SELECT pgxc_pool_reload()'; pgxc_pool_reload ------------------ t (1 row) EXECUTE DIRECT ON (dn002) 'CREATE NODE cn001 WITH (TYPE=''coordinator'', HOST=''172.72.6.100'', PORT=30004)'; EXECUTE DIRECT EXECUTE DIRECT ON (dn002) 'CREATE NODE cn002 WITH (TYPE=''coordinator'', HOST=''172.72.6.101'', PORT=30004)'; EXECUTE DIRECT EXECUTE DIRECT ON (dn002) 'CREATE NODE dn001 WITH (TYPE=''datanode'', HOST=''172.72.6.100'', PORT=40004, PRIMARY, PREFERRED)'; EXECUTE DIRECT EXECUTE DIRECT ON (dn002) 'ALTER NODE dn002 WITH (TYPE=''datanode'', HOST=''172.72.6.101'', PORT=40004, PREFERRED)'; EXECUTE DIRECT EXECUTE DIRECT ON (dn002) 'SELECT pgxc_pool_reload()'; pgxc_pool_reload ------------------ t (1 row) Done. PGXC show config all ========= Postgres-XL configuration Common Info ======================== === Overall === Postgres-XL owner: tbase Postgres-XL user: tbase Postgres-XL install directory: /opt/tbase pgxc_ctl home: /home/tbase/pgxc_ctl pgxc_ctl configuration file: /tmp/pgxc_ctl.conf pgxc_ctl tmpDir: /tmp pgxc_ctl localTempDir: /tmp pgxc_ctl log file: /home/tbase/pgxc_ctl/pgxc_log/18363_pgxc_ctl.log pgxc_ctl configBackup: n pgxc_ctl configBackupHost: none pgxc_ctl configBackupFile: none ========= Postgres-XL configuration End Common Info =================== ====== Server: 172.72.6.100 ======= GTM Master: Nodename: 'gtm', port: 50001, dir: '/data/tbase/gtm' ExtraConfig: 'none', Specific Extra Config: 'none' Coordinator Master: Nodename: 'cn001', port: 30004, pooler port: 31110 MaxWalSenders: 2, Dir: '/data/tbase/coord' ExtraConfig: 'coordExtraConfig', Specific Extra Config: 'none' pg_hba entries ( '0.0.0.0/0' ) Extra pg_hba: 'coordExtraPgHba', Specific Extra pg_hba: 'none' Datanode Master: Nodename: 'dn001', port: 40004, pooler port 31110 MaxWALSenders: 4, Dir: '/data/tbase/dn001' ExtraConfig: 'datanodeExtraConfig', Specific Extra Config: 'none' pg_hba entries ( '0.0.0.0/0' ) Extra pg_hba: 'datanodeExtraPgHba', Specific Extra pg_hba: 'none' Datanode Slave: Nodename: 'dn002', port: 50004, pooler port: 31110 Dir: '/data/tbase/dn002', Archive Log Dir: '/data/tbase/datanode_archlog/dn002' ====== Server: 172.72.6.101 ======= GTM Slave: Nodename: 'gtm', port: 50001, dir: '/data/tbase/gtm' ExtraConfig: 'none', Specific Extra Config: 'none' Coordinator Master: Nodename: 'cn002', port: 30004, pooler port: 31110 MaxWalSenders: 2, Dir: '/data/tbase/coord' ExtraConfig: 'coordExtraConfig', Specific Extra Config: 'none' pg_hba entries ( '0.0.0.0/0' ) Extra pg_hba: 'coordExtraPgHba', Specific Extra pg_hba: 'none' Datanode Master: Nodename: 'dn002', port: 40004, pooler port 31110 MaxWALSenders: 4, Dir: '/data/tbase/dn002' ExtraConfig: 'datanodeExtraConfig', Specific Extra Config: 'none' pg_hba entries ( '0.0.0.0/0' ) Extra pg_hba: 'datanodeExtraPgHba', Specific Extra pg_hba: 'none' Datanode Slave: Nodename: 'dn001', port: 50004, pooler port: 31110 Dir: '/data/tbase/dn001', Archive Log Dir: '/data/tbase/datanode_archlog/dn001' PGXC PGXC monitor all Running: gtm master Running: gtm slave Running: coordinator master cn001 Running: coordinator master cn002 Running: datanode master dn001 Running: datanode slave dn001 Running: datanode master dn002 Running: datanode slave dn002 |
集群访问
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 | [tbase@lhrtbase100 ~]$ psql -h 172.72.6.100 -p 30004 -d postgres -U tbase psql (PostgreSQL 10.0 TBase V2) Type "help" for help. postgres=# select * from pgxc_node; node_name | node_type | node_port | node_host | nodeis_primary | nodeis_preferred | node_id | node_cluster_name -----------+-----------+-----------+--------------+----------------+------------------+------------+------------------- gtm | G | 50001 | 172.72.6.100 | t | f | 428125959 | tbase_cluster cn001 | C | 30004 | 172.72.6.100 | f | f | -264077367 | tbase_cluster cn002 | C | 30004 | 172.72.6.101 | f | f | -674870440 | tbase_cluster dn001 | D | 40004 | 172.72.6.100 | t | t | 2142761564 | tbase_cluster dn002 | D | 40004 | 172.72.6.101 | f | f | -17499968 | tbase_cluster (5 rows) postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+-------------+-------------+------------------- postgres | tbase | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | tbase | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/tbase + | | | | | tbase=CTc/tbase template1 | tbase | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/tbase + | | | | | tbase=CTc/tbase (3 rows) postgres=# create database lhrdb; CREATE DATABASE [root@lhrtbase101 tbase]# psql -h 172.72.6.101 -p 30004 -d postgres -U tbase psql (PostgreSQL 10.0 TBase V2) Type "help" for help. postgres=# \l List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+-------+----------+-------------+-------------+------------------- lhrdb | tbase | UTF8 | en_US.UTF-8 | en_US.UTF-8 | postgres | tbase | UTF8 | en_US.UTF-8 | en_US.UTF-8 | template0 | tbase | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/tbase + | | | | | tbase=CTc/tbase template1 | tbase | UTF8 | en_US.UTF-8 | en_US.UTF-8 | =c/tbase + | | | | | tbase=CTc/tbase (4 rows) |
创建测试表
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 | [tbase@lhrtbase100 ~]$ psql -h 172.72.6.100 -p 30004 -d lhrdb -U tbase psql (PostgreSQL 10.0 TBase V2) Type "help" for help. lhrdb=# create table test1(id int,name text); CREATE TABLE lhrdb=# insert into test1(id,name) select generate_series(1,8),'test'; INSERT 0 8 lhrdb=# select count(*) from test1; count ------- 8 (1 row) lhrdb=# SELECT xc_node_id, count(*) FROM test1 GROUP BY xc_node_id; xc_node_id | count ------------+------- -17499968 | 3 2142761564 | 5 (2 rows) [tbase@lhrtbase100 ~]$ psql -h 172.72.6.101 -p 30004 -d lhrdb -U tbase -c "select count(*) from test1" count ------- 8 (1 row) [tbase@lhrtbase100 ~]$ psql -h 172.72.6.100 -p 40004 -d lhrdb -U tbase -c "select count(*) from test1" count ------- 5 (1 row) [tbase@lhrtbase100 ~]$ psql -h 172.72.6.101 -p 40004 -d lhrdb -U tbase -c "select count(*) from test1" count ------- 3 (1 row) |
创建default group以及sharding
TBase使用datanode group来增加节点的管理灵活度，要求有一个default group才能使用；
TBase数据分布为了增加灵活度，加了中间逻辑层来维护数据记录到物理节点的映射，叫sharding，要预先创建
1 2 | create default node group default_group with (dn001,dn002); create sharding group to group default_group; |
参考
https://github.com/Tencent/TBase/wiki/1.-TBase_Quick_Start
