postgresql安装

1. 安装流程：

1.1 拉取源

yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/pgdg-redhat-repo-latest.noarch.rpm

1.2 禁用内置的postgresql模块

dnf -qy module disable postgresql

1.3 更新源

yum update -y

1.4 安装

yum install postgresql-server postgresql-contrib

1.5 创建数据存储目录并授权

mkdir -p /data/server/pgsql/data
chown -R postgres:postgres /data/server/pgsql/data

1.6 初始化数据

/usr/pgsql-16/bin/postgresql-16-setup initdb -D /data/server/pgsql/data

1.7 启动

systemctl start postgresql-16

1.8 设置开机启动

systemctl enable postgresql-16

1.9 修改默认密码

psql -U postgres
ALTER USER postgres WITH PASSWORD '123456'

2. 安装pgvector

2.1 安装 devel模块

wget https://download.postgresql.org/pub/repos/yum/16/redhat/rhel-8-x86_64/postgresql16-devel-16.4-1PGDG.rhel8.x86_64.rpm
 yum install postgresql16-devel-16.4-1PGDG.rhel8.x86_64.rpm

配置 pg_config命令

ln -s  /usr/pgsql-16/bin/pg_config /usr/bin/pg_config

下载 pgvector-0.7.4.tar.gz并解压，然后执行：

 make && make install