rocky9 install postgresql17

编译安装pg17

0、
sudo yum groupinstall "Development Tools"
sudo yum install readline-devel zlib-devel openssl-devel libxml2-devel libxslt-devel

1、pg.repo
[pgdg-common]
name=PostgreSQL common RPMs for $basearch
baseurl=http://mirrors.aliyun.com/postgresql/yum/reporpms/
enabled=1
gpgcheck=0

2、wget http://mirrors.zju.edu.cn/postgresql/source/v17.6/postgresql-17.6.tar.gz
tar xf postgresql-17.6.tar.gz
http://mirrors.aliyun.com/postgresql
3、cd postgresql-17.6

make world
sudo make install-world

4、git clone --branch v0.8.1 https://github.com/pgvector/pgvector.git

git clone --branch v1.12.1 https://github.com/pgvector/pgvector.git
cd pgvector
make ;make install

5、初始化数据库和创建用户
sudo mkdir -p /usr/local/pgsql/data
sudo chown postgres:postgres /var/lib/pgsql/data # 可能需要先创建 postgres 用户和组
sudo -u postgres /usr/local/pgsql/bin/initdb -D /var/lib/pgsql/data

6
postgresql17
CREATE EXTENSION vector
SELECT * FROM pg_extension;
CREATE TABLE vectab (id bigserial PRIMARY KEY, embedding vector(3));

sudo -u postgres /usr/local/pgsql/bin/pg_ctl -D /var/lib/pgsql/data -l logfile start

7
CREATE USER username WITH PASSWORD 'password';
CREATE ROLE username WITH LOGIN PASSWORD 'password';
ALTER USER username WITH PASSWORD 'newpassword';
ALTER ROLE username WITH PASSWORD 'newpassword';
\password username

postgres=# ALTER USER postgres PASSWORD 'pw';
ALTER ROLE

Passwords didn't match.
postgres=# \password postgres
Enter new password for user "postgres":
Enter it again:

相关日志