在 OpenCloudOS 上编译安装 OpenTenBase 5.0 数据库

[shawnyan@oc8 ~]$ hostnamectl
   Static hostname: oc8.shawnyan.cn
  Operating System: OpenCloudOS 8.10
            Kernel: Linux 5.4.241-30.0017.19
      Architecture: x86-64
[shawnyan@oc8 ~]$

[root@oc8 ~]# git clone https://github.com/facebook/zstd.git --depth=1
Cloning into 'zstd'...
remote: Enumerating objects: 64644, done.
remote: Counting objects: 100% (143/143), done.
remote: Compressing objects: 100% (77/77), done.
remote: Total 64644 (delta 91), reused 72 (delta 66), pack-reused 64501 (from 4)
Receiving objects: 100% (64644/64644), 39.45 MiB | 2.84 MiB/s, done.
Resolving deltas: 100% (48338/48338), done.
[root@oc8 ~]# cd zstd
[root@oc8 zstd]# make -j$(nproc)
make[1]: Entering directory '/root/zstd/lib'
make[1]: Entering directory '/root/zstd/programs'
creating pkgconfig
...
zstd build completed
compiling multi-threaded dynamic library 1.5.8
creating versioned links
release build completed
make[1]: Leaving directory '/root/zstd/lib'
[root@oc8 zstd]# make install
make[1]: Entering directory '/root/zstd/lib'
creating pkgconfig
Installing static library
Installing shared library
Installing includes
zstd static and shared library installed
make[1]: Leaving directory '/root/zstd/lib'
make[1]: Entering directory '/root/zstd/programs'
Installing binaries
Installing man pages
zstd installation completed
make[1]: Leaving directory '/root/zstd/programs'
[root@oc8 zstd]# 
[root@oc8 ~]# git clone https://github.com/lz4/lz4.git  
Cloning into 'lz4'...
remote: Enumerating objects: 17541, done.
remote: Counting objects: 100% (878/878), done.
remote: Compressing objects: 100% (377/377), done.
remote: Total 17541 (delta 626), reused 513 (delta 501), pack-reused 16663 (from 2)
Receiving objects: 100% (17541/17541), 7.00 MiB | 2.29 MiB/s, done.
Resolving deltas: 100% (12067/12067), done.
[root@oc8 ~]# cd lz4
[root@oc8 lz4]# make -j$(nproc)  
creating pkgconfig
...
liblz4.so.1.10.0 created
LD cachedObjs/d899e3357a27def6ef4a116bc839409e/lz4
==> built with multithreading support
lz4 build completed
[root@oc8 lz4]# make install 
Installing libraries in /usr/local/lib
Installing headers in /usr/local/include
lz4 libraries installed
Installing binaries in /usr/local/bin
Installing man pages in /usr/local/share/man/man1
lz4 installation completed
[root@oc8 lz4]# 

checking for ZSTD_compress in -lzstd... no
configure: error: zstd library not found.

checking for LZ4_compress_default in -llz4... no
configure: error: lz4 library not found.

dnf install libxml2-devel libcurl-devel 

checking for xmlSaveToBuffer in -lxml2... no
configure: error: library 'xml2' (version >= 2.6.23) is required for XML support

dnf install cmake libxslt-devel openldap-devel perl-IPC-Run perl-Test-Simple python36-devel tcl-devel

dnf install -y epel-release
dnf install -y libssh2-devel

dnf install postgresql-devel

wget https://github.com/jtv/libpqxx/archive/refs/tags/6.4.8.zip
unzip 6.4.8.zip && cd 6.4.8
mkdir build && cd build
cmake .. -DCMAKE_INSTALL_PREFIX=/usr/local
make -j$(nproc)
make install

src/node/node.h:4:10: fatal error: pqxx/pqxx: No such file or directory

[root@oc8 libpqxx-master]# gcc -dM -E - < /dev/null | grep __STDC_VERSION__ | awk '{ print $2 " --> " $3 }'
__STDC_VERSION__ --> 201710L

export SOURCECODE_PATH=/data/opentenbase/OpenTenBase
export INSTALL_PATH=/data/opentenbase/install/

cd ${SOURCECODE_PATH}

./configure --prefix=${INSTALL_PATH}/opentenbase_bin_v5.0 --enable-user-switch --with-libxml --disable-license --with-openssl --with-ossp-uuid CFLAGS="-g"

make
make install

cd contrib
make
make install

vi ~/.bashrc

export OPENTENBASE_HOME=/data/opentenbase/install/opentenbase_bin_v5.0
export PGDATA=/data/opentenbase/data
export PATH=$OPENTENBASE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$OPENTENBASE_HOME/lib:${LD_LIBRARY_PATH}
export LC_ALL=C

source ~/.bashrc

postgres -V
initdb -V

[opentenbase@oc8 ~]$ pg_ctl -V
pg_ctl (PostgreSQL) 10.0 @ OpenTenBase_v5.0 OpenTenBase V5.21 2025-09-25 19:49:18
[opentenbase@oc8 ~]$ 

initdb --nodename=dn1 --nodetype=datanode

# 集中式开关
is_centralized_mode = on
# DN 可写
allow_dml_on_datanode = on

pg_ctl -Z datanode start

postgres=# create node dn1 with(TYPE='datanode',HOST='127.0.0.1',PORT=5432,PRIMARY='TRUE',PREFERRED='TRUE');
CREATE NODE
postgres=# create default node group default_group with (dn1);
CREATE NODE GROUP
postgres=#

postgres=# CREATE EXTENSION plpgsql;
CREATE EXTENSION
postgres=# CREATE EXTENSION opentenbase_ai CASCADE;
NOTICE:  (00000) installing required extension "http"
CREATE EXTENSION
postgres=#
postgres=# \dx
                                            List of installed extensions
      Name      | Version |   Schema   |                                Description
----------------+---------+------------+----------------------------------------------------------------------------
 http           | 1.7     | public     | HTTP client for PostgreSQL, allows web page retrieval inside the database.
 opentenbase_ai | 1.0     | public     |
 plpgsql        | 1.0     | pg_catalog | PL/pgSQL procedural language
(3 rows)

postgres=#

SELECT ai.add_completion_model(
   model_name => 'hunyuan_chat',
   uri => 'https://api.hunyuan.cloud.tencent.com/v1/chat/completions',
   default_args => '{"model": "hunyuan-lite"}'::jsonb,
   token => 'your_hunyuan_api_key',
   model_provider => 'tencent'
);

SET ai.completion_model = 'hunyuan_chat';