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

?

redhat6.5安裝postgresql8.4數據庫