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.配置遠(yuǎn)程訪問
修改/var/lib/pgsql/9.6/data/pg_hba.conf 文件