yum安装postgresql

1. yum安装
   yum install postgresql
   yum install postgresql-server

2. 新增用户,修改密码,创建数据库
   su - postgres
   psql
   #pg数据库用户
   create user postgres2 with password ‘123456’;
   create database postgres2 owner postgres2;
   grant all privileges on database postgres2 to postgres2;

ALTER USER postgres WITH PASSWORD ‘123456’;
alter role postgres2 login

3. 远程限制放开
   vi /var/lib/pgsql/data/postgresql.conf
   listen_addresses=‘*’

vi /var/lib/pgsql/data/pg_hba.conf
#增加一行
host all all 0.0.0.0/0 md5

4. 重启
   pg_ctl stop
   pg_ctl start

5. 登录
   psql -h 127.0.0.1 -U postgres2

6. 参考
   [1]https://www.w3cschool.cn/postgresql13_1/postgresql13_1-lxny3jfa.html
   [2]https://www.jianshu.com/p/140cb8c6a2c6