centos7安装postgresql

字数统计: 81 | 阅读时长≈ 1 分钟

安装启动postgresql

1
2
3

yum install postgresql-server
service postgresql initdb
service postgresql start

1
2
3

su - postgres
psql
$ ALTER USER postgres WITH PASSWORD 'postgres';

修改**/var/lib/pgsql/data/postgresql.conf**

1	listen_addresses = '*'

修改客户端认证配置文件**/var/lib/pgsql/data/pg_hba.conf**,添加

1	host all all 10.0.0.0/8 md5

1	service postgresql restart