os: centos 7.9.2009
pg: 14.7

pg_jieba 依賴 cppjieba、limonp

pg_jieba 下載

su - postgreswget https://github.com/jaiminpan/pg_jieba/archive/refs/tags/vmaster.tar.gzunzip ./pg_jieba-master
cd ~/pg_jieba-master

cppjieba、limonp 下載

su - postgrescd ~/pg_jieba-mastermkdir -p ~/pg_jieba-master/libjieba
mkdir -p ~/pg_jieba-master/libjieba/deps/limonp

unzip ~/cppjieba-master.zip -d ~/pg_jieba-master/libjieba
mv ~/pg_jieba-master/libjieba/cppjieba-master/*  ~/pg_jieba-master/libjieba/unzip ~/limonp-master.zip   -d ~/pg_jieba-master/libjieba/deps/limonp
mv ~/pg_jieba-master/libjieba/deps/limonp/limonp-master/*  ~/pg_jieba-master/libjieba/deps/limonp/

pg_jieba 編譯

cd ~/pg_jieba-master/vi CMakeLists.txt 
set(CMAKE_C_STANDARD 99)mkdir build && cd buildcmake3 -DCMAKE_PREFIX_PATH=/usr/pgsql-14 ..make USE_PGXS=1 PG_CONFIG=/usr/pgsql-14/bin/pg_configmake install USE_PGXS=1 PG_CONFIG=/usr/pgsql-14/bin/pg_config

pg_jieba 使用

vi postgresql.conf
shared_preload_libraries = 'pg_jieba'

pg_ctl stop  -D ./
pg_ctl start -D ./

postgres=# CREATE EXTENSION pg_jieba;
CREATE EXTENSIONpostgres=# SELECT * FROM to_tsvector('jiebacfg', '小麗是個潛水王，也是數據庫方面的專家');to_tsvector
---------------------------------------------------------'專家':12 '小麗':1 '數據庫':9 '方面':10 '潛水':4 '王':5
(1 行記錄)

參考：
https://www.modb.pro/db/616771
https://gitee.com/shawnyan