PostgreSQL 8.2.4
cd /usr/src/redhat/SRPMS/ wget ftp://ftp.jp.postgresql.org/binary/v8.2.4/linux/srpms/redhat/rhel-es-4/postgresql-8.2.4-1PGDG.src.rpm rpmbuild --rebuild postgresql-8.2.4-1PGDG.src.rpm
エラー: Failed build dependencies: bison is needed by postgresql-8.2.4-1PGDG.i386 flex is needed by postgresql-8.2.4-1PGDG.i386 python-devel is needed by postgresql-8.2.4-1PGDG.i386 tcl-devel is needed by postgresql-8.2.4-1PGDG.i386 libxslt-devel is needed by postgresql-8.2.4-1PGDG.i386 pam-devel is needed by postgresql-8.2.4-1PGDG.i386
yum install -y bison flex python-devel tcl-devel libxslt-devel pam-devel
rpmbuild --rebuild postgresql-8.2.4-1PGDG.src.rpm
書き込み中: /usr/src/redhat/RPMS/i386/postgresql-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-libs-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-server-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-docs-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-contrib-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-devel-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-plperl-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-plpython-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-pltcl-8.2.4-1PGDG.i386.rpm 書き込み中: /usr/src/redhat/RPMS/i386/postgresql-test-8.2.4-1PGDG.i386.rpm
# 標準のPostgreSQL7を削除(libは依存関係のため残す)
yum remove postgresql
rpm -ihv postgresql-8.2.4-1PGDG.i386.rpm postgresql-libs-8.2.4-1PGDG.i386.rpm postgresql-server-8.2.4-1PGDG.i386.rpm postgresql-devel-8.2.4-1PGDG.i386.rpm su postgres initdb -E UTF8 --no-locale -D /var/lib/pgsql/data exit service postgresql start chkconfig postgresql on