postgres のインストール

yum でインストールするのは初めてなのでメモ。
NuOnce BlueQuartz:yumのPostgreSQL留意点|ADSL + 自宅 Linux サーバを参考にインストール。


# yum install postgres

# yum install postgres-server

# yum install postgres-devel
ここまでは問題ない。

# yum install php-pgsql
Loaded plugins: fastestmirror, priorities
Loading mirror speeds from cached hostfile
* addons: rsync.atworks.co.jp
* base: rsync.atworks.co.jp
* extras: rsync.atworks.co.jp
* updates: rsync.atworks.co.jp
Setting up Install Process
Resolving Dependencies

    • > Running transaction check
      • > Package php-pgsql.i386 0:5.1.6-27.el5_5.3 set to be updated
    • > Processing Dependency: php-common = 5.1.6-27.el5_5.3 for package: php-pgsql
    • > Running transaction check
    • > Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-mbstring
    • > Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-pdo
    • > Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-mysql
    • > Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php
    • > Processing Dependency: php-common = 5.1.6-24.el5_4.5 for package: php-cli
      • > Package php-common.i386 0:5.1.6-27.el5_5.3 set to be updated
    • > Running transaction check
    • > Processing Dependency: php = 5.1.6-24.el5_4.5 for package: php-devel
      • > Package php.i386 0:5.1.6-27.el5_5.3 set to be updated
      • > Package php-cli.i386 0:5.1.6-27.el5_5.3 set to be updated
      • > Package php-mbstring.i386 0:5.1.6-27.el5_5.3 set to be updated
      • > Package php-mysql.i386 0:5.1.6-27.el5_5.3 set to be updated
      • > Package php-pdo.i386 0:5.1.6-27.el5_5.3 set to be updated
    • > Running transaction check
      • > Package php-devel.i386 0:5.1.6-27.el5_5.3 set to be updated
    • > Finished Dependency Resolution

Dependencies Resolved

==========================================================================================
Package Arch Version Repository Size
==========================================================================================
Installing:
php-pgsql i386 5.1.6-27.el5_5.3 updates 68 k
Updating for dependencies:
php i386 5.1.6-27.el5_5.3 updates 2.3 M
php-cli i386 5.1.6-27.el5_5.3 updates 2.1 M
php-common i386 5.1.6-27.el5_5.3 updates 153 k
php-devel i386 5.1.6-27.el5_5.3 updates 503 k
php-mbstring i386 5.1.6-27.el5_5.3 updates 995 k
php-mysql i386 5.1.6-27.el5_5.3 updates 86 k
php-pdo i386 5.1.6-27.el5_5.3 updates 65 k

Transaction Summary
==========================================================================================
Install 1 Package(s)
Update 7 Package(s)
Remove 0 Package(s)

Total download size: 6.2 M
Is this ok [y/N]: y
Downloading Packages:
(1/8): php-pdo-5.1.6-27.el5_5.3.i386.rpm | 65 kB 00:00
(2/8): php-pgsql-5.1.6-27.el5_5.3.i386.rpm | 68 kB 00:00
(3/8): php-mysql-5.1.6-27.el5_5.3.i386.rpm | 86 kB 00:00
(4/8): php-common-5.1.6-27.el5_5.3.i386.rpm | 153 kB 00:00
(5/8): php-devel-5.1.6-27.el5_5.3.i386.rpm | 503 kB 00:00
(6/8): php-mbstring-5.1.6-27.el5_5.3.i386.rpm | 995 kB 00:00
(7/8): php-cli-5.1.6-27.el5_5.3.i386.rpm | 2.1 MB 00:00
(8/8): php-5.1.6-27.el5_5.3.i386.rpm | 2.3 MB 00:00

                                                                                                                                                                                  • -

Total 2.0 MB/s | 6.2 MB 00:03
Running rpm_check_debug
Running Transaction Test
Finished Transaction Test
Transaction Test Succeeded
Running Transaction
Updating : php-common 1/15
warning: /etc/php.ini created as /etc/php.ini.rpmnew
Updating : php-pdo 2/15
Updating : php-cli 3/15
Updating : php 4/15
Updating : php-devel 5/15
Installing : php-pgsql 6/15
Updating : php-mbstring 7/15
Updating : php-mysql 8/15
Cleanup : php-devel 9/15
Cleanup : php-cli 10/15
Cleanup : php-pdo 11/15
Cleanup : php-mbstring 12/15
Cleanup : php-common 13/15
Cleanup : php-mysql 14/15
Cleanup : php 15/15

Installed:
php-pgsql.i386 0:5.1.6-27.el5_5.3

Dependency Updated:
php.i386 0:5.1.6-27.el5_5.3 php-cli.i386 0:5.1.6-27.el5_5.3
php-common.i386 0:5.1.6-27.el5_5.3 php-devel.i386 0:5.1.6-27.el5_5.3
php-mbstring.i386 0:5.1.6-27.el5_5.3 php-mysql.i386 0:5.1.6-27.el5_5.3
php-pdo.i386 0:5.1.6-27.el5_5.3

Complete!

これでphpが上書きされてしまったので、再インストール。
config.status を見るとたくさん入ってるようだ。

# ./configure --build=i686-redhat-linux-gnu --host=i686-redhat-linux-gnu --target=i386-redhat-linux-gnu --program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --cache-file=../config.cache --with-libdir=lib --with-config-file-path=/etc --with-config-file-scan-dir=/etc/php.d --disable-debug --with-pic --disable-rpath --without-pear --with-bz2 --with-curl --with-exec-dir=/usr/bin --with-freetype-dir=/usr --with-png-dir=/usr --enable-gd-native-ttf --without-gdbm --with-gettext --with-gmp --with-iconv --with-jpeg-dir=/usr --with-openssl --with-png --with-ps
pell --with-expat-dir=/usr --with-pcre-regex=/usr --with-zlib --with-layout=GNU --enable-exif --enable-ftp --enable-magic-quotes --enable-sockets --enable-sysvsem --enable-sysvshm--enable-sysvmsg --enable-track-vars --enable-trans-sid --enable-yp --enable-wddx --with-kerberos --enable-ucd-snmp-hack --with-unixODBC=shared,/usr --enable-memory-limit --enable-shmop --enable-calendar --enable-dbx --enable-dio --with-mime-magic=/usr/share/file/magic.mime --without-sqlite --with-libxml-dir=/usr --with-xml --with-system-tzdata --with-apxs2=/usr/sbin/apxs --without-mysql --with-gd --without-odbc --disable-dom --disable-dba --without-unixODBC --disable-pdo --disable-xmlreader --disable-xmlwriter --with-pgsql
このままインストールしても駄目だったので、ローカルでインストールした libiconv を /usr/local
として指定

# ./configure --build=i686-redhat-linux-gnu --host=i686-redhat-linux-gnu --target=i386-redhat-linux-gnu --program-prefix= --prefix=/usr --exec-prefix=/usr --bindir=/usr/bin --sbindir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --includedir=/usr/include --libdir=/usr/lib --libexecdir=/usr/libexec --localstatedir=/var --sharedstatedir=/usr/com --mandir=/usr/share/man --infodir=/usr/share/info --cache-file=../config.cache --with-libdir=lib --with-config-file-path=/etc --with-config-file-scan-dir=/etc/php.d --disable-debug --with-pic --disable-rpath --without-pear --with-bz2 --with-curl --with-exec-dir=/usr/bin --with-freetype-dir=/usr --with-png-dir=/usr --enable-gd-native-ttf --without-gdbm --with-gettext --with-gmp --with-iconv=/usr/local --with-jpeg-dir=/usr --with-openssl --with-png --with-ps
pell --with-expat-dir=/usr --with-pcre-regex=/usr --with-zlib --with-layout=GNU --enable-exif --enable-ftp --enable-magic-quotes --enable-sockets --enable-sysvsem --enable-sysvshm--enable-sysvmsg --enable-track-vars --enable-trans-sid --enable-yp --enable-wddx --with-kerberos --enable-ucd-snmp-hack --with-unixODBC=shared,/usr --enable-memory-limit --enable-shmop --enable-calendar --enable-dbx --enable-dio --with-mime-magic=/usr/share/file/magic.mime --without-sqlite --with-libxml-dir=/usr --with-xml --with-system-tzdata --with-apxs2=/usr/sbin/apxs --without-mysql --with-gd --without-odbc --disable-dom --disable-dba --without-unixODBC --disable-pdo --disable-xmlreader --disable-xmlwriter --with-pgsql
# make
# make install
うん。
うまくいったみたい。