CentOS 7安装PostgreSQL 11
一、官网安装介绍
https://www.postgresql.org/download/linux/redhat/
二、进行安装
2.1、安装存储库
yum install https://download.postgresql.org/pub/repos/yum/11/redhat/rhel-7-x86_64/pgdg-centos11-11-2.noarch.rpm
2.2、安装客户端
yum install postgresql11
2.3、安装服务端
yum install postgresql11-server
2.4、初始化数据库
/usr/pgsql-11/bin/postgresql-11-setup initdb
2.5、启用开机自动启用
systemctl enable postgresql-11
systemctl start postgresql-11
2.6、修改用户密码
[[email protected] ~]#su - postgres //切换用户,执行后提示符会变为 '-bash-4.2$'
-bash-4.2$ psql -U postgres #//登录数据库,执行后提示符变为 'postgres=#'
psql (11.2) Type "help" for help.
postgres=# ALTER USER postgres WITH PASSWORD 'postgres' //设置postgres用户密码为postgres
postgres-# \q //退出数据库
2.7、开启远程访问
vim /var/lib/pgsql/11/data/postgresql.conf
#
listen_addresses = '*'
2.7、信任远程连接
vim /var/lib/pgsql/11/data/pg_hba.conf
#
host all all 0.0.0.0/0 md5
2.8、重启服务
systemctl restart postgresql-11
三、配置防火墙
firewall-cmd --permanent --add-port=5432/tcp
firewall-cmd --permanent --add-port=80/tcp
firewall-cmd --reload