PostgreSql与Postgis安装

POstgresql安装

1.登录官网 PostgreSQL: Linux downloads (Red Hat family)

2.选择版本

3.安装

### 源
yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
### 客户端
yum install postgresql14
### 服务端
yum install -y postgresql14-server
### 初始化
/usr/pgsql-14/bin/postgresql-14-setup initdb
### 开机启动
systemctl enable postgresql-14
### 启动
systemctl start postgresql-14

4.远程访问

sudo vim /var/lib/pgsql/14/data/postgresql.conf

 

5.修改pg_hba.conf