Installing PostgreSQL on Fedora Core4

作者: Ahan 日期: 2005-09-25 19:19

字體大小: 小中大

Postgresql安裝

# useradd postgres
# tar zxvf postgresql-xxxx.tar.gz
# chown -R postgres.postgres postgresql-xxxx
# cd postgresql-xxxx
#./configure --prefix=/usr/local/pgsql --enable-multibyte=MULE_INTERNAL
# make
# make install

檔案：/etc/profile

PATH=$PATH:/usr/local/pgsql/bin
MANPATH=$MANPATH:/usr/local/pgsql/man
export PATH MANPATH
LD_LIBRARY_PATH=/usr/local/pgsql/lib
export LD_LIBRARY_PATH

檔案：/home/postgres/.bash_profile

PGLIB="/usr/local/pgsql/lib"
PGDATA="/usr/local/pgsql/data"
PGBIN="/usr/local/pgsql/bin"
PGLOG="/usr/local/pgsql/log"
PGCLIENTENCODING='BIG5'
export PGLIB PGDATA PGBIN PGLOG PGCLIENTENCODING

# chown -R postgres.postgres /usr/local/pgsql
# su - postgres
# initdb -E MULE_INTERNAL
# postmaster -i -S
# createuser sa(當pgsql系統問你sa是否可以建立db及user都選yes)
# createdb -E EUC_TW test
# psql test
test=# set client_encoding to 'big5';
test=# alter user sa with password '你想要的密碼';
test=# q

在Linux OS環境下用 root 來useradd sa
並且passwd sa(密碼我是設定跟在pgsql內的sa的密碼一樣)

檔案：/home/sa/.bash_profile

PGLIB="/usr/local/pgsql/lib"
PGDATA="/usr/local/pgsql/data"
PGBIN="/usr/local/pgsql/bin"
PGLOG="/usr/local/pgsql/log"
PGCLIENTENCODING='BIG5'
export PGLIB PGDATA PGBIN PGLOG PGCLIENTENCODING

檔案：/etc/rc.d/rc.local

#start pgsql when OS reboot （這行是註解，底下才是內容）
POSTGRESDIR=/usr/local/pgsql
if [ -x $POSTGRESDIR/bin/postmaster -a -d $POSTGRESDIR/data ];then
rm -f /tmp/s.PGSQL.5432
su - postgres -c "postmaster -i -S"
echo -n 'postmaster'
fi

From：JavaNull 無國界 http://blog.yam.com/javanull