安装镜像仓库

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

安装 PostgreSQL 11

yum install postgresql11 postgresql11-server -y

初始化数据库

/usr/pgsql-11/bin/postgresql-11-setup initdb

启动数据库

systemctl enable postgresql-11
systemctl start postgresql-11

开放防火墙

firewall-cmd --add-port=5432/tcp --permanent
firewall-cmd --reload

修改默认用户密码

su - postgres
psql -U postgres
alter user postgres with encrypted password 'abc123';
\q
exit

配置远程访问

vi /var/lib/pgsql/11/data/postgresql.conf
listen_address = '*'
vi /var/lib/pgsql/11/data/pg_hba.conf
host all all 0.0.0.0/0 md5
systemctl restart postgresql-11

新建用户

create user demo with password 'abc123';

新建数据库

CREATE DATABASE demo OWNER demo;

赋权

GRANT ALL PRIVILEGES ON DATABASE demo TO demo;