Redhat6.5安裝postgresql8.4數(shù)據(jù)庫(kù)

step1 先移除原有的postgresql數(shù)據(jù)庫(kù)（如果有），否則直接跳過

rpm -qa | grep postgresql*

rpm -ev rpmName

?

step2 下載新的postgresql rpm安裝包
網(wǎng)址：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 初始化后啟動(dòng)數(shù)據(jù)庫(kù)服務(wù)

初始化數(shù)據(jù)庫(kù)，默認(rèn)路徑為/var/lib/pgsql/data

# service postgresql initdb

啟動(dòng)服務(wù)

# service postgresql start ?

?

step4 創(chuàng)建數(shù)據(jù)庫(kù)

重建一個(gè)新os用戶:

useradd postgresql

passwd postgresql

創(chuàng)建數(shù)據(jù)庫(kù)

createdb proj2

對(duì)于錯(cuò)誤

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

對(duì)于錯(cuò)誤：

createdb: could not connect to database postgres: FATAL: ?role "postgresql" does not exist

解決辦法：

加參數(shù)-U指定具體的role

#postgres應(yīng)該是postgresql中的默認(rèn)的role

createdb proj2?-U postgres

連接到數(shù)據(jù)庫(kù)

psql proj2 -U postgres

?

http://jingyan.baidu.com/article/3ea51489ec3cb452e71bba52.html

?

redhat6.5安裝postgresql8.4數(shù)據(jù)庫(kù)