Redhat6.5安装postgresql8.4数据库
step1 先移除原有的postgresql数据库（如果有），否则直接跳过
rpm -qa | grep postgresql*
rpm -ev rpmName
step2 下载新的postgresql rpm安装包
网址：http://mirrors.sohu.com/centos/6.6/os/x86_64/Packages/
wget http://mirrors.sohu.com/centos/6.6/os/x86_64/Packages/postgresql-libs-8.4.20-1.el6_5.x86_64.rpm
wget http://mirrors.sohu.com/centos/6.6/os/x86_64/Packages/postgresql-8.4.20-1.el6_5.x86_64.rpm
wget http://mirrors.sohu.com/centos/6.6/os/x86_64/Packages/postgresql-devel-8.4.20-1.el6_5.x86_64.rpm
wget http://mirrors.sohu.com/centos/6.6/os/x86_64/Packages/postgresql-server-8.4.20-1.el6_5.x86_64.rpm
下载完成后，按照下载顺序依次安装
rpm -ivh postgresql-libs-8.4.20-1.el6_5.x86_64.rpm
rpm -ivh postgresql-8.4.20-1.el6_5.x86_64.rpm
rpm -ivh postgresql-devel-8.4.20-1.el6_5.x86_64.rpm
rpm -ivh postgresql-server-8.4.20-1.el6_5.x86_64.rpm
step3 初始化后启动数据库服务
初始化数据库，默认路径为/var/lib/pgsql/data
# service postgresql initdb
启动服务
# service postgresql start
step4 创建数据库
重建一个新os用户:
useradd postgresql
passwd postgresql
创建数据库
createdb proj2
对于错误
createdb: could not connect to database postgres: FATAL: Ident authentication failed for user "postgresql"
解决办法：
修改/var/lib/pgsql/data/pg_hga.conf文件
修改
# "local" is for Unix domain socket connections only
local all all ident
为：
# "local" is for Unix domain socket connections only
local all postgresql trust
保存，然后
重新加载配置文件
/etc/init.d/postgresql reload
对于错误：
createdb: could not connect to database postgres: FATAL: role "postgresql" does not exist
解决办法：
加参数-U指定具体的role
#postgres应该是postgresql中的默认的role
createdb proj2 -U postgres
连接到数据库
psql proj2 -U postgres
http://jingyan.baidu.com/article/3ea51489ec3cb452e71bba52.html
