Linux下postgresql9.6安装

系统和软件

CentOS 7.0
postgresql9.6

下载安装

yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-7-x86_64/pgdg-centos96-9.6-3.noarch.rpm 
yum install postgresql96 
yum install postgresql96-server

配置

• 修改监听地址

  vi /var/lib/pgsql/9.6/data/postgresql.conf

  将#listen_address = 'localhost'的注释去掉改为listen_addresses = '*'

• 修改可访问用户的IP段

  vi /var/lib/pgsql/9.6/data/pg_hba.conf

• 将host段内容改为

  host        all all  0.0.0.0/0  trust

启动

systemctl restart postgresql-9.6
systemctl enable postgresql-9.6

连接测试

• Linux shell下切换用户为postgres

  su - postgres

• 连接登陆

  psql -h 172.17.84.204 -U postgres -W

• 执行命令

  select * from pg_roles;

• 生成用户

  create user testuser with password 'test123';

• 生成DB

  create database tdb owner testuser;