目次
本家のリポジトリを追加する。
# su - rpmdevel $ cd /home/rpmdevel/src $ wget http://yum.postgresql.org/9.2/redhat/rhel-6-i386/pgdg-centos92-9.2-6.noarch.rpm # sudo rpm -ivh /home/rpmdevel/src/pgdg-centos92-9.2-6.noarch.rpm 警告: /home/rpmdevel/pgdg-centos92-9.2-6.noarch.rpm: ヘッダ V4 DSA/SHA1 Signature, key ID 442df0f8: NOKEY 準備中... ########################################### [100%] 1:pgdg-centos92 ########################################### [100%]
確認
# yum list | grep postgresql bacula-director-postgresql.i686 5.0.0-12.el6 base bacula-storage-postgresql.i686 5.0.0-12.el6 base freeradius-postgresql.i686 2.1.12-4.el6_3 base postgresql.i686 8.4.13-1.el6_3 base postgresql-contrib.i686 8.4.13-1.el6_3 base postgresql-devel.i686 8.4.13-1.el6_3 base postgresql-docs.i686 8.4.13-1.el6_3 base postgresql-jdbc.noarch 8.4.701-8.el6 base postgresql-libs.i686 8.4.13-1.el6_3 base postgresql-odbc.i686 08.04.0200-1.el6 base postgresql-plperl.i686 8.4.13-1.el6_3 base postgresql-plpython.i686 8.4.13-1.el6_3 base postgresql-pltcl.i686 8.4.13-1.el6_3 base postgresql-server.i686 8.4.13-1.el6_3 base postgresql-test.i686 8.4.13-1.el6_3 base postgresql92.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-contrib.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-debuginfo.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-devel.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-docs.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-jdbc.i686 9.2.1002-1PGDG.rhel6 pgdg92 postgresql92-jdbc-debuginfo.i686 9.2.1002-1PGDG.rhel6 pgdg92 postgresql92-libs.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-odbc.i686 09.01.0200-1PGDG.rhel6 pgdg92 postgresql92-odbc-debuginfo.i686 09.01.0200-1PGDG.rhel6 pgdg92 postgresql92-plperl.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-plpython.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-pltcl.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-server.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql92-tcl.i686 2.0.0-1.rhel6 pgdg92 postgresql92-tcl-debuginfo.i686 2.0.0-1.rhel6 pgdg92 postgresql92-test.i686 9.2.4-1PGDG.rhel6 pgdg92 postgresql_autodoc.noarch 1.41-1.rhel6 pgdg92 qt-postgresql.i686 1:4.6.2-26.el6_4 updates
# yum install postgresql92-server postgresql92-devel
postgres ユーザー
# id postgres uid=26(postgres) gid=26(postgres) 所属グループ=26(postgres)
バージョン
# psql --version psql (PostgreSQL) 9.2.4
chkconfig
# chkconfig --list | grep postgresql postgresql-9.2 0:off 1:off 2:off 3:off 4:off 5:off 6:off
# su - postgres $ vi .bash_profile [ -f /etc/profile ] && source /etc/profile PGDATA=/var/lib/pgsql/9.2/data export PGDATA ↓ [ -f /etc/profile ] && source /etc/profile PGHOME=/usr/pgsql-9.2 PGDATA=/var/lib/pgsql/9.2/data PATH=$PATH:$PGHOME/bin export PGHOME PGDATA PGLIB
# /etc/rc.d/init.d/postgresql-9.2 start /var/lib/pgsql/9.2/data is missing. Use "service postgresql-9.2 initdb" to initialize the cluster first. [失敗]
失敗するので指示の通り、
# service postgresql-9.2 initdb --encoding=EUC_JP --no-locale データベースを初期化中: [ OK ]
再度、
# /etc/rc.d/init.d/postgresql-9.2 start postgresql-9.2 サービスを開始中: [ OK ]
自動起動
# chkconfig postgresql-9.2 on