1.安装pgsql

    yum install https://download.postgresql.org/pub/repos/yum/9.6/redhat/rhel-6-x86_64/pgdg-redhat96-9.6-3.noarch.rpm

    yum install postgresql96

    yum install postgresql96-server postgresql96-contrib

    service postgresql-9.6 initdb

    chkconfig postgresql-9.6 on

    service postgresql-9.6 start

2.以posgres用户登录pgsql

    sudo -u postgres psql

3.修改密码

    ALTER USE Rpostgres WITH PASSWORD 'password';

4.配置远程访问

修改/var/lib/pgsql/9.6/data/pg_hba.conf 文件