Centos7安装配置postgresql12数据库

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

yum install postgresql12-contrib.x86_64 postgresql12-server.x86_64 -y

[[email protected] ~]# /usr/pgsql-12/bin/postgresql-12-setup initdb
Initializing database ... OK

systemctl start postgresql-12
systemctl enable postgresql-12.service

[[email protected] ~]# su - postgres 
-bash-4.2$ psql
psql (12.1)
Type "help" for help.

postgres=# alter user postgres with password '1q2w3e4r';
ALTER ROLE

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

vim /var/lib/pgsql/12/data/postgresql.conf

systemctl restart postgresql-12.service

[[email protected] ~]# psql -U postgres    //*-U 指定登录用户 -h 指定登录主机 -d 指定数据库
Password for user postgres:            //*询问密码验证
psql (12.1)
Type "help" for help.

postgres=# \q                          //*成功登录到数据库
[[email protected] ~]#

postgres=# create database stark;                      //*创建stark测试数据库
CREATE DATABASE
postgres=# create user stark with password 'abc-123';  //*创建stark用户,密码设置为'abc-123'
CREATE ROLE
postgres=# grant all on database stark to stark;       //*授权stark用户对数据库的操作
GRANT