CentOS 安装部署 PostgreSQL 12

配置安装源

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

安装

# yum install postgresql12 postgresql12-server

初始化

# /usr/pgsql-12/bin/postgresql-12-setup initdb

修改文件 /var/lib/pgsql/12/data/postgresql.conf

# 监听地址
listen_addresses = '*'
# 日志时区
log_timezone = 'Asia/Shanghai'
# 时区
timezone = 'Asia/Shanghai'

修改文件 /var/lib/pgsql/12/data/pg_hba.conf 在最后加上如下内容

# 启用密码登录
host    all             all             0.0.0.0/0               md5

启动自启

# systemctl start postgresql-12
# systemctl enable postgresql-12

设置密码

[root@smartagriculture ~]# su - postgres
-bash-4.2$ psql -c "alter user postgres with password 'password'"
ALTER ROLE
-bash-4.2$ exit
[root@smartagriculture ~]#