install PostgreSQL 9.1 on CentOS 5

2012-09-07
book: PostgreSQL 徹底入門 p.26
にしたがって，install

OS: CentOS5.8

(1) Yum の設定
see
http://yum.postgresql.org/howtoyum.php/
http://yum.postgresql.org/repopackages.php

# wget pgdg-centos91-9.1-4.noarch.rpm
# rpm -ivh pgdg-centos91-9.1-4.noarch.rpm

PostgreSQL-RPM-Installation-PGDG.pdf
"Installing PostgreSQL on Red Hat Enterprise Linux / Fedora Core"
Last Update: Mon Sep 03, 2007

# cd /etc/yum.repos.d
< exclude=postgresql*
28d26
< exclude=postgresql*

# yum -y install 'postgresql91*'

bash-3.2$ cat .bash_profile
[ -f /etc/profile ] && source /etc/profile
PGDATA=/var/lib/pgsql/9.1/data
export PGDATA

PATH=/usr/pgsql-9.1/bin/:$PATH
MANPATH=/usr/pgsql-9.1/share/man/:$MANPATH

----------------------------
ls /usr/share/doc/postgresql91-docs-9.1.5/
html  Makefile  postgresql-9.1-A4.pdf  sgml  tutorial

----------------------------
* DBクラスタの作成
bash-3.2$ initdb -E UTF8 --no-locale
----------------------------         
* DB serverの起動
bash-3.2$ pg_ctl -l logfile start
server starting
----------------------------   
* DBの操作のテスト
bash-3.2$ createdb mydb
bash-3.2$ psql -l

(see 201209-install.txt )