[pgsql-jp: 29861] Re: Windows2000 + Cygwin + PostgreSQL の組み合わせ

[M Tera]

寺口です。

 --- Yutaka tanida <yutaka ＠ hi-net.zaq.ne.jp> からのメッセージ：
> 私も初めて聞く問題なのですが、一度Cygwinの最新版をインストールしてみて
は
> 如何でしょうか？
> 
> # 何か2000側の問題のような気がします。

谷田様の提案に従いまして、Cygwin最新版をインストールしてみました。

$ uname -a
CYGWIN_NT-5.0 TERA-HOME 1.3.22(0.78/3/2) 2003-03-18 09:20 i686 unknown
unknown Cygwin

ipc-daemon, postgreSQL は谷田様の web site (Somethig PostgreSQL) にありま
す
cygipc-1.13.2-patched-bin.tar.bz2
postgresql-7.3.1-cygwin.tar.bz2
をダウンロードさせていただき、インストールしました。

再度 ipc-daemon の起動、データベースの初期化、postmaster の起動を行ったと
ころ

$ ipc-daemon &
[1] 1400

$ initdb -E EUC_JP --no-locale
The files belonging to this database system will be owned by user "root".
This user must also own the server process.

The database cluster will be initialized with locale C.

creating directory /usr/local/pgsql/data... ok
creating directory /usr/local/pgsql/data/base... ok
creating directory /usr/local/pgsql/data/global... ok
creating directory /usr/local/pgsql/data/pg_xlog... ok
creating directory /usr/local/pgsql/data/pg_clog... ok
creating template1 database in /usr/local/pgsql/data/base/1... ok
creating configuration files... ok
initializing pg_shadow... ok
enabling unlimited row size for system tables... ok
initializing pg_depend... ok
creating system views... ok
loading pg_description... ok
creating conversions... ok
setting privileges on built-in objects... ok
vacuuming database template1... ok
copying template1 to template0... ok

Success. You can now start the database server using:

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

$ postmaster -i &
[2] 300
$ LOG:  database system was shut down at 2003-05-13 12:39:20 JST
LOG:  checkpoint record is at 0/83B1A8
LOG:  PGSTATBUFF: recvfrom() failed: Socket operation on non-socket
LOG:  redo record is at 0/83B1A8; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 480; next oid: 16976
LOG:  statistics collector process (pid 1720) exited with exit code 1
LOG:  database system is ready
LOG:  PGSTATBUFF: recvfrom() failed: Socket operation on non-socket
LOG:  statistics collector process (pid 1696) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Socket operation on non-socket
LOG:  statistics collector process (pid 1780) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Socket operation on non-socket
LOG:  statistics collector process (pid 1848) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Socket operation on non-socket
LOG:  statistics collector process (pid 1756) exited with exit code 1
LOG:  PGSTATBUFF: recvfrom() failed: Socket operation on non-socket
LOG:  statistics collector process (pid 1616) exited with exit code 1
..... (以下、プロセスを止めるまで続く)

となり、状況がさらに悪化したように思います。
何か解決策はございますでしょうか？
申し訳ありませんが、よろしくお願いいたします。


__________________________________________________
Do You Yahoo!?
Yahoo! BB is Broadband by Yahoo!
http://bb.yahoo.co.jp/