centos7 PostgreSQL9.6 在线安装

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34

1.添加用户和组 groupadd postgres useradd postgres -g postgres   2.添加RPM yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm   3.安装PostgreSQL 9.6 yum install postgresql96-server postgresql96-contrib postgresql96-devel   4.初始化数据库 /usr/pgsql-9.6/bin/postgresql96-setup initdb 默认Postgresql数据库安装路径是 /usr/pgsql-9.6/ 默认Postgresql数据库系统配置路径是 /var/lib/pgsql/9.6/data   vi /var/lib/pgsql/9.6/data/postgresql.conf listen_address = '*'     vim /var/lib/pgsql/9.6/data/pg_hba.conf # "local" is for Unix domain socket connections only local   all             all                                     trust # IPv4 local connections: #host    all             all             127.0.0.1/32            trust host    all             all             0.0.0.0/0                trust # IPv6 local connections: #host    all             all             ::1/128                 trust host    all             all             0.0.0.0/0                 trust # Allow replication connections from localhost, by a user with the # replication privilege. #local   replication     postgres                                trust #host    replication     postgres        127.0.0.1/32            trust #host    replication     postgres        ::1/128                 trust host     all                all        0.0.0.0/0                trust     5.开启服务 service postgresql-9.6 start systemctl start postgresql-9.6.service 6.修改密码 ALTER USER postgres WITH PASSWORD '密码';   --sql语句必须以分号结束;修改密码必须在psql中操作   7.开启远程访问 vi /var/lib/pgsql/9.6/data/postgresql.conf   修改#listen_addresses = 'localhost'  为  listen_addresses='*'     8.信任远程连接 vi /var/lib/pgsql/9.6/data/pg_hba.conf   修改如下内容，信任指定服务器连接 # IPv4 local connections: host    all            all      127.0.0.1/32      md5 host    all            all      （需要连接的服务器IP）  md5   systemctl stop firewalld systemctl dosable firewalld