Centos8安装Postgresql

了解了下这个新兴的开源数据库，Postgresql，性能非常强劲，官网直接就说postgresql是世界最强的开源关系型数据库（国外么有广告法啊），实测了一下，的确比mysql性能高非常多。本文为centos8
安装Postgresql的教程。

下载源并安装

dnf install https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm
dnf module list postgresql -y
dnf install -y postgresql13
dnf install postgresql13-server
dnf install postgresql13-contrib

数据库初始化

cd /usr/pgsql-13/bin
./postgresql-13-setup initdb

数据库启动并设置为开机自启

systemctl start postgresql-13.service
systemctl enable postgresql-13.service

设置用户密码并登录

passwd postgres

su postgres
bash-4.4$ psql
psql (13.5)
Type "help" for help.

postgres=# exit
bash-4.4$ exit
exit

配置远程访问

安装完成后默认只允许本地访问，所以需要添加配置。
编辑配置文件

vim /var/lib/pgsql/13/data/pg_hba.conf

在# IPv4 local connections:下添加host all all 0.0.0.0/0 trust ，
以下是添加后文件样子：

# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     peer
# IPv4 local connections:
host    all             all             127.0.0.1/32            scram-sha-256
host    all             all             0.0.0.0/0               trust 
# IPv6 local connections:
host    all             all             ::1/128                 scram-sha-256
# Allow replication connections from localhost, by a user with the
# replication privilege.
local   replication     all                                     peer
host    replication     all             127.0.0.1/32            scram-sha-256
host    replication     all             ::1/128                 scram-sha-256