# 【安装PostgreSQL 12】
## 安装yum源
sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
## 查看
rpm -qi pgdg-redhat-repo
## 安装pg客户端及服务端
sudo yum -y install epel-release yum-utils
sudo yum-config-manager --enable pgdg12
sudo yum install postgresql12-server postgresql12
## 初始化数据库
sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
### 数据库的主配置文件写入到这个文件
`/var/lib/pgsql/12/data/postgresql.conf`
## 启动数据库服务端
sudo systemctl enable --now postgresql-12
## 查看启动状态
systemctl status postgresql-12
### 如果有防火墙，放行pg
sudo firewall-cmd --add-service=postgresql --permanent
sudo firewall-cmd --reload
## 安装过程中会自动创建postgres用户，设置该登录用户密码
sudo su - postgres
psql -c "alter user postgres with password 'postgres'"
## 开启远程访问
vim /var/lib/pgsql/12/data/postgresql.conf
--------------------------------------------
listen_addresses = '192.168.241.100'
--------------------------------------------
sudo vim /var/lib/pgsql/12/data/pg_hba.conf
--------------------------------------------
# Accept from anywhere
host all all 0.0.0.0/0 md5
# Accept from trusted subnet
host all all 192.168.18.0/24 md5
--------------------------------------------
## 修改配置后重启
sudo systemctl restart postgresql-12
## 登录数据库
psql -U postgres -h 192.168.241.100 -p 5432
### 输入密码postgres
# 【安装pgAdmin】
## 同样安装源(安装pg的时候应该安装过)
sudo yum -y install epel-release
sudo yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
## 安装pgadmin4
sudo yum -y update
sudo yum -y install pgadmin4
### 启动&开机自启动
sudo systemctl start httpd && sudo systemctl enable httpd
sudo systemctl status httpd