linux下刪除內建的postgresql 及全新安裝

root帳戶登入：su  root

刪除： rpm -qa | grep postgresql | xargs rpm -e --nodeps

查詢： rpm -qa | grep postgresql

windows用戶端： pgAdmin III 或 PhpPgAdmin

http://www.postgresql.org/download/

# useradd postgre （自動建立 postgre 組）

# tar xvfz postgresql-7.1.3.tar.gz
# cd postgresql-7.1.3
# ./configure --prefix=/usr/local/pgsql
# make
# make install
# chown -R postgre.postgre /usr/local/pgsql

# vi ~postgre/.bash_profile
添加：

PGLIB=/usr/local/pgsql/lib
PGDATA=$HOME/data
PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
export PGLIB PGDATA PATH MANPATH

# su - postgre

在postgre目錄下建data檔案夾.  ( /home/postgre/data )

$ mkdir data

$ initdb (-E -EUC_JP)

修改： /home/postgre/data 下

1.postgresql.conf

tcpip_socket = true

2.pg_hba.conf

# TYPE  DATABASE    USER        IP-ADDRESS        IP-MASK           METHOD

local   all         all                                             trust
# IPv4-style local connections:
host    all         all         192.168.1.220         255.255.255.0   trust
host    all         all         192.168.1.219         255.255.255.0   trust
host    all         all         192.168.1.221         255.255.255.0   trust
host    all         all         192.168.1.54           255.255.255.0   trust
# IPv6-style local connections:
host    all         all         ::1               ffff:ffff:ffff:ffff:ffff:ffff:ffff:ffff        trust

/usr/local/pgsql/bin/postmaster -D /home/postgre/data　

或　/usr/local/pgsql/bin/pg_ctl -D /home/postgre/data start

$ postmaster -i -D ~/data &