2009年9月14日月曜日

PostgreSQL 8.4の起動スクリプト

PostgreSQL 8.4をUbuntu 9.04 x64で動かしていて、他のPCからTCP/IPで接続したいが、なかなかできなかった。
結局の原因はサーバーの起動時にiオプションがついていなかったという。
サーバーの起動スクリプトはPostgreSQL 8.4のソースコードに付属の(./contrib/start-scripts/linux)を使っていたが、これにiオプションがついていないからいけないのかな?ということで適当に修正してみる。
./contrib/start-srcipts/linuxをUbuntu 9.04ならば/etc/init.dにコピーしてpostgresとかに適当にリネーム。
startとrestartの部分でそれぞれサーバーを起動させている行である以下の部分を、
su - $PGUSER -c "$DAEMON -D '$PGDATA' &" >>$PGLOG 2>&1



下記のように変更した。っていうか-iを付けただけー。
su - $PGUSER -c "$DAEMON -D '$PGDATA' -i &" >>$PGLOG 2>&1


その後chkconfig --add postgresで導入。
service postgres statusや、ps aux |grep postgresなどのコマンドで動作を確認。
TCP/IPでの接続もできるようになりました。
(もちろんpostgresql.confやpg_hba.confの設定は必要)

以下サーバーの起動スクリプトの全文。

#! /bin/sh

# chkconfig: 2345 98 02
# description: PostgreSQL RDBMS

# This is an example of a start/stop script for SysV-style init, such
# as is used on Linux systems. You should edit some of the variables
# and maybe the 'echo' commands.
#
# Place this file at /etc/init.d/postgresql (or
# /etc/rc.d/init.d/postgresql) and make symlinks to
# /etc/rc.d/rc0.d/K02postgresql
# /etc/rc.d/rc1.d/K02postgresql
# /etc/rc.d/rc2.d/K02postgresql
# /etc/rc.d/rc3.d/S98postgresql
# /etc/rc.d/rc4.d/S98postgresql
# /etc/rc.d/rc5.d/S98postgresql
# Or, if you have chkconfig, simply:
# chkconfig --add postgresql
#
# Proper init scripts on Linux systems normally require setting lock
# and pid files under /var/run as well as reacting to network
# settings, so you should treat this with care.

# Original author: Ryan Kirkpatrick

# $PostgreSQL: pgsql/contrib/start-scripts/linux,v 1.8 2006/07/13 14:44:33 petere Exp $

## EDIT FROM HERE

# Installation prefix
prefix=/usr/local/pgsql

# Data directory
PGDATA="/usr/local/pgsql/data"

# Who to run the postmaster as, usually "postgres". (NOT "root")
PGUSER=postgres

# Where to keep a log file
PGLOG="$PGDATA/serverlog"

## STOP EDITING HERE

# The path that is to be used for the script
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin

# What to use to start up the postmaster (we do NOT use pg_ctl for this,
# as it adds no value and can cause the postmaster to misrecognize a stale
# lock file)
DAEMON="$prefix/bin/postmaster"

# What to use to shut down the postmaster
PGCTL="$prefix/bin/pg_ctl"

set -e

# Only start if we can find the postmaster.
test -x $DAEMON || exit 0

# Parse command line parameters.
case $1 in
start)
echo -n "Starting PostgreSQL: "
su - $PGUSER -c "$DAEMON -D '$PGDATA' -i &" >>$PGLOG 2>&1
# su - $PGUSER -c "$DAEMON -D '$PGDATA' &" >>$PGLOG 2>&1
echo "ok"
;;
stop)
echo -n "Stopping PostgreSQL: "
su - $PGUSER -c "$PGCTL stop -D '$PGDATA' -s -m fast"
echo "ok"
;;
restart)
echo -n "Restarting PostgreSQL: "
su - $PGUSER -c "$PGCTL stop -D '$PGDATA' -s -m fast -w"
su - $PGUSER -c "$DAEMON -D '$PGDATA' -i &" >>$PGLOG 2>&1
# su - $PGUSER -c "$DAEMON -D '$PGDATA' &" >>$PGLOG 2>&1
echo "ok"
;;
reload)
echo -n "Reload PostgreSQL: "
su - $PGUSER -c "$PGCTL reload -D '$PGDATA' -s"
echo "ok"
;;
status)
su - $PGUSER -c "$PGCTL status -D '$PGDATA'"
;;
*)
# Print help
echo "Usage: $0 {start|stop|restart|reload|status}" 1>&2
exit 1
;;
esac

exit 0



今回はpostmasterを利用しているので、オプションは以下のコマンドで確認した。
# /usr/local/pgsql/bin/postmaster --help

postmaster is the PostgreSQL server.

Usage:
postmaster [OPTION]...

Options:
-B NBUFFERS number of shared buffers
-c NAME=VALUE set run-time parameter
-d 1-5 debugging level
-D DATADIR database directory
-e use European date input format (DMY)
-F turn fsync off
-h HOSTNAME host name or IP address to listen on
-i enable TCP/IP connections
-k DIRECTORY Unix-domain socket location
-N MAX-CONNECT maximum number of allowed connections
-o OPTIONS pass "OPTIONS" to each server process (obsolete)
-p PORT port number to listen on
-s show statistics after each query
-S WORK-MEM set amount of memory for sorts (in kB)
--NAME=VALUE set run-time parameter
--describe-config describe configuration parameters, then exit
--help show this help, then exit
--version output version information, then exit

Developer options:
-f s|i|n|m|h forbid use of some plan types
-n do not reinitialize shared memory after abnormal exit
-O allow system table structure changes
-P disable system indexes
-t pa|pl|ex show timings after each query
-T send SIGSTOP to all backend servers if one dies
-W NUM wait NUM seconds to allow attach from a debugger

Options for single-user mode:
--single selects single-user mode (must be first argument)
DBNAME database name (defaults to user name)
-d 0-5 override debugging level
-E echo statement before execution
-j do not use newline as interactive query delimiter
-r FILENAME send stdout and stderr to given file

Options for bootstrapping mode:
--boot selects bootstrapping mode (must be first argument)
DBNAME database name (mandatory argument in bootstrapping mode)
-r FILENAME send stdout and stderr to given file
-x NUM internal use

Please read the documentation for the complete list of run-time
configuration settings and how to set them on the command line or in
the configuration file.

Report bugs to .

第28回 日本企業を見限ったインドの“システム屋”から学んだこと - ダメな“システム屋”にだまされるな:ITpro

第28回 日本企業を見限ったインドの“システム屋”から学んだこと - ダメな“システム屋”にだまされるな:ITpro: "日本人的な現場が知恵を出し合うという考え方と、欧米的な「要件を決めて、決めた通りに作る」「多少現場が苦労してもパッケージソフトのやり方に業務プロセスを合わせる」という考え方は、折り合わないところがあるのかもしれません。インド人との議論を通じて、そう考えるようになりました。"

2009年9月11日金曜日

2009年9月4日金曜日

Fedora 11のインストール。

*[ソフトウェア]Fedora 11を使う上で必要になることなど
古いFedora 11のKDEのライブからインストールしたので、いろいろと不都合があったので適当に対処。
まずは日本語関係が全然入っていないので、System settingのAdd and Remove Softwareのソフトウェアの追加あたりから、Japaneseで検索。
japanese-supportとkde-l10n-japanese -4.3.0 (KDEのバージョンに合わせる。今回は4.3)を導入。
日本語入力環境もないので、scim-lang-japaneseを導入。


Flashはhttp://get.adobe.com/jp/flashplayer/からYUM版をダウンロードして導入。
ブラウザはFirefoxをyumから、Operaは公式のサイトから導入。


ATIのドライバ
kernelとkernel-develをyumで導入。
http://get.adobe.com/jp/flashplayer/
から取得したドライバに適宜実行権限を与えて(chmod u+x [FILENAME])、実行。

適当なグラボを選んで最新を利用したらうまくいきました。
http://support.amd.com/us/gpudownload/linux/Pages/radeon_linux.aspx?type=2.4.1&product=2.4.1.3.36&lang=English


./ati-driver-installer-9-3-x86.x86_64.run --listpkg
を実行すると、
Fedora Packages:
Fedora/FC3
Fedora/FC4
Fedora/FC5
Fedora/FC6
Fedora/F7
Fedora/F8
Fedora/F9
Fedora/F10
Fedora/RHEL3
Fedora/RHEL4
という結果に。どうやらFedora/F11はまだみたい。

とりあえず生成オプションを追加して、以下のように実行してみる。
./ati-driver-installer-9-3-x86.x86_64.run --buildpkg Fedora/F10

すると次のようなエラーが
Package build failed!
Package build utility output:
./packages/Fedora/ati-packager.sh: line 266: rpmbuild: command not found

auto-buildrequires.x86_64 : Work out BuildRequires for rpmbuild automatically
rpm-build-4.7.1-1.fc11.x86_64.rpm

2009年9月3日木曜日

ゲームがおもしろい。

個人的にゲームはあまりやらない主義。
でも、昔少しだけ遊んだ懐かしいゲームがふとPSPのオンラインストアにあったりすると買ってしまうというもの。


*[アニメ]空の境界 6章
妹がメインなのでテンポや音楽に変化をつけてきた感じ。
しかし、先生の妖精話なんかがごっそり省略されてた。いいのかなぁ。
原作ではそんなに印象に残っていなかった戦闘シーンが素晴らしい出来に。
腕に光り輝いていたのは魔術刻印でしょうか?

*[その他]自転車が一番危ないと思う今日この頃。
自転車事故で1300万円賠償命令 パート女性の後悔:産経関西(産経新聞大阪本社公式ニュースサイト)
http://www.sankei-kansai.com/2009/09/02/20090902-014087.php
車なんかよりも保険の加入義務もなく、信号もなく、通る道もきっちり決まって無くて、車体自体は搭乗者の安全性を保証しない。
車の方がまだ安全だと個人的には思ってしまう。
あまり進まない自転車の進化に期待したい。

*[日記]今日はPS3が届く日。
なので、徹夜でお出迎えの準備は万端です。

2009年8月31日月曜日

アップデート

Total download size: 588 M
Is this ok [y/N]: y
Downloading Packages:
(1/235): OpenEXR-libs-1.6.1-8.fc11.x86_64.rpm | 252 kB 00:01
(2/235): PackageKit-0.4.9-1.fc11.x86_64.rpm | 471 kB 00:00
(3/235): PackageKit-glib-0.4.9-1.fc11.x86_64.rpm | 143 kB 00:00
(4/235): PackageKit-gtk-module-0.4.9-1.fc11.x86_64.rpm | 75 kB 00:00
(5/235): PackageKit-qt-0.4.9-1.fc11.x86_64.rpm | 162 kB 00:00
(6/235): PackageKit-yum-0.4.9-1.fc11.x86_64.rpm | 135 kB 00:00
(7/235): PackageKit-yum-plugin-0.4.9-1.fc11.x86_64.rpm | 71 kB 00:00
(8/235): PyKDE4-4.3.0-4.fc11.1.x86_64.rpm | 4.6 MB 00:01
(9/235): PyQt4-4.5.4-1.fc11.x86_64.rpm | 3.3 MB 00:00
(10/235): akonadi-1.2.0-1.fc11.x86_64.rpm | 672 kB 00:00
(11/235): alsa-tools-1.0.20-2.fc11.x86_64.rpm | 332 kB 00:00
(12/235): alsa-tools-firmware-1.0.20-2.fc11.x86_64.rpm | 31 kB 00:00
(13/235): anacron-2.3-78.fc11.x86_64.rpm | 43 kB 00:00
(14/235): anthy-9100h-7.fc11.x86_64.rpm | 7.1 MB 00:01
(15/235): apr-1.3.8-2.fc11.x86_64.rpm | 132 kB 00:02
(16/235): apr-util-1.3.9-1.fc11.x86_64.rpm | 94 kB 00:00
(17/235): apr-util-ldap-1.3.9-1.fc11.x86_64.rpm | 15 kB 00:00
(18/235): at-3.1.10-31.fc11.x86_64.rpm | 65 kB 00:00
(19/235): avahi-0.6.25-3.fc11.i586.rpm | 292 kB 00:00
(20/235): bash-4.0-8.fc11.x86_64.rpm | 1.1 MB 00:00
(21/235): bind-libs-9.6.1-4.P1.fc11.x86_64.rpm | 934 kB 00:00
(22/235): bind-utils-9.6.1-4.P1.fc11.x86_64.rpm | 247 kB 00:00
(23/235): binutils-2.19.51.0.14-1.fc11.x86_64.rpm | 3.4 MB 00:01
(24/235): bluez-cups-4.42-3.fc11.x86_64.rpm | 21 kB 00:00
(25/235): bluez-libs-4.42-3.fc11.x86_64.rpm | 75 kB 00:00
(26/235): cloog-ppl-0.15-0.9.gitb9d79.fc11.x86_64.rpm | 90 kB 00:00
(27/235): coreutils-7.2-3.fc11.x86_64.rpm | 5.2 MB 00:01
(28/235): cpp-4.4.1-2.fc11.x86_64.rpm | 4.1 MB 00:01
(29/235): crontabs-1.10-30.fc11.noarch.rpm | 9.8 kB 00:00
(30/235): cups-1.4-0.rc1.15.fc11.x86_64.rpm | 3.1 MB 00:01
(31/235): cups-libs-1.4-0.rc1.15.fc11.i586.rpm | 349 kB 00:03
(32/235): cups-libs-1.4-0.rc1.15.fc11.x86_64.rpm | 343 kB 00:00
(33/235): cups-pk-helper-0.0.4-3.fc11.x86_64.rpm | 34 kB 00:00
(34/235): device-mapper-1.02.33-2.fc11.x86_64.rpm | 87 kB 00:00
(35/235): device-mapper-devel-1.02.33-2.fc11.x86_64.rpm | 51 kB 00:00
(36/235): device-mapper-libs-1.02.33-2.fc11.x86_64.rpm | 86 kB 00:00
(37/235): dhclient-4.1.0p1-2.fc11.x86_64.rpm | 350 kB 00:00
(38/235): dirmngr-1.0.3-2.fc11.x86_64.rpm | 286 kB 00:00
(39/235): e2fsprogs-1.41.4-12.fc11.x86_64.rpm | 750 kB 00:00
(40/235): e2fsprogs-devel-1.41.4-12.fc11.x86_64.rpm | 744 kB 00:00
(41/235): e2fsprogs-libs-1.41.4-12.fc11.i586.rpm | 154 kB 00:00
(42/235): e2fsprogs-libs-1.41.4-12.fc11.x86_64.rpm | 150 kB 00:00
(43/235): elfutils-libelf-0.142-1.fc11.x86_64.rpm | 57 kB 00:00
(44/235): esound-libs-0.2.41-2.fc11.x86_64.rpm | 79 kB 00:00
(45/235): exiv2-libs-0.18.2-2.fc11.x86_64.rpm | 906 kB 00:00
(46/235): festival-1.96-12.fc11.x86_64.rpm | 1.4 MB 00:00
(47/235): festival-lib-1.96-12.fc11.x86_64.rpm | 459 kB 00:00
(48/235): festival-speechtools-libs-1.2.96-12.fc11.x86_64.rpm | 1.2 MB 00:04
(49/235): festvox-slt-arctic-hts-0.20061229-12.fc11.noarch.rpm | 1.6 MB 00:00
(50/235): firefox-3.5.2-2.fc11.x86_64.rpm | 15 MB 00:04
(51/235): flash-plugin-10.0.32.18-release.i386.rpm | 3.9 MB 00:15
(52/235): fontconfig-2.7.1-1.fc11.i586.rpm | 203 kB 00:00
(53/235): fontconfig-2.7.1-1.fc11.x86_64.rpm | 204 kB 00:00
(54/235): freetype-2.3.9-5.fc11.i586.rpm | 388 kB 00:00
(55/235): freetype-2.3.9-5.fc11.x86_64.rpm | 388 kB 00:00
(56/235): gcc-4.4.1-2.fc11.x86_64.rpm | 11 MB 00:04
(57/235): gcc-c++-4.4.1-2.fc11.x86_64.rpm | 5.2 MB 00:01
(58/235): genisoimage-1.1.9-6.fc11.x86_64.rpm | 594 kB 00:00
(59/235): ghostscript-8.70-1.fc11.x86_64.rpm | 6.1 MB 00:02
(60/235): glibc-2.10.1-4.i686.rpm | 5.8 MB 00:01
(61/235): glibc-2.10.1-4.x86_64.rpm | 5.2 MB 00:01
(62/235): glibc-common-2.10.1-4.x86_64.rpm | 23 MB 00:06
(63/235): glibc-devel-2.10.1-4.x86_64.rpm | 998 kB 00:00
(64/235): glibc-headers-2.10.1-4.x86_64.rpm | 630 kB 00:00
(65/235): gnome-python2-extras-2.25.3-6.fc11.x86_64.rpm | 49 kB 00:00
(66/235): gnome-python2-gtkhtml2-2.25.3-6.fc11.x86_64.rpm | 21 kB 00:00
(67/235): gnome-sharp-2.24.0-4.fc11.x86_64.rpm | 327 kB 00:00
(68/235): gnupg2-2.0.12-1.fc11.x86_64.rpm | 2.7 MB 00:00
(69/235): gpgme-1.1.8-1.fc11.x86_64.rpm | 300 kB 00:00
(70/235): gpsd-2.39-3.fc11.x86_64.rpm | 253 kB 00:00
(71/235): grub-0.97-51.fc11.x86_64.rpm | 975 kB 00:00
(72/235): grubby-6.0.87-3.fc11.x86_64.rpm | 95 kB 00:00
(73/235): gstreamer-0.10.24-1.fc11.x86_64.rpm | 863 kB 00:00
(74/235): gstreamer-tools-0.10.24-1.fc11.x86_64.rpm | 23 kB 00:00
(75/235): gtk-nodoka-engine-0.7.2-5.fc11.x86_64.rpm | 56 kB 00:00
(76/235): gtk-sharp2-2.12.7-5.fc11.x86_64.rpm | 817 kB 00:04
(77/235): gtk2-2.16.5-1.fc11.i586.rpm | 4.3 MB 00:01
(78/235): gtk2-2.16.5-1.fc11.x86_64.rpm | 4.4 MB 00:01
(79/235): gutenprint-5.2.4-2.fc11.x86_64.rpm | 3.1 MB 00:00
(80/235): gutenprint-foomatic-5.2.4-2.fc11.x86_64.rpm | 4.7 MB 00:01
(81/235): hal-0.5.12-29.20090226git.fc11.x86_64.rpm | 493 kB 00:00
(82/235): hal-libs-0.5.12-29.20090226git.fc11.x86_64.rpm | 73 kB 00:00
(83/235): hdparm-9.16-1.fc11.x86_64.rpm | 77 kB 00:00
(84/235): imsettings-0.107.2-1.fc11.x86_64.rpm | 168 kB 00:00
(85/235): imsettings-libs-0.107.2-1.fc11.x86_64.rpm | 113 kB 00:00
(86/235): iwl4965-firmware-228.61.2.24-1.fc11.noarch.rpm | 161 kB 00:05
(87/235): java-1.6.0-openjdk-1.6.0.0-27.b16.fc11.x86_64.rpm | 31 MB 00:08
(88/235): java-1.6.0-openjdk-demo-1.6.0.0-27.b16.fc11.x86_64.rpm | 2.2 MB 00:00
(89/235): java-1.6.0-openjdk-devel-1.6.0.0-27.b16.fc11.x86_64.rpm | 13 MB 00:03
(90/235): java-1.6.0-openjdk-javadoc-1.6.0.0-27.b16.fc11.x86_64.rpm | 20 MB 00:05
(91/235): java-1.6.0-openjdk-plugin-1.6.0.0-27.b16.fc11.x86_64.rpm | 113 kB 00:00
(92/235): java-1.6.0-openjdk-src-1.6.0.0-27.b16.fc11.x86_64.rpm | 25 MB 00:07
(93/235): kde-l10n-Japanese-4.3.0-1.fc11.noarch.rpm | 2.6 MB 00:03
(94/235): kde-settings-4.2-12.noarch.rpm | 38 kB 00:00
(95/235): kde-settings-kdm-4.2-12.noarch.rpm | 25 kB 00:00
(96/235): kde-settings-pulseaudio-4.2-12.noarch.rpm | 13 kB 00:00
(97/235): kde-style-phase-4.3.0-2.fc11.x86_64.rpm | 58 kB 00:00
(98/235): kdeaccessibility-4.3.0-3.fc11.x86_64.rpm | 6.8 MB 00:02
(99/235): kdeaccessibility-libs-4.3.0-3.fc11.x86_64.rpm | 73 kB 00:00
(100/235): kdeartwork-4.3.0-2.fc11.x86_64.rpm | 1.1 MB 00:00
(101/235): kdebase-4.3.0-1.fc11.x86_64.rpm | 5.5 MB 00:01
(102/235): kdebase-libs-4.3.0-1.fc11.x86_64.rpm | 275 kB 00:04
(103/235): kdebase-runtime-4.3.0-4.fc11.x86_64.rpm | 7.6 MB 00:02
(104/235): kdebase-runtime-libs-4.3.0-4.fc11.x86_64.rpm | 1.8 MB 00:00
(105/235): kdebase-workspace-4.3.0-9.fc11.x86_64.rpm | 14 MB 00:04
(106/235): kdebase-workspace-libs-4.3.0-9.fc11.x86_64.rpm | 898 kB 00:02
(107/235): kdeedu-marble-4.3.0-6.fc11.x86_64.rpm | 11 MB 00:03
(108/235): kdeedu-marble-libs-4.3.0-6.fc11.x86_64.rpm | 790 kB 00:00
(109/235): kdegames-4.3.0-2.fc11.x86_64.rpm | 43 MB 02:53
(110/235): kdegames-libs-4.3.0-2.fc11.x86_64.rpm | 1.4 MB 00:12
(111/235): kdegraphics-4.3.0-1.fc11.x86_64.rpm | 3.6 MB 00:33
(112/235): kdegraphics-libs-4.3.0-1.fc11.x86_64.rpm | 1.0 MB 00:10
(113/235): kdelibs-4.3.0-6.fc11.x86_64.rpm | 14 MB 02:12
(114/235): kdelibs-common-4.3.0-6.fc11.x86_64.rpm | 778 kB 00:04
(115/235): kdelibs-experimental-4.3.0-1.fc11.x86_64.rpm | 38 kB 00:05
(116/235): kdelibs3-3.5.10-13.fc11.x86_64.rpm | 18 MB 02:33
(117/235): kdemultimedia-4.3.0-1.fc11.x86_64.rpm | 1.8 MB 00:17
(118/235): kdemultimedia-libs-4.3.0-1.fc11.x86_64.rpm | 332 kB 00:02
(119/235): kdenetwork-4.3.0-1.fc11.x86_64.rpm | 9.5 MB 01:24
(120/235): kdenetwork-libs-4.3.0-1.fc11.x86_64.rpm | 1.9 MB 00:20
(121/235): kdepim-4.3.0-4.fc11.x86_64.rpm | 10 MB 00:44
(122/235): kdepim-libs-4.3.0-4.fc11.x86_64.rpm | 7.3 MB 00:03
(123/235): kdepim-runtime-4.3.0-1.fc11.x86_64.rpm | 1.3 MB 00:00
(124/235): kdepim-runtime-libs-4.3.0-1.fc11.x86_64.rpm | 320 kB 00:00
(125/235): kdepimlibs-4.3.0-2.fc11.x86_64.rpm | 2.4 MB 00:01
(126/235): kdepimlibs-akonadi-4.3.0-2.fc11.x86_64.rpm | 500 kB 00:00
(127/235): kdeplasma-addons-4.3.0-8.fc11.x86_64.rpm | 2.8 MB 00:01
(128/235): kdeplasma-addons-libs-4.3.0-8.fc11.x86_64.rpm | 365 kB 00:00
(129/235): kdesvn-1.4.0-1.fc11.x86_64.rpm | 2.4 MB 00:07
(130/235): kdesvn-devel-1.4.0-1.fc11.x86_64.rpm | 45 kB 00:00
(131/235): kdeutils-4.3.0-3.fc11.x86_64.rpm | 2.8 MB 00:03
(132/235): kdeutils-libs-4.3.0-3.fc11.x86_64.rpm | 495 kB 00:00
(133/235): kdeutils-printer-applet-4.3.0-3.fc11.x86_64.rpm | 60 kB 00:00
(134/235): kdm-4.3.0-9.fc11.x86_64.rpm | 2.0 MB 00:09
(135/235): kernel-2.6.29.6-217.2.16.fc11.x86_64.rpm | 22 MB 00:21
(136/235): kernel-devel-2.6.29.6-217.2.16.fc11.x86_64.rpm | 6.2 MB 00:03
(137/235): kernel-firmware-2.6.29.6-217.2.16.fc11.noarch.rpm | 503 kB 00:00
(138/235): kernel-headers-2.6.29.6-217.2.16.fc11.x86_64.rpm | 855 kB 00:00
(139/235): kio_msits-4.3.0-1.fc11.x86_64.rpm | 24 kB 00:00
(140/235): konq-plugins-4.3.0-1.fc11.x86_64.rpm | 2.3 MB 00:01
(141/235): kpackagekit-0.4.2-0.fc11.x86_64.rpm | 920 kB 00:00
(142/235): ksysguardd-4.3.0-9.fc11.x86_64.rpm | 78 kB 00:00
(143/235): leonidas-kde-theme-11.0.2-1.fc11.noarch.rpm | 1.1 MB 00:00
(144/235): libX11-1.2.2-1.fc11.i586.rpm | 1.0 MB 00:06
(145/235): libX11-1.2.2-1.fc11.x86_64.rpm | 1.0 MB 00:01
(146/235): libX11-devel-1.2.2-1.fc11.x86_64.rpm | 1.1 MB 00:01
(147/235): libbdevid-python-6.0.87-3.fc11.x86_64.rpm | 70 kB 00:00
(148/235): libdaemon-0.13-2.fc11.i586.rpm | 28 kB 00:00
(149/235): libgcc-4.4.1-2.fc11.i586.rpm | 98 kB 00:00
(150/235): libgcc-4.4.1-2.fc11.x86_64.rpm | 78 kB 00:00
(151/235): libgcj-4.4.1-2.fc11.x86_64.rpm | 21 MB 00:18
(152/235): libgomp-4.4.1-2.fc11.x86_64.rpm | 82 kB 00:01
(153/235): libksba-1.0.6-1.fc11.x86_64.rpm | 115 kB 00:00
(154/235): libmad-0.15.1b-13.fc11.x86_64.rpm | 83 kB 00:02
(155/235): libmsn-4.0-0.12.beta7.fc11.x86_64.rpm | 322 kB 00:00
(156/235): libmtp-0.3.7-2.fc11.x86_64.rpm | 105 kB 00:00
(157/235): libstdc++-4.4.1-2.fc11.i586.rpm | 326 kB 00:00
(158/235): libstdc++-4.4.1-2.fc11.x86_64.rpm | 323 kB 00:00
(159/235): libstdc++-devel-4.4.1-2.fc11.x86_64.rpm | 1.8 MB 00:01
(160/235): libtool-ltdl-2.2.6-11.fc11.1.i586.rpm | 46 kB 00:00
(161/235): libtool-ltdl-2.2.6-11.fc11.1.x86_64.rpm | 46 kB 00:00
(162/235): libvncserver-0.9.7-2.fc11.x86_64.rpm | 176 kB 00:00
(163/235): libvorbis-1.2.0-8.fc11.x86_64.rpm | 214 kB 00:00
(164/235): libxml2-2.7.3-3.fc11.i586.rpm | 849 kB 00:00
(165/235): libxml2-2.7.3-3.fc11.x86_64.rpm | 859 kB 00:00
(166/235): libxml2-python-2.7.3-3.fc11.x86_64.rpm | 418 kB 00:00
(167/235): logwatch-7.3.6-43.fc11.noarch.rpm | 333 kB 00:00
(168/235): lvm2-2.02.48-2.fc11.x86_64.rpm | 437 kB 00:00
(169/235): mkinitrd-6.0.87-3.fc11.x86_64.rpm | 91 kB 00:00
(170/235): mysql-5.1.36-1.fc11.x86_64.rpm | 3.7 MB 00:09
(171/235): mysql-devel-5.1.36-1.fc11.x86_64.rpm | 3.2 MB 00:06
(172/235): mysql-libs-5.1.36-1.fc11.x86_64.rpm | 2.1 MB 00:19
(173/235): mysql-server-5.1.36-1.fc11.x86_64.rpm | 11 MB 00:21
(174/235): nash-6.0.87-3.fc11.x86_64.rpm | 173 kB 00:00
(175/235): ndesk-dbus-0.6.1a-6.fc11.x86_64.rpm | 52 kB 00:00
(176/235): ndesk-dbus-glib-0.4.1-5.fc11.x86_64.rpm | 11 kB 00:00
(177/235): neon-0.28.6-1.fc11.x86_64.rpm | 121 kB 00:00
(178/235): net-tools-1.60-93.fc11.x86_64.rpm | 372 kB 00:00
(179/235): nfs-utils-1.2.0-4.fc11.x86_64.rpm | 322 kB 00:00
(180/235): nmap-5.00-1.fc11.x86_64.rpm | 1.4 MB 00:00
(181/235): nmap-frontend-5.00-1.fc11.x86_64.rpm | 721 kB 00:00
(182/235): notify-sharp-0.4.0-0.9.20080912svn.fc11.x86_64.rpm | 14 kB 00:00
(183/235): nscd-2.10.1-4.x86_64.rpm | 197 kB 00:00
(184/235): nss-3.12.3.99.3-2.11.4.fc11.i586.rpm | 1.0 MB 00:00
(185/235): nss-3.12.3.99.3-2.11.4.fc11.x86_64.rpm | 1.0 MB 00:00
(186/235): nss-softokn-freebl-3.12.3.99.3-2.11.4.fc11.i586.rpm | 136 kB 00:00
(187/235): nss-softokn-freebl-3.12.3.99.3-2.11.4.fc11.x86_64.rpm | 149 kB 00:00
(188/235): openslp-1.2.1-11.fc11.x86_64.rpm | 61 kB 00:00
(189/235): oxygen-icon-theme-4.3.0-1.fc11.noarch.rpm | 20 MB 00:11
(190/235): pango-1.24.5-1.fc11.i586.rpm | 401 kB 00:00
(191/235): pango-1.24.5-1.fc11.x86_64.rpm | 407 kB 00:00
(192/235): pciutils-3.1.3-1.fc11.x86_64.rpm | 80 kB 00:00
(193/235): pciutils-libs-3.1.3-1.fc11.x86_64.rpm | 35 kB 00:00
(194/235): pinentry-0.7.6-1.fc11.x86_64.rpm | 67 kB 00:00
(195/235): pinentry-qt-0.7.6-1.fc11.x86_64.rpm | 64 kB 00:00
(196/235): python-setuptools-0.6c9-4.fc11.noarch.rpm | 308 kB 00:00
(197/235): qt-4.5.2-2.fc11.x86_64.rpm | 3.8 MB 00:02
(198/235): qt-mysql-4.5.2-2.fc11.x86_64.rpm | 54 kB 00:00
(199/235): qt-x11-4.5.2-2.fc11.x86_64.rpm | 16 MB 00:12
(200/235): rpm-4.7.1-1.fc11.x86_64.rpm | 1.0 MB 00:01
(201/235): rpm-libs-4.7.1-1.fc11.x86_64.rpm | 363 kB 00:00
(202/235): rpm-python-4.7.1-1.fc11.x86_64.rpm | 52 kB 00:00
(203/235): rsyslog-3.22.1-1.fc11.x86_64.rpm | 390 kB 00:00
(204/235): ruby-libs-1.8.6.369-1.fc11.x86_64.rpm | 1.8 MB 00:00
(205/235): selinux-policy-3.6.12-80.fc11.noarch.rpm | 611 kB 00:00
(206/235): selinux-policy-targeted-3.6.12-80.fc11.noarch.rpm | 2.2 MB 00:01
(207/235): setroubleshoot-2.1.14-3.fc11.x86_64.rpm | 137 kB 00:00
(208/235): setroubleshoot-plugins-2.0.18-5.fc11.noarch.rpm | 890 kB 00:00
(209/235): setroubleshoot-server-2.1.14-3.fc11.x86_64.rpm | 359 kB 00:00
(210/235): setuptool-1.19.6-1.fc11.x86_64.rpm | 66 kB 00:00
(211/235): shadow-utils-4.1.4.1-5.fc11.x86_64.rpm | 1.2 MB 00:00
(212/235): sip-4.8.2-1.fc11.x86_64.rpm | 251 kB 00:00
(213/235): smolt-1.3-1.fc11.noarch.rpm | 297 kB 00:00
(214/235): smolt-firstboot-1.3-1.fc11.noarch.rpm | 16 kB 00:00
(215/235): soprano-2.3.0-2.fc11.x86_64.rpm | 730 kB 00:00
(216/235): sos-1.8-14.fc11.noarch.rpm | 221 kB 00:00
(217/235): strigi-libs-0.7.0-1.fc11.x86_64.rpm | 523 kB 00:00
(218/235): subversion-1.6.4-2.fc11.x86_64.rpm | 3.1 MB 00:02
(219/235): system-config-lvm-1.1.9-1.fc11.noarch.rpm | 729 kB 00:00
(220/235): system-config-printer-kde-4.3.0-1.fc11.x86_64.rpm | 105 kB 00:00
(221/235): system-config-services-0.99.35-1.fc11.noarch.rpm | 186 kB 00:00
(222/235): tasque-0.1.8-4.fc11.x86_64.rpm | 242 kB 00:00
(223/235): trac-0.11.4-1.fc11.noarch.rpm | 1.1 MB 00:00
(224/235): tzdata-2009k-2.fc11.noarch.rpm | 836 kB 00:00
(225/235): tzdata-java-2009k-2.fc11.noarch.rpm | 185 kB 00:00
(226/235): upstart-0.3.11-1.fc11.x86_64.rpm | 263 kB 00:00
(227/235): vlc-1.0.1-2.fc11.x86_64.rpm | 1.9 MB 00:16
(228/235): vlc-core-1.0.1-2.fc11.x86_64.rpm | 8.1 MB 01:05
(229/235): wodim-1.1.9-6.fc11.x86_64.rpm | 527 kB 00:02
(230/235): xorg-x11-drv-evdev-2.2.4-1.fc11.x86_64.rpm | 28 kB 00:00
(231/235): xorg-x11-drv-synaptics-1.1.3-1.fc11.x86_64.rpm | 66 kB 00:00
(232/235): xulrunner-1.9.1.2-1.fc11.x86_64.rpm | 9.5 MB 00:02
(233/235): xz-4.999.8-0.8.beta.20090817git.fc11.x86_64.rpm | 123 kB 00:00
(234/235): xz-libs-4.999.8-0.8.beta.20090817git.fc11.x86_64.rpm | 98 kB 00:00
(235/235): xz-lzma-compat-4.999.8-0.8.beta.20090817git.fc11.x86_64.rpm | 32 kB 00:00
----------------------------------------------------------------------------------------------------------------------------------
Total 529 kB/s | 588 MB 18:58

2009年7月25日土曜日

Fedora11 へのPostgreSQL 8.4の導入

お仕事の都合上Fedora11へPostgreSQL 8.4を導入。

bash-4.0$ ./configure
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking which template to use... linux
checking whether to build with 64-bit integer date/time support... yes
checking whether NLS is wanted... no
checking for default port number... 5432
checking for block size... 8kB
checking for segment size... 1GB
checking for WAL block size... 8kB
checking for WAL segment size... 16MB
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking if gcc supports -Wdeclaration-after-statement... yes
checking if gcc supports -Wendif-labels... yes
checking if gcc supports -fno-strict-aliasing... yes
checking if gcc supports -fwrapv... yes
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking allow thread-safe client libraries... no
checking whether to build with Tcl... no
checking whether to build Perl modules... no
checking whether to build Python modules... no
checking whether to build with GSSAPI support... no
checking whether to build with Kerberos 5 support... no
checking whether to build with PAM support... no
checking whether to build with LDAP support... no
checking whether to build with Bonjour support... no
checking whether to build with OpenSSL support... no
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for ranlib... ranlib
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for ar... ar
checking for tar... /bin/tar
checking whether ln -s works... yes
checking for gawk... gawk
checking for bison... no
configure: WARNING:
*** Without Bison you will not be able to build PostgreSQL from CVS nor
*** change any of the parser definition files. You can obtain Bison from
*** a GNU mirror site. (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this, because the Bison
*** output is pre-generated.)
checking for flex... no
configure: WARNING:
*** Without Flex you will not be able to build PostgreSQL from CVS or
*** change any of the scanner definition files. You can obtain Flex from
*** a GNU mirror site. (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this because the Flex
*** output is pre-generated.)
checking for perl... /usr/bin/perl
checking for main in -lm... yes
checking for library containing setproctitle... no
checking for library containing dlopen... -ldl
checking for library containing socket... none required
checking for library containing shl_load... no
checking for library containing getopt_long... none required
checking for library containing crypt... -lcrypt
checking for library containing fdatasync... none required
checking for library containing gethostbyname_r... none required
checking for library containing shmget... none required
checking for -lreadline... no
checking for -ledit... no
configure: error: readline library not found
If you have readline already installed, see config.log for details on the
failure. It is possible the compiler isn't looking in the proper directory.
Use --without-readline to disable readline support.

以前の日記で書いたように、readlineを探してくる。
# yum install readline-devel.x86_64
再度./configureを実行。

bash-4.0$ ./configure
checking build system type... x86_64-unknown-linux-gnu
checking host system type... x86_64-unknown-linux-gnu
checking which template to use... linux
checking whether to build with 64-bit integer date/time support... yes
checking whether NLS is wanted... no
checking for default port number... 5432
checking for block size... 8kB
checking for segment size... 1GB
checking for WAL block size... 8kB
checking for WAL segment size... 16MB
checking for gcc... gcc
checking for C compiler default output file name... a.out
checking whether the C compiler works... yes
checking whether we are cross compiling... no
checking for suffix of executables...
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking if gcc supports -Wdeclaration-after-statement... yes
checking if gcc supports -Wendif-labels... yes
checking if gcc supports -fno-strict-aliasing... yes
checking if gcc supports -fwrapv... yes
checking whether the C compiler still works... yes
checking how to run the C preprocessor... gcc -E
checking allow thread-safe client libraries... no
checking whether to build with Tcl... no
checking whether to build Perl modules... no
checking whether to build Python modules... no
checking whether to build with GSSAPI support... no
checking whether to build with Kerberos 5 support... no
checking whether to build with PAM support... no
checking whether to build with LDAP support... no
checking whether to build with Bonjour support... no
checking whether to build with OpenSSL support... no
checking for grep that handles long lines and -e... /bin/grep
checking for egrep... /bin/grep -E
checking for ld used by GCC... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for ranlib... ranlib
checking for strip... strip
checking whether it is possible to strip libraries... yes
checking for ar... ar
checking for tar... /bin/tar
checking whether ln -s works... yes
checking for gawk... gawk
checking for bison... no
configure: WARNING:
*** Without Bison you will not be able to build PostgreSQL from CVS nor
*** change any of the parser definition files. You can obtain Bison from
*** a GNU mirror site. (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this, because the Bison
*** output is pre-generated.)
checking for flex... no
configure: WARNING:
*** Without Flex you will not be able to build PostgreSQL from CVS or
*** change any of the scanner definition files. You can obtain Flex from
*** a GNU mirror site. (If you are using the official distribution of
*** PostgreSQL then you do not need to worry about this because the Flex
*** output is pre-generated.)
checking for perl... /usr/bin/perl
checking for main in -lm... yes
checking for library containing setproctitle... no
checking for library containing dlopen... -ldl
checking for library containing socket... none required
checking for library containing shl_load... no
checking for library containing getopt_long... none required
checking for library containing crypt... -lcrypt
checking for library containing fdatasync... none required
checking for library containing gethostbyname_r... none required
checking for library containing shmget... none required
checking for -lreadline... yes (-lreadline)
checking for inflate in -lz... yes
checking for ANSI C header files... yes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking crypt.h usability... yes
checking crypt.h presence... yes
checking for crypt.h... yes
checking dld.h usability... no
checking dld.h presence... no
checking for dld.h... no
checking fp_class.h usability... no
checking fp_class.h presence... no
checking for fp_class.h... no
checking getopt.h usability... yes
checking getopt.h presence... yes
checking for getopt.h... yes
checking ieeefp.h usability... no
checking ieeefp.h presence... no
checking for ieeefp.h... no
checking langinfo.h usability... yes
checking langinfo.h presence... yes
checking for langinfo.h... yes
checking poll.h usability... yes
checking poll.h presence... yes
checking for poll.h... yes
checking pwd.h usability... yes
checking pwd.h presence... yes
checking for pwd.h... yes
checking sys/ipc.h usability... yes
checking sys/ipc.h presence... yes
checking for sys/ipc.h... yes
checking sys/poll.h usability... yes
checking sys/poll.h presence... yes
checking for sys/poll.h... yes
checking sys/pstat.h usability... no
checking sys/pstat.h presence... no
checking for sys/pstat.h... no
checking sys/resource.h usability... yes
checking sys/resource.h presence... yes
checking for sys/resource.h... yes
checking sys/select.h usability... yes
checking sys/select.h presence... yes
checking for sys/select.h... yes
checking sys/sem.h usability... yes
checking sys/sem.h presence... yes
checking for sys/sem.h... yes
checking sys/socket.h usability... yes
checking sys/socket.h presence... yes
checking for sys/socket.h... yes
checking sys/shm.h usability... yes
checking sys/shm.h presence... yes
checking for sys/shm.h... yes
checking sys/tas.h usability... no
checking sys/tas.h presence... no
checking for sys/tas.h... no
checking sys/time.h usability... yes
checking sys/time.h presence... yes
checking for sys/time.h... yes
checking sys/un.h usability... yes
checking sys/un.h presence... yes
checking for sys/un.h... yes
checking termios.h usability... yes
checking termios.h presence... yes
checking for termios.h... yes
checking ucred.h usability... no
checking ucred.h presence... no
checking for ucred.h... no
checking utime.h usability... yes
checking utime.h presence... yes
checking for utime.h... yes
checking wchar.h usability... yes
checking wchar.h presence... yes
checking for wchar.h... yes
checking wctype.h usability... yes
checking wctype.h presence... yes
checking for wctype.h... yes
checking kernel/OS.h usability... no
checking kernel/OS.h presence... no
checking for kernel/OS.h... no
checking kernel/image.h usability... no
checking kernel/image.h presence... no
checking for kernel/image.h... no
checking SupportDefs.h usability... no
checking SupportDefs.h presence... no
checking for SupportDefs.h... no
checking netinet/in.h usability... yes
checking netinet/in.h presence... yes
checking for netinet/in.h... yes
checking for netinet/tcp.h... yes
checking readline/readline.h usability... yes
checking readline/readline.h presence... yes
checking for readline/readline.h... yes
checking readline/history.h usability... yes
checking readline/history.h presence... yes
checking for readline/history.h... yes
checking zlib.h usability... yes
checking zlib.h presence... yes
checking for zlib.h... yes
checking whether byte ordering is bigendian... no
checking for an ANSI C-conforming const... yes
checking for inline... inline
checking for preprocessor stringizing operator... yes
checking for signed types... yes
checking for working volatile... yes
checking for __func__... yes
checking whether struct tm is in sys/time.h or time.h... time.h
checking for struct tm.tm_zone... yes
checking for tzname... yes
checking for union semun... no
checking for struct sockaddr_un... yes
checking for struct sockaddr_storage... yes
checking for struct sockaddr_storage.ss_family... yes
checking for struct sockaddr_storage.__ss_family... no
checking for struct sockaddr_storage.ss_len... no
checking for struct sockaddr_storage.__ss_len... no
checking for struct sockaddr.sa_len... no
checking for struct addrinfo... yes
checking for struct cmsgcred... no
checking for struct fcred... no
checking for struct sockcred... no
checking for struct option... yes
checking for z_streamp... yes
checking for int timezone... yes
checking types of arguments for accept()... int, int, struct sockaddr *, socklen_t *
checking whether gettimeofday takes only one argument... no
checking for cbrt... yes
checking for dlopen... yes
checking for fcvt... yes
checking for fdatasync... yes
checking for getpeereid... no
checking for getpeerucred... no
checking for getrlimit... yes
checking for memmove... yes
checking for poll... yes
checking for pstat... no
checking for readlink... yes
checking for setproctitle... no
checking for setsid... yes
checking for sigprocmask... yes
checking for symlink... yes
checking for sysconf... yes
checking for towlower... yes
checking for utime... yes
checking for utimes... yes
checking for waitpid... yes
checking for wcstombs... yes
checking for posix_fadvise... yes
checking whether posix_fadvise is declared... yes
checking whether fdatasync is declared... yes
checking whether strlcat is declared... no
checking whether strlcpy is declared... no
checking whether F_FULLFSYNC is declared... no
checking for struct sockaddr_in6... yes
checking for PS_STRINGS... no
checking for snprintf... yes
checking for vsnprintf... yes
checking whether snprintf is declared... yes
checking whether vsnprintf is declared... yes
checking for isinf... yes
checking for crypt... yes
checking for getopt... yes
checking for getrusage... yes
checking for inet_aton... yes
checking for random... yes
checking for rint... yes
checking for srandom... yes
checking for strdup... yes
checking for strerror... yes
checking for strlcat... no
checking for strlcpy... no
checking for strtol... yes
checking for strtoul... yes
checking for unsetenv... yes
checking for getaddrinfo... yes
checking for getopt_long... yes
checking for rl_completion_append_character... yes
checking for rl_completion_matches... yes
checking for rl_filename_completion_function... yes
checking for replace_history_entry... yes
checking for sigsetjmp... yes
checking whether sys_siglist is declared... yes
checking for syslog... yes
checking syslog.h usability... yes
checking syslog.h presence... yes
checking for syslog.h... yes
checking for opterr... yes
checking for optreset... no
checking for strtoll... yes
checking for strtoull... yes
checking for atexit... yes
checking for fseeko... yes
checking for _LARGEFILE_SOURCE value needed for large files... no
checking test program... ok
checking whether long int is 64 bits... yes
checking for unsigned long... yes
checking size of unsigned long... 8
checking for void *... yes
checking size of void *... 8
checking for size_t... yes
checking size of size_t... 8
checking whether to build with float4 passed by value... yes
checking whether to build with float8 passed by value... yes
checking for short... yes
checking alignment of short... 2
checking for int... yes
checking alignment of int... 4
checking for long... yes
checking alignment of long... 8
checking for double... yes
checking alignment of double... 8
checking for int8... no
checking for uint8... no
checking for int64... no
checking for uint64... no
checking for sig_atomic_t... yes
checking for POSIX signal interface... yes
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking for off_t... yes
checking size of off_t... 8
checking for working memcmp... yes
checking for onsgmls... no
checking for nsgmls... no
checking for openjade... no
checking for jade... no
checking for DocBook V4.2... no
checking for DocBook stylesheets... no
checking for collateindex.pl... no
checking for sgmlspl... no
checking for docbook2man...
checking if gcc supports -Wl,--as-needed... yes
configure: using CFLAGS=-O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -fno-strict-aliasing -fwrapv
configure: using CPPFLAGS= -D_GNU_SOURCE
configure: using LDFLAGS= -Wl,--as-needed
configure: creating ./config.status
config.status: creating GNUmakefile
config.status: creating src/Makefile.global
config.status: creating src/include/pg_config.h
config.status: creating src/interfaces/ecpg/include/ecpg_config.h
config.status: linking ./src/backend/port/tas/dummy.s to src/backend/port/tas.s
config.status: linking ./src/backend/port/dynloader/linux.c to src/backend/port/dynloader.c
config.status: linking ./src/backend/port/sysv_sema.c to src/backend/port/pg_sema.c
config.status: linking ./src/backend/port/sysv_shmem.c to src/backend/port/pg_shmem.c
config.status: linking ./src/backend/port/dynloader/linux.h to src/include/dynloader.h
config.status: linking ./src/include/port/linux.h to src/include/pg_config_os.h
config.status: linking ./src/makefiles/Makefile.linux to src/Makefile.por


$ make
# make install
# adduser postgres
# mkdir /usr/local/pgsql/data
# chown postgres /usr/local/pgsql/data
# su - postgres
$ /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data

The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale ja_JP.UTF-8.
The default database encoding has accordingly been set to UTF8.
initdb: could not find suitable text search configuration for locale ja_JP.UTF-8
The default text search configuration will be set to "simple".

fixing permissions on existing directory /usr/local/pgsql/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 24MB
creating configuration files ... ok
creating template1 database in /usr/local/pgsql/data/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
or
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -l logfile start


$ /usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data >logfile 2>&1 &
postgresを起動。
$ /usr/local/pgsql/bin/createdb test
testDBの作成
$ /usr/local/pgsql/bin/psql test
testDBへアクセス

2009年7月14日火曜日

2009年6月26日金曜日

"セキュリティ" "可視化" 関連リンク

JavaScript InfoVis Toolkit - Demos
JavaScriptを利用した色々な可視化手法のデモ


prefuse | interactive information visualization toolkit
Javaアプレットを利用した可視化手法のデモ


武田圭史のセキュアーで行こう!:ITmedia オルタナティブ・ブログ

武田圭史

Fedor11

yum udate
> /sbin/ldconfig: File /usr/lib64/libprelude.so.2.17.1 is empty, not checked.
> /sbin/ldconfig: File /usr/lib64/libpreludecpp.so.0 is empty, not checked.
> /sbin/ldconfig: File /usr/lib64/libpreludecpp.so.0.0.3 is empty, not checked.>
> /sbin/ldconfig: File /usr/lib64/libprelude.so.2 is empty, not checked.


何のエラーだろう。
とりあえずlibpreludeについて調べてみた。
http://packages.debian.org/ja/sid/libprelude-dev

Prelude is a general-purpose hybrid intrusion detection system. Its goals are performance and modularity. It is divided in two main parts :

- the Prelude sensors, responsible for generating alerts, such as
snort featuring a signature engine, plugins for
protocol analysis, and intrusion detection plugins, and the Prelude
log monitoring lackey.
- the Prelude report server, collecting data from Prelude sensors,
and generating user-readable reports.

This package contains the development files for Prelude components.

IDSの一種らしい。導入した記憶がなぃ。

2009年6月24日水曜日

Nepenthesについて

Link
http://www.vogue.is.uec.ac.jp/honeynet/whitepaper.html



"The Nepenthes Platform:An Efficient Approach to Collect Malware. "

Automated Malware Collection.
motto "know your enemy"

2009年6月12日金曜日

Snortについて

Snortについての日本語の情報って思っていたよりもないの?
Wikipediaの日本語記事がなくて、微妙にがっかりした今日この頃。

Snortとは何か?
1998年にMartin Roeschによってリリースされた、クロスプラットフォームで軽量なNIDS(Network intrusion detection systems/ネットワーク侵入検出システム)。
現在もSourcefire社によって開発されている。
GPL(GNU General Public License)の基で使用が可能。つまりはほとんど自由に使ってイイよってこと。
NIDSは基本的にお値段が高いが、Snortを使えば個人でもタダで使える!
小規模なTCP/IPネットワークをモニタリングし、怪しげなトラフィックを検出し調査できる。
2009年6月12日現在の安定バージョンは2.8.4.1。
ダウンロードはhttp://www.snort.org/downloadsから。


Snortの特徴

Snortはlibpcap(http://en.wikipedia.org/wiki/Pcap)を利用しパケットスニファを行う。
パケットスニファにより収集したデータに対して、ルールを基にログとして収集し、その内容に対してパターンマッチングを行う。
このパターンマッチングによりBuffer overflowsやstealth port scans, CGI attacks, SMB probesなどの様々な攻撃を検出できる。
Snortはこれらを検出した場合にリアルタイムで警告が可能で、また警告をSyslog(RFC 3164/ http://tools.ietf.org/html/rfc3146)に転送することも可能である。

2009年4月22日水曜日

VisualStudio + SDL

SDL:Tutorials:Setup - GPWiki

Windows XPにVisual StudioとSDLを導入するメモ。

VisualStudio 2005 Pro


WindowsVista(x64) & VisualStudio 2008

SDL
http://www.libsdl.org/
からDevelopment Librariesをダウンロードしてくる。


SDL mixer
http://www.libsdl.org/projects/SDL_mixer/
Win32のDL_mixer-devel-1.2.8-VC8.zipをダウンロードしてくる。


SDL ttf
http://www.libsdl.org/projects/SDL_ttf/
Win32のSDL_ttf-devel-2.0.9-VC8.zipをダウンロード。


SDL image
http://www.libsdl.org/projects/SDL_image/
Win32のSDL_image-devel-1.2.7-VC9.zipをダウンロード。


全てのzipを解凍すると出てくるincludeディレクトリとlibディレクトリを統合する。

各フォルダの中身は以下の通り。


include

begin_code.h
close_code.h
SDL.h
SDL_active.h
SDL_audio.h
SDL_byteorder.h
SDL_cdrom.h
SDL_config.h
SDL_config.h.default
SDL_config.h.in
SDL_config_amiga.h
SDL_config_dreamcast.h
SDL_config_macos.h
SDL_config_macosx.h
SDL_config_minimal.h
SDL_config_nds.h
SDL_config_os2.h
SDL_config_symbian.h
SDL_config_win32.h
SDL_copying.h
SDL_cpuinfo.h
SDL_endian.h
SDL_error.h
SDL_events.h
SDL_getenv.h
SDL_image.h
SDL_joystick.h
SDL_keyboard.h
SDL_keysym.h
SDL_loadso.h
SDL_main.h
SDL_mixer.h
SDL_mouse.h
SDL_mutex.h
SDL_name.h
SDL_opengl.h
SDL_platform.h
SDL_quit.h
SDL_rwops.h
SDL_stdinc.h
SDL_syswm.h
SDL_thread.h
SDL_timer.h
SDL_ttf.h
SDL_types.h
SDL_version.h
SDL_video.h


lib

jpeg.dll
libfreetype-6.dll
libogg-0.dll
libpng12-0.dll
libtiff-3.dll
libvorbis-0.dll
libvorbisfile-3.dll
SDL.dll
SDL.lib
SDLmain.lib
SDL_image.dll
SDL_image.lib
SDL_mixer.dll
SDL_mixer.lib
SDL_ttf.dll
SDL_ttf.lib
smpeg.dll
zlib1.dll


プロジェクトを実際に作成し、そのプロジェクトのプロパティを設定していく。

プロジェクト->プロパティ->構成プロパティ->リンカ->入力->追加の依存ファイル
SDL.lib SDL_image.lib SDL_mixer.lib SDLmain.lib SDL_ttf.lib opengl32.lib

プロジェクト->プロパティ->構成プロパティ->リンカ->入力->特定のライブラリの無視
msvcrt.lib

プロジェクト->プロパティ->構成プロパティ->リンカ->システム->サブシステム
Windows (/SUBSYSTEM:WINDOWS)

作成したプロジェクトのソースファイルが存在するディレクトリにlibフォルダ内のライブラリをコピー(ぇー

2009年3月22日日曜日

店舗情報:日比谷花壇

店舗情報:日比谷花壇

謝恩会で渡す花を買う為に.

Fedora11の問題の解消

http://fedoraproject.org/wiki/Fedora_11_Alpha_release_notes

既存の問題があったのですねぇ…….
yum update実行して早速壊した口なのでメモ.
ここら辺がFedoraの醍醐味.たまらん.


yum reinstall rpm.i586
yum --skip-broken update

2009年3月1日日曜日

読書の日々.

*[日記]
大学で発表練習.
卒論の資料をそのまま使い回したらぼっこぼこに.
まぁそりゃそうなんだけどさぁ~.
友人Sの家に放置してきた自転車を徒歩で回収.
ヒトクイマジカルとネコソギラジカル読んでたら日付が変わってしまった.
そして寝てたらもう夕方.

[アニメ] 仮面のメイドガイ 第08話~第12話
**仮面のメイドガイ 第08話 「その名は怪傑!いちご仮面」
スゲェ懐かしいストーリー.
単行本だと解像度が高すぎてかなり読み辛いのだが,アニメだと楽だなぁ.
ノーブラwww 
馬鹿すぎるwwwww

**仮面のメイドガイ 第09話 「甘いご奉仕 谷間の中に」
こんなアホな話あったなぁww
店長滅茶苦茶なのに何かカッコイイw

**仮面のメイドガイ 第10話 「ファインをねらえ!」
数学不可能だったのかw
ついに神社が出てきたか.


**仮面のメイドガイ 第11話 「真夏の夜の乳」
ハートを闇討ちwwww
最近原作の方はリーダーの出番ないなぁー.そういえばエリザベスも.
メイドたこ焼き?
金魚何か一瞬すげぇ格好良かったんだが,


**仮面のメイドガイ 第12話 「さらば愛しきメイドガイ」
戦闘力高ぇなぁw
どこまでいってもセクハラなあたりが素敵.

2009年1月26日月曜日

warning: FT_OpenType_Validate is disabled. Replace FreeType2 with otvalid-enabled version.

2009年1月25日日曜日

SA1F00AへUbuntu8.10をインストールしてみる。

現実逃避の一環なのかと聞かれたらまさしくその通り。
まぁ寝ながらいろいろできる環境を整えるというのは大事な事ですよね。
一回インストールしたが、画面の解像度変えたらXが不調で、ログインするとフリーズするとかいう事態に…。
xorg.confの設定を弄ればいけそうではあったが、念のため再インストール。
SA1F00AはHDDのMBRをいじいじされているらしいので、Windowsの管理領域上にインストール。
念のため初期設定をここに。
/etc/X11/xorg.conf

# xorg.conf (X.Org X Window System server configuration file)
#
# This file was generated by dexconf, the Debian X Configuration tool, using
# values from the debconf database.
#
# Edit this file with caution, and see the xorg.conf manual page.
# (Type "man xorg.conf" at the shell prompt.)
#
# This file is automatically updated on xserver-xorg package upgrades *only*
# if it has not been modified since the last upgrade of the xserver-xorg
# package.
#
# Note that some configuration settings that could be done previously
# in this file, now are automatically configured by the server and settings
# here are ignored.
#
# If you have edited this file but would like it to be automatically updated
# again, run the following command:
# sudo dpkg-reconfigure -phigh xserver-xorg

Section "Device"
Identifier "Configured Video Device"
Driver "vesa"
EndSection

Section "Monitor"
Identifier "Configured Monitor"
EndSection

Section "Screen"
Identifier "Default Screen"
Monitor "Configured Monitor"
Device "Configured Video Device"
EndSection

2009年1月20日火曜日

C:\Program Files\TortoiseSVN\bin\TortoisePlink.exe -l matsumura -i "C:\Program Files\putty-0.60-JP_Y-2007-08-06\id_rsa.ppk"

2009年1月7日水曜日

C75通販候補

【とらのあなWebSite】霊夢と霧之助が本能のままに動き出す!サークル【自称清純派】の冬コミ新刊が登場です!!

【とらのあなWebSite】美麗な東方イラスト集!TOKIAME先生による冬コミ新刊『Carefree Scribble 葬 Vol.3』がとらのあなWeb通販に遂に登場!

【とらのあなWebSite】人気作品を1冊にまとめた総集編がとらのあなに登場!!お見逃しなく♪

【とらのあなWebSite】弾幕よりも卓を囲んでの闘牌バトル!?サークル【FLIPFLOPs】の冬コミ新刊がとらのあなに登場!

【とらのあなWebSite】サークル【はぽい処】の岡崎武士先生が描く「とらドラ!」本は甘酸っぱい青春の香り!

【とらのあなWebSite】サークル【行脚堂】の『しけー』先生冬コミ最新刊がとらのあなにて好評販売中!!

【とらのあなWebSite】濃密な描写で人気のサークル【SAZ】より、待望の冬コミ新刊が2冊同時発売決定!とらのあなWeb通販に登場!

【とらのあなWebSite】パンツの代わりってコレ?サークル【蛸壺屋】の冬コミ新刊がとらのあなに登場!

【とらのあなWebSite】サークル【堕天】の東方プロジェクト漫画の新作がとらなのあなに登場!東方キャラ達がほのぼのしてます~

[MelonBooks] メロンブックス通信販売

[MelonBooks] メロンブックス通信販売

[MelonBooks] メロンブックス通信販売

[MelonBooks] メロンブックス通信販売

[MelonBooks] メロンブックス通信販売

[MelonBooks] メロンブックス通信販売

2009年1月5日月曜日

ptetexのUbuntuへのインストール。

ptetexをUbuntu 8.04で makeしてたらエラーが。
エラー内容


~中略~
[rewriting] /var/tmp/ptetex3/tetex-src-3.0/texk/pxdvik/configure

[rewriting] /var/tmp/ptetex3/tetex-src-3.0/texk/xdvik/configure

[--tetex--] configure

creating cache ./config.cache

checking whether make sets ${MAKE}... yes

checking for gcc... gcc

checking whether the C compiler (gcc ) works... yes

checking whether the C compiler (gcc ) is a cross-compiler... no

checking whether we are using GNU C... yes

checking whether gcc accepts -g... yes

checking for c++... c++

checking whether the C++ compiler (c++ ) works... yes

checking whether the C++ compiler (c++ ) is a cross-compiler... no

checking whether we are using GNU C++... yes

checking whether c++ accepts -g... yes

checking for flex... lex

checking for yywrap in -ll... no

configure: error: no working lexical scanner (lex/flex) found

make[1]: *** [stage4] エラー 1

make[1]: ディレクトリ `/home/matsumura/ptetex/ptetex3-20080616' から出ます



Those messages are stored in 'log-0105-1010'.



make: *** [all0] エラー 1



コンパイルに必要なソフトが足りなかっただけだった。
解決方法は下記。ちゃんとREADMEを読まなきゃ。


sudo apt-get install build-essential flex bison libxaw7-dev

参考サイト
Foamy Capriccio: Ubuntu 7.10(TeX編)

ウェブブラウザなんかに気を遣わなくてもいい理由 (agenda)

ウェブブラウザなんかに気を遣わなくてもいい理由 (agenda)