centos安装pg数据库

 

1.下载yum源
yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
2.安装libzstd
否则安装数据库报错Requires: libzstd.so.1()(64bit)
yum install -y wget
wget https://download-ib01.fedoraproject.org/pub/epel/7/x86_64/Packages/l/libzstd-1.5.5-1.el7.x86_64.rpm
yum install -y libzstd-1.5.5-1.el7.x86_64.rpm
3.安装数据库
yum install -y postgresql15-server
4.安装插件
rpm -ivh https://dl.fedoraproject.org/pub/epel/7/x86_64/Packages/e/epel-release-7-14.noarch.rpm &&
yum install -y postgis33_15.x86_64
yum install -y pgrouting_15.x86_64
yum install -y gdal34.x86_64 && yum install -y gdal34-python3.x86_64
4.修改数据盘地址
vim /usr/lib/systemd/system/postgresql-15.service
Environment=PGDATA=/data/pgsql/15/data/
#Environment=PGDATA=/var/lib/pgsql/15/data/
6.给数据库授权
mkdir -p /data/pgsql/15/data/
chown -R postgres:postgres /data/pgsql/
4.初始化
sudo /usr/pgsql-15/bin/postgresql-15-setup initdb
sudo systemctl enable postgresql-15
sudo systemctl start postgresql-15

修改配置文件

1.监听所有主机

vi /data/pgsql/15/data/postgresql.conf

将原本的#listen_addresses = 'localhost'换成

listen_addresses = '*'

2.所有主机可访问

vi /data/pgsql/15/data/pg_hba.conf

host all all 0.0.0.0/0 md5

切换用户

su - postgres

进入pg数据库

psql

创建数据库

create database test owner postgres;

创建用户

create user admin with password 'mypassword';

修改用户密码

alter user admin with password 'mypassword';

修改用户权限

grant all privileges on database "test" to admin;