简单了解了下人大金仓数据库Kingbase，本身比较感兴趣的，但是在体验后瞬间没有了兴趣，所以呢相关的介绍就再引用官网的了，因为说实话没必要，简单一句话概况：基于开源PG二次开发，并非纯自研。官网鼓吹的自研国产化产品，个人看来是个笑话，与其遮遮掩掩，不如就光明正大说：我就是基于开源数据库自研，有什么不好，二次自研并非不可，但是硬生生说自己自研就太扯了，典型当别人是傻子。就说这么多吧，后续的体验中大家就知道了。
底层环境调整
修改内核参数
vim /etc/sysctl.conf
#add by kingbase
#/proc/sys/kernel/优化
# 10000 connect remain:
kernel.sem = 250 162500 250 650
#notice: shall shmmax is base on 16GB, you may adjust it for your MEM
#for 16GB Mem:
#kernel.shmall = 3774873
#kernel.shmmax = 8589934592
#for 32GB Mem:
#kernel.shmall = 7549747
#kernel.shmmax = 17179869184
#for 64GB Mem:
kernel.shmall = 15099494
kernel.shmmax = 34359738368
#for 128GB Mem:
#kernel.shmall = 30198988
#kernel.shmmax = 68719476736
#for 256GB Mem:
#kernel.shmall = 60397977
#kernel.shmmax = 137438953472
#for 512GB Mem:
#kernel.shmall = 120795955
#kernel.shmmax = 274877906944
kernel.shmmni = 4096
vm.dirty_background_ratio=2
vm.dirty_ratio = 40
vm.overcommit_memory = 2
vm.overcommit_ratio = 90
vm.swappiness = 0
fs.aio-max-nr = 1048576
fs.file-max = 6815744
fs.nr_open = 20480000
# TCP端口使用范围
net.ipv4.ip_local_port_range = 10000 65000
net.ipv4.tcp_keepalive_time = 1200
net.ipv4.tcp_keepalive_probes = 3
net.ipv4.tcp_keepalive_intvl = 30
net.ipv4.tcp_max_syn_backlog = 8192
net.ipv4.tcp_max_tw_buckets = 6000
# 记录的那些尚未收到客户端确认信息的连接请求的最大值
net.ipv4.tcp_max_syn_backlog = 65536
# 每个网络接口接收数据包的速率比内核处理这些包的速率快时，允许送到队列的数据包的最大数目
net.core.somaxconn=1024
net.core.netdev_max_backlog = 32768
net.core.wmem_default = 8388608
net.core.wmem_max = 1048576
net.core.rmem_default = 8388608
net.core.rmem_max = 16777216
net.ipv4.tcp_synack_retries = 2
net.ipv4.tcp_fin_timeout = 30
net.ipv4.tcp_syn_retries = 2
net.ipv4.route.gc_timeout = 100
net.ipv4.tcp_wmem = 8192 436600 873200
net.ipv4.tcp_rmem = 32768 436600 873200
net.ipv4.tcp_mem = 94500000 91500000 92700000
net.ipv4.tcp_max_orphans = 3276800创建用户
[root@localhost kingbase]# useradd kingbase
[root@localhost kingbase]# passwd kingbase
Changing password for user kingbase.
New password:
BAD PASSWORD: The password contains the user name in some form
Retype new password:
passwd: all authentication tokens updated successfully.
[root@localhost kingbase]#
创建软件安装目录
[root@localhost kingbase]# mkdir -p /soft/kingbase/ESV8
[root@localhost kingbase]# chown -R kingbase:kingbase /soft/kingbase安装包准备
官网下载安装包并上传到服务器
[root@localhost setup]# pwd
/soft/kingbase/setup
[root@localhost setup]# ls
KingbaseES_V008R006C007B0024_Lin64_install.iso license_11325_0.dat
[root@localhost setup]# mkdir -p ls
[root@localhost setup]# chown -R kingbase:kingbase /soft/kingbase
[root@localhost setup]# chmod 755 /soft/kingbase/ -R
[root@localhost setup]# mount KingbaseES_V008R006C007B0024_Lin64_install.iso ls
mount: /soft/kingbase/setup/ls: WARNING: device write-protected, mounted read-only.
[root@localhost setup]# 数据库安装及实例初始化
数据库安装一般命令行或图形化安装，调用方式不同，图形化安装命令如下：
sh setup.sh或sh setup.sh -i swing金仓数据库软件安装和初始化实例在一起进行，安装完成后均需要单独执行脚本/Scripts/Root.sh，整体安装才完整。默认参数信息如下：
默认端口为:54321（可自定义）
默认账户为:system（可自定义）
密码（自定义）system
默认Encoding为：UTF8（可选GBK、GB18030）
DatabaseMode为：ORACLE（可选PG）
本文为命令行方式安装，详细过程如下：
[root@localhost setup]# su - kingbase
[kingbase@localhost ~]$ cd /soft/kingbase/setup/ls/
[kingbase@localhost ls]$ ls
setup setup.sh
[kingbase@localhost ls]$ sh setup.sh -i console
Now launch installer...
Preparing to install
Extracting the JRE from the installer archive...
Unpacking the JRE...
Extracting the installation resources from the installer archive...
Configuring the installer for this system's environment...
Verifying JVM........
Launching installer...
===============================================================================
KingbaseES V8 (created with InstallAnywhere)
-------------------------------------------------------------------------------
Preparing CONSOLE Mode Installation...
===============================================================================
Please Wait
-----------
===============================================================================
Welcome
-------
This installer will guide you through the installation of KingbaseES V8.
It is strongly recommended that you quit all programs before continuing with
this installation. You may cancel this installation by typing 'quit'.
KingbaseES Version: V8
Kingbase Type:BMJ-NO
Installer Version: V008R006C007B0024
Install DATE:202309180905
Kingbase Inc.
http://www.kingbase.com.cn
PRESS <ENTER> TO CONTINUE:
===============================================================================
Please Wait
-----------
===============================================================================
License Agreement
-----------------
Installation and Use of KingbaseES V8 Requires Acceptance of the Following
License Agreement:
Beijing Kingbase Information Technologies Inc.
"SOFTWARE END-USER LICENSE AGREEMENT"
IMPORTANT-READ CAREFULLY: This End-User License Agreement ("EULA") is a legal
agreement between you (either an individual or a single entity) and Beijing
Kingbase Information Technologies Inc.(abbreviated as Kingbase in the
context). The "software product" includes computer software, and may include
associated media, printed materials, and online documentation(Software
product). This "software product" includes any upgrade and supplemental
materials to the original "software product" provided by Kingbase. Any
software product that are provided with the "software product", which are
accompanied by their own license agreements or terms of use are governed by
this EULA. You agree to be bound by the terms of this EULA by installing,
copying, downloading, accessing or otherwise using the "software product". If
you do not agree to the terms of this EULA, you may not install, copy or use
the "software product".
SOFTWARE PRODUCT LICENSE
The "software product" is protected by copyright laws, international copyright
treaty and other intellectual property laws and treaties.
The "software product" is licensed to use, not sold.
PRESS <ENTER> TO CONTINUE:
1. GRANT OF LICENSE. As long as you follow this EULA, Kingbase grants you the
following non-exclusive, non-transitive rights:
APPLICATION SOFTWARE. You can use the software in locations as agreed in the
related contract. The usage is restricted by the quantity of the purchased and
the type of the license (as agreed in the contract). If the license type has
no special specification, you can only install, use, access, display, run or
use other methods to interact(run) with one copy of this "software product"
(or any previous versions on the same operating system) on a single computer,
workstation, handheld computer, smart phone or other electronic device
("computer").
RESERVATION OF RIGHTS. Except for the specific statements in this EULA,
Kingbase reserves all rights not expressly granted to you. Kingbase reserves
the right to interpret the content of the agreement.
2. LIMITATIONS AND OTHER RIGHT
LIMITATION ON TRANSFER. Under any condition, without the written permission of
Kingbase, you may not transfer this license and any usage permission under
this license.
PRESS <ENTER> TO CONTINUE:
NOT FOR RESALE SOFTWARE. If this "software product" is identified as "Not For
Resale", it may not be sold or otherwise transferred for value, or used for
any purpose other than demonstration, test or evaluation, no matter what else
is stated in this EULA.
LIMITATIONS ON REVERSE ENGINEERING, DECOMPILATION, AND DISASSEMBLY. You may
not reverse engineer, decompile, or disassemble the "software product", except
and only to the extent that such activity is expressly permitted by applicable
law not with standing this limitation.
TRADEMARKS. This EULA does not grant you any rights in connection with any
trademarks or service marks of Kingbase.
NO RENTAL. You may not rent, lease or lend the "software product" to others.
EXPORT LIMITATION. You admit that the "software product" is governed by the
export laws of People's Republic of China. You agree to obey all the
international and domestic laws applicable to this "software product",
including "Foreign Trade Law of the People's Republic of China", and other
restrictions and regulations issued by the Chinese government related to
software exportation.
PRESS <ENTER> TO CONTINUE:
PRODUCT SUPPORT. Kingbase provides you the support service related to the
software product ("support service"), but the specific content of the support
service is limited by related contract. Kingbase reserves the right to charge
the support service. The usage of support service is restricted by the
policies and plans in the user's manual, online document and/or other Kingbase
provided materials. Any supplemental software code provided to you should be
treated as a part of the "software product", and has to comply the terms and
conditions in this EULA. As for the technical information you provided to
Kingbase as a part of the support service, Kingbase may commercialize it,
including product support and development. Kingbase will not mention you
individually when using this technical information.
TERMINATION. Without prejudice to other rights, Kingbase may terminate this
EULA if you fail to comply with the terms and conditions of this EULA. In such
event, you must destroy all copies of the "software product" and all of its
component parts.
3. UPGRADES. If the "software product" is labeled as an upgrade, you must be
properly licensed to use a product identified by Kingbase as being eligible
for the upgrade in order to use the "software product". Kingbase reserves the
right to charge the upgrade version or upgrade. "software product" labeled as
PRESS <ENTER> TO CONTINUE:
an upgrade replaces and/or supplements the Eligible Product which you are
qualified to use. You may use the resulting upgraded product only in
accordance with the terms of this EULA. If the "software product" is an
upgrade of a component of a package of software programs that you licensed as
a single product, the "software product" may be used and transferred only as
part of that single product package and may not be separated for use on more
than one computer.
4. INTELLECTUAL PROPERTY. The ownership, copyright and other intellectual
property of the "software product" (including but not limited to the picture,
photo, animation, video, recordings, music, text and supplemental programs
contained in the "software product"), enclosed printed materials and any
copies of the "software product", is owner by Kingbase and its suppliers. The
ownership and intellectual property accessed by this "software product"
belongs to the owner of the contents, and may be protected by copyright laws,
and other intellectual property laws and treaties. This EULA does not grant
you the right to use these contents. If this "software product" include
documents only provided electronically, you can print one copy of the
electronic documents. You may not remove the copyright declaration from the
software, and ensures that the copyright declaration is copied for the replica
(whole or part) of the "software product". You agree to stop any forms of
illegal copying this software and the documents. You cannot copy the enclosed
PRESS <ENTER> TO CONTINUE:
printed materials in this "software product".
5. MULTIMEDIA SOFTWARE. You may obtain the "software product" through multiple
medias. No matter the type and size of the media you receive, you can only use
the media which is applicable to your single computer. You cannot run a
different media on another computer. Except for the part as in "permanent
transfer" of the "software product (as stated above), you cannot transfer the
other medias to another user via rent, lease or lend.
6. BACKUP COPY. After installing a copy of the "software product" according to
the EULA, you may keep the original media by which Kingbase provided you the
"software product" solely for backup or archival purpose. If original media is
needed to use the "software product", you may make one back-up copy solely for
your backup or archival purposes. Except as expressly provided in this EULA,
you may not otherwise make copies of the software, including the printed
materials accompanying the software. Authorized copy should be kept in secured
environments.
7. CONFIDENTIALITY. "Confidential information" includes program(including the
methods and concepts used in the program) and any information that Kingbase
identifies as exclusive or confidential. Unless expressly granted by this
EULA, you may not expose or provide the confidential information by other
PRESS <ENTER> TO CONTINUE:
methods to a third party and any employees to whom you do not grant the usage
in their business. You should take any reasonable, necessary measures to
ensure that the program or any component of the software is not exposed or
provided by other methods to a third party.
If you acquired the Kingbase product in People's Republic of China, the
following limited warranty applies to you.
1. LIMITED WARRANTY.
As long as you have valid license, Kingbase warrants that: (1) The "software
product" will perform substantially in accordance with the accompanying
materials for a period of ninety (90) days after the date of receipt. (2) The
provided support will perform substantially in accordance with the
accompanying materials, and Kingbase engineers will try their best to solve
any problems permitted by commercial range. If the product is not compliant to
the warranty, Kingbase will fix, replace the product or refund you for the
product, and you have to return the "software product" to Kingbase along with
the invoice held by you. If the malfunction of the product is due to accident,
abuse or misuse, then the warranty is not effective. The replaced product has
the residual of the original warranty period, or thirty days, whichever is
longer. To the maximum extent permitted by applicable law, except for the
above warranty, all expressed or implied warranties, conditions and other
PRESS <ENTER> TO CONTINUE:
terms are denied by Kingbase. All implicit warranties which cannot be excluded
are limited to 90 days or the minimum period allowed by the appropriate laws,
whichever is longer.
2. LIMITATION OF LIABILITY
To the maximum extent permitted by applicable law, except for the above
warranty, Kingbase and its suppliers shall not be liable for any damages
whatsoever (including without limitation, damages for loss of business
profits, business interruption, loss of business information or other
pecuniary loss) arising out of the use or inability to use the "software
product", even if Kingbase and its suppliers have been advised of the
possibility of such damages. In any case Kingbase and any of its suppliers'
entire liability under any provision of this EULA shall be limited to the
amount actually paid by you for the "software product" or RMB 10.00 Yuan,
which ever is higher. However, if you have signed support agreement with
Kingbase, all Kingbase's liability of the support service will be defined by
that agreement.
GOVERNING LAWS
This EULA is governed by the laws of the People's Republic of China (including
but not restricted to "Copyright Law of the People's Republic of China",
"Regulations for the Protection of Computer Software of the People's Republic
PRESS <ENTER> TO CONTINUE:
of China", "Trademark Law of the People's Republic of China", "Patent Law of
the People's Republic of China", "Anti-Unfair Competition Law of the People's
Republic of China", etc.). In respect of any dispute or claim which may arise
by this EULA or the violation of the EULA, you consent to the jurisdiction of
the federal and provincial courts sitting in the location of Kingbase. If
Kingbase's intellectual property is violated, the above terms do not restrict
Kingbase to apply remedial measures from the legitimate court with governing
rights.
Beijing Kingbase Information Technologies Inc.
Add: 3 layer, B block, Information Industrial Park, Rongda Road 7, Chaoyang
District, Beijing, 100102 China
Tel: 86-10-5885 1118
Http: //www.kingbase.com.cn
National Hotline: 400-601-1188
Support E-mail: support@kingbase.com.cn
DO YOU ACCEPT THE TERMS OF THIS LICENSE AGREEMENT? (Y/N): y
===============================================================================
Choose Install Set
------------------
Please choose the Install Set to be installed by this installer.
->1- Full
2- Client
3- Custom
ENTER THE NUMBER FOR THE INSTALL SET, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: 1
===============================================================================
Choose License File
-------------------
File Path: /soft/kingbase/setup/license_11325_0.dat
License序列号 --- 启用 --- ECEF0D88-32FE-11EC-AE8E-000C29CBE49F
生产日期 --- 启用 --- 2021-10-22
产品名称 --- 启用 --- KingbaseES V8
细分版本模板名 --- 启用 --- SALES-开发版 V8R6
产品版本号 --- 启用 --- V008R006C
浮动基准日期 ------ 启用
有效期间 --- 启用 --- 0
用户名称 --- 启用 --- 官方网站试用授权
项目名称 --- 启用 --- 官方网站试用授权
CPU检查 --- 启用 --- 0
MAC地址 --- 启用 --- 00:00:00:00:00:00
最大连接数 --- 启用 --- 10
并行查询 --- 启用 --- 0
异构数据源 --- 启用 --- 0
分区表 --- 启用 --- 0
全文检索 --- 启用 --- 0
审计 --- 启用 --- 0
透明加密 --- 启用 --- 0
强制访问控制 --- 启用 --- 0
三权分立 --- 启用 --- 0
密码复杂度 --- 启用 --- 0
用户锁定 --- 启用 --- 0
快速加载 --- 启用 --- 0
物理同步 --- 启用 --- 0
读写分离集群 --- 启用 --- 0
恢复到指定时间点 --- 启用 --- 0
网络故障容错增强 --- 启用 --- 0
日志压缩 --- 启用 --- 0
保密通讯协议 --- 启用 --- 0
集群管理软件 --- 启用 --- 0
集群配置工具 --- 启用 --- 0
并行备份还原 --- 启用 --- 0
===============================================================================
Choose Install Folder
---------------------
Please choose a destination folder for this installation.
Where would you like to install?
Default Install Folder: /opt/Kingbase/ES/V8
ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT
: /soft/kingbase/ESV8
INSTALL FOLDER IS: /soft/kingbase/ESV8
IS THIS CORRECT? (Y/N): Y
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Pre-Installation Summary
------------------------
Please Review the Following Before Continuing:
Product Name:
KingbaseES V8
Install Folder:
/soft/kingbase/ESV8
Product Features:
SERVER,
INTERFACE,
DEPLOY,
KINGBASEHA,
KSTUDIO,
KDTS
Install Disk Space Information
Require Disk space : 5235 MB Free Disk Space : 28284 MB
PRESS <ENTER> TO CONTINUE:
===============================================================================
Ready To Install
----------------
InstallAnywhere is now ready to install KingbaseES V8 onto your system at the
following location:
/soft/kingbase/ESV8
PRESS <ENTER> TO INSTALL:
===============================================================================
Installing...
-------------
[==================|==================|==================|==================]
[------------------|------------------|------------------|------------------]
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Choose a Folder for data directory
----------------------------------
Please choose a folder. The folder must be empty.
Data folder (Default: /soft/kingbase/ESV8/data): /soft/kingbase/ESV8/data
===============================================================================
Port
----
Please enter database service listened port， default 54321.
Port (Default: 54321): 54321
===============================================================================
User
----
Please enter database administrator user name.
User: (Default: system):
===============================================================================
Enter Password
--------------
Please Enter the Password: Please Enter the Password:*******
===============================================================================
Enter Password again
--------------------
Please Enter the Password Again: Please Enter the Password Again:*******
===============================================================================
Server Encoding
---------------
Please enter server character set encoding.
->1- UTF8
2- GBK
3- GB18030
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 1
===============================================================================
Database Mode
-------------
Please enter database mode.
1- PG
->2- ORACLE
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 1
===============================================================================
Case Sensitivity
----------------
Please enter the case sensitivity.
->1- YES
2- NO
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 1
===============================================================================
Block Size
----------
Please enter block size used in storing data.
->1- 8k
2- 16k
3- 32k
ENTER THE NUMBER FOR YOUR CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: 3
===============================================================================
Tips
----
The database will be initialized, which may take some time. Please be patient.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
InitDB error
------------
The files belonging to this database system will be owned by user "kingbase".
This user must also own the server process.
initdb: error: invalid locale name "zh_CN.UTF-8"
报错处理如下，或者大家可以搜搜，其实PG基本也会有这个报错。
[root@localhost ~]# locale -a | grep zh
[root@localhost ~]# yum install *zh_CN*
Updating Subscription Management repositories.
Unable to read consumer identity
This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register.
BaseOS 672 kB/s | 2.7 kB 00:00
AppStream 3.1 MB/s | 3.2 kB 00:00
Dependencies resolved.
============================================================================================================================================================================================================================================
Package Arch Version Repository Size
============================================================================================================================================================================================================================================
Installing:
langpacks-zh_CN noarch 1.0-12.el8 redhat-local 9.6 k
Installing weak dependencies:
glibc-langpack-zh x86_64 2.28-42.el8 BaseOS 2.1 M
Transaction Summary
============================================================================================================================================================================================================================================
Install 2 Packages
Total size: 2.2 M
Installed size: 15 M
Is this ok [y/N]: y
Downloading Packages:
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Installing : glibc-langpack-zh-2.28-42.el8.x86_64 1/2
Installing : langpacks-zh_CN-1.0-12.el8.noarch 2/2
Running scriptlet: langpacks-zh_CN-1.0-12.el8.noarch 2/2
Verifying : glibc-langpack-zh-2.28-42.el8.x86_64 1/2
Verifying : langpacks-zh_CN-1.0-12.el8.noarch 2/2
Installed products updated.
Installed:
langpacks-zh_CN-1.0-12.el8.noarch glibc-langpack-zh-2.28-42.el8.x86_64
Complete!
[root@localhost ~]# locale -a | grep zh
zh_CN
zh_CN.gb18030
zh_CN.gbk
zh_CN.utf8
zh_HK
zh_HK.utf8
zh_SG
zh_SG.gbk
zh_SG.utf8
zh_TW
zh_TW.euctw
zh_TW.utf8
[root@localhost ~]#
处理后接着安装
InitDB error
------------
The files belonging to this database system will be owned by user "kingbase".
This user must also own the server process.
initdb: error: invalid locale name "zh_CN.UTF-8"
PRESS <ENTER> TO ACCEPT THE FOLLOWING (Again):
===============================================================================
Tips
----
The database will be initialized, which may take some time. Please be patient.
PRESS <ENTER> TO CONTINUE:
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Please Wait
-----------
===============================================================================
Installation Complete
---------------------
Congratulations. KingbaseES V8 has been successfully installed to:
/soft/kingbase/ESV8
If you want to register KingbaseES V8 as OS service, please run
/soft/kingbase/ESV8/install/script/root.sh
PRESS <ENTER> TO EXIT THE INSTALLER:
Complete.
[kingbase@localhost ls]$ exit
logout
[root@localhost setup]# /soft/kingbase/ESV8/install/script/root.sh
Starting KingbaseES V8:
waiting for server to start.... done
server started
KingbaseES V8 started successfully
[root@localhost setup]# 简单使用
1、命令行启动数据库服务
[kingbase@localhost bin]$ pwd
/soft/kingbase/ESV8/KESRealPro/V008R006C007B0024/Server/bin
[kingbase@localhost bin]$ ./sys_ctl stop -D /soft/kingbase/ESV8/data
waiting for server to shut down.... done
server stopped
[kingbase@localhost bin]$ ./sys_ctl start -D /soft/kingbase/ESV8/data
waiting for server to start....2023-09-18 16:26:58.975 GMT [35351] WARNING: max_connections should be less than or equal than 10 (restricted by license)
2023-09-18 16:26:58.975 GMT [35351] HINT: the value of max_connect is set 10
2023-09-18 16:26:58.975 GMT [35351] WARNING: max_connections should be less than or equal than 10 (restricted by license)
2023-09-18 16:26:58.975 GMT [35351] HINT: the value of max_connect is set 10
2023-09-18 09:26:58.977 PDT [35351] LOG: sepapower extension initialized
2023-09-18 09:26:58.979 PDT [35351] LOG: starting KingbaseES V008R006C007B0024 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-28), 64-bit
2023-09-18 09:26:58.979 PDT [35351] LOG: listening on IPv4 address "0.0.0.0", port 54321
2023-09-18 09:26:58.979 PDT [35351] LOG: listening on IPv6 address "::", port 54321
2023-09-18 09:26:58.980 PDT [35351] LOG: listening on Unix socket "/tmp/.s.KINGBASE.54321"
2023-09-18 09:26:58.996 PDT [35351] LOG: redirecting log output to logging collector process
2023-09-18 09:26:58.996 PDT [35351] HINT: Future log output will appear in directory "sys_log".
done
server started
[kingbase@localhost bin]$
2、登录数据库
[kingbase@localhost bin]$ ./ksql -h 127.0.0.1 -p 54321 -U system -d kingbase
Password for user system:
ksql (V8.0)
Type "help" for help.
kingbase=#原创文章，作者：lzb，如若转载，请注明出处：https://www.wlkjzx.com/2023/09/19/kingbase%e6%95%b0%e6%8d%ae%e5%ba%93%e5%ae%89%e8%a3%85-linux%e7%8e%af%e5%a2%83/
微信扫一扫 
