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 文件
网友评论