一、安装
centos6.4服务器IP：192.168.220.131
window7客户端IP：192.168.199.218
在centos官网http://www.postgresql.org/download/linux/redhat/，通过如下指令安装postgresql
yum install postgresql-server
service postgresql initdb
chkconfig postgresql on
貌似已经安装过了，版本是8.4，因为看到update字样。不管。
二、本地建立数据库用户和DB，测试连接
su postgres //切换到默认建立的postgres用户 psql //进入postgresql命令控制台 CREATE USER root WITH PASSWORD 'root'; CREATE DATABASE rootdb WITH OWNER = root TEMPLATE = template0 ENCODING = 'UNICODE'; q //退出postgresql命令控制台 exit //退出postgres用户到root用户 /usr/bin/psql -Uroot rootdb //测试本地环境用户登录
三、windows7客户端连接测试
1）关闭防火墙 service iptables stop
2）修改/var/lib/pgsql/data/postgresql.conf（修改内容listen_addresses = '*'）后，提示错误
FATAL: no pg_hba.conf entry for host "192.168.220.1", user "root", database "rootdb", SSL off
2.1）重启命令 service iptables restart
2.2）可能会提示失败，查看log
2.2.1）确定log文件位置，通过查看postgresql.conf文件
# This is used when logging to stderr: logging_collector = on # Enable capturing of stderr and csvlog # into log files. Required to be on for # csvlogs. # (change requires restart) # These are only used if logging_collector is on: log_directory = 'pg_log' # directory where log files are written, # can be absolute or relative to PGDATA log_filename = 'postgresql-%a.log' # log file name pattern, # can include strftime() escapes
2.2.2）查看log（tail -f /var/lib/pgsql/data/pg_log/postgresql-Sat.log ）
LOG: database system was shut down at 2014-09-06 10:09:32 CST
LOG: database system is ready to accept connections
LOG: autovacuum launcher started
3）修改/var/lib/pgsql/data/pg_hba.conf ，如下
# TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident # IPv4 local connections: host all all 127.0.0.1/32 md5 host all all 192.168.0.0/32 md5 host all all 0.0.0.0/0 md5 # IPv6 local connections: host all all ::1/128 ident
最后添加了host all all 0.0.0.0/0 md5这么一段，成功连接。