yum安装postgresql

1、Install the repository RPM：

     yum install https://download.postgresql.org/pub/repos/yum/9.5/redhat/rhel-7-x86_64/pgdg-centos95-9.5-2.noarch.rpm

2、Install the client packages：

     yum install postgresql95

3、Optionally install the server packages：

     yum install postgresql95-server

4、Optionally initialize the database and enable automatic start：

    /usr/pgsql-9.5/bin/postgresql95-setup initdb
  systemctl enable postgresql-9.5
  systemctl start postgresql-9.5

5、Test：

 su - postgres

  $ psql

  $ \l

  CREATE DATABASE myDb;

  CREATE USER mytest CREATEDB LOGIN PASSWORD 'mytest';

  GRANT ALL ON DATABASE myDb TO mytest;

  ALTER USER MYTEST SUPERUSER CREATEROLE CREATEDB REPLICATION;

6、Q & A

1)  No pg_hba.conf entry ?

 su - postgres

 -bash-4.1$ vim pg_hba.conf

     host all all 0.0.0.0/0 md5