postgresql安装

安装postgresql

Linux下载安装地址
https://www.postgresql.org/download/linux/redhat/

指定对应版本，指定完成后会生成对应的安装语句

下载对应的包

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

安装postgresql

yum install -y postgresql15-serve

如遇到报错

则需要安装插件

wget https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/libzstd-1.5.5-1.el7.x86_64.rpmwget https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/llvm5.0-devel-5.0.1-7.el7.x86_64.rpmwget https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/llvm5.0-5.0.1-7.el7.x86_64.rpmwget https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/l/llvm5.0-libs-5.0.1-7.el7.x86_64.rpmyum install -y ./libzstd-1.5.5-1.el7.x86_64.rpm
yum install -y centos-release-scl-rh llvm5*

初始化数据库

/usr/pgsql-15/bin/postgresql-15-setup initdb
启动postgresql
systemctl enable postgresql-15
systemctl start postgresql-15

postgresql默认端口号为5432
netstat –tunlp或者ss –antl 查看是否有5432端口号

切换到postgres用户
su postgres切换sql模式
psql修改密码
alter user postgres with password  ‘123456’;退出sql
\q

修改监听地址为任意监听地址，修改postgresql.conf文件

vim /var/lib/pgsql/15/data/postgresql.conf打开注释修改listen_addresses 字段修改为 listen_addresses = ‘*’

允许所有ip访问，修改pg_hba.conf文件

vim /var/lib/pgsql/15/data/pg_hba.conf
host 		all		all		0.0.0.0/0			scram-sha-256

重启服务

systemctl restart postgresql-15