win10上安装PostgreSQL的 vector扩展

win10上安装PostgreSQL的 vector扩展

错误: extension "vector" is not available\nDETAIL: Could not open extension control file "D:/Program Files/PostgreSQL/16/share/extension/vector.control": No such file or directory.\nHINT: The extension must first be installed on the system where PostgreSQL is running.\n'

 

1 下载文件 vector-0.5.1，可以git复制（https://github.com/pgvector/pgvector.git）或者去官网下载（https://pgxn.org/dist/vector/0.5.1/）

2 保存到本地路径：D:\Downloads\vector-0.5.1

3 打开cmd，一次输入以下命令：

call "D:\Program Files\Microsoft Visual Studio\2022\Enterprise\VC\Auxiliary\Build\vcvars64.bat"
cd D:\Downloads\vector-0.5.1
set "PGROOT=D:\Program Files\PostgreSQL\16"
nmake /F Makefile.win
nmake /F Makefile.win install

 

参考：https://blog.csdn.net/qq_57963867/article/details/131720092
https://github.com/pgvector/pgvector