一、查询Server/bin目录下二进制文件版本号[kingbasekesdb bin]$ ./sys_config|grep VERSIONVERSION KingbaseES 12.1[kingbasekesdb bin]$ ./sys_controldata --versionsys_controldata (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_controldata -Vsys_controldata (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./imp -Vimp (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./exp -Vexp (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./initdb -Vinitdb (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./kbbench -Vkbbench (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./createdb -Vcreatedb (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./createuser -Vcreateuser (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_waldump -Vsys_waldump (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_dump -Vsys_dump (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_ctl -Vsys_ctl (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_basebackup -Vsys_basebackup (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_receivewal -Vsys_receivewal (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_dumpall -Vsys_dumpall (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./kingbase -Vkingbase (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./ksql -Vksql (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$二、查看任一数据库启动日志[kingbasekesdb sys_log]$ more startup.log2026-08-12 17:58:41.345 CST [5985] LOG: sepapower扩展初始化完成2026-08-12 17:58:41.349 CST [5985] LOG: 正在启动KingbaseES V009R001C010PS0092026-08-12 17:58:41.350 CST [5985] LOG: 正在监听IPv4地址0.0.0.0端口 543242026-08-12 17:58:41.350 CST [5985] LOG: 正在监听IPv6地址::端口 543242026-08-12 17:58:41.350 CST [5985] LOG: 在Unix套接字 /tmp/.s.KINGBASE.54324上侦听2026-08-12 17:58:41.444 CST [5985] LOG: 日志输出重定向到日志收集进程2026-08-12 17:58:41.444 CST [5985] HINT: 后续的日志输出将出现在目录 /data/kingbase/Kingbase/ES/V9/gzdb/sys_log中.2026-08-12 20:53:34.123 CST [1875] LOG: sepapower扩展初始化完成2026-08-12 20:53:34.167 CST [1875] LOG: 正在启动 KingbaseES V009R001C010PS0092026-08-12 20:53:34.169 CST [1875] LOG: 正在监听IPv4地址0.0.0.0端口 543242026-08-12 20:53:34.169 CST [1875] LOG: 正在监听IPv6地址::端口 543242026-08-12 20:53:34.171 CST [1875] LOG: 在Unix套接字 /tmp/.s.KINGBASE.54324上侦听2026-08-12 20:53:36.368 CST [1875] LOG: 日志输出重定向到日志收集进程2026-08-12 20:53:36.368 CST [1875] HINT: 后续的日志输出将出现在目录 /data/kingbase/Kingbase/ES/V9/gzdb/sys_log中.三、连接到数据库执行语句查询test# SELECT version();version------------------------------KingbaseES V009R001C010PS009(1 行记录)test# SHOW server_version;server_version----------------12.1(1 行记录)test# SELECT current_setting(server_version);current_setting-----------------12.1(1 行记录) 
长河君 · 2026/8/14 13:20:02 · 阅读 1.2k 查询金仓KingbaseES数据库版本的若干方法
一、查询Server/bin目录下二进制文件版本号[kingbasekesdb bin]$ ./sys_config|grep VERSIONVERSION KingbaseES 12.1[kingbasekesdb bin]$ ./sys_controldata --versionsys_controldata (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_controldata -Vsys_controldata (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./imp -Vimp (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./exp -Vexp (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./initdb -Vinitdb (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./kbbench -Vkbbench (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./createdb -Vcreatedb (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./createuser -Vcreateuser (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_waldump -Vsys_waldump (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_dump -Vsys_dump (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_ctl -Vsys_ctl (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_basebackup -Vsys_basebackup (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_receivewal -Vsys_receivewal (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./sys_dumpall -Vsys_dumpall (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./kingbase -Vkingbase (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$ ./ksql -Vksql (KingbaseES) V009R001C010PS009[kingbasekesdb bin]$二、查看任一数据库启动日志[kingbasekesdb sys_log]$ more startup.log2026-08-12 17:58:41.345 CST [5985] LOG: sepapower扩展初始化完成2026-08-12 17:58:41.349 CST [5985] LOG: 正在启动KingbaseES V009R001C010PS0092026-08-12 17:58:41.350 CST [5985] LOG: 正在监听IPv4地址0.0.0.0端口 543242026-08-12 17:58:41.350 CST [5985] LOG: 正在监听IPv6地址::端口 543242026-08-12 17:58:41.350 CST [5985] LOG: 在Unix套接字 /tmp/.s.KINGBASE.54324上侦听2026-08-12 17:58:41.444 CST [5985] LOG: 日志输出重定向到日志收集进程2026-08-12 17:58:41.444 CST [5985] HINT: 后续的日志输出将出现在目录 /data/kingbase/Kingbase/ES/V9/gzdb/sys_log中.2026-08-12 20:53:34.123 CST [1875] LOG: sepapower扩展初始化完成2026-08-12 20:53:34.167 CST [1875] LOG: 正在启动 KingbaseES V009R001C010PS0092026-08-12 20:53:34.169 CST [1875] LOG: 正在监听IPv4地址0.0.0.0端口 543242026-08-12 20:53:34.169 CST [1875] LOG: 正在监听IPv6地址::端口 543242026-08-12 20:53:34.171 CST [1875] LOG: 在Unix套接字 /tmp/.s.KINGBASE.54324上侦听2026-08-12 20:53:36.368 CST [1875] LOG: 日志输出重定向到日志收集进程2026-08-12 20:53:36.368 CST [1875] HINT: 后续的日志输出将出现在目录 /data/kingbase/Kingbase/ES/V9/gzdb/sys_log中.三、连接到数据库执行语句查询test# SELECT version();version------------------------------KingbaseES V009R001C010PS009(1 行记录)test# SHOW server_version;server_version----------------12.1(1 行记录)test# SELECT current_setting(server_version);current_setting-----------------12.1(1 行记录)