[hackers-jp: 176] 8.0.0beta5, MacOSX 10.3.6

[Y.Shimada]

島田@Storgateです。

　久しぶりに harckers を見たら 8.0.0beta5 が出たと。。
少し気分転換で試してみました。

[postgres ＠ StgG5 postgresql-8.0.0beta5]$ uname -prsm
Darwin 7.6.0 Power Macintosh powerpc
[postgres ＠ StgG5 postgresql-8.0.0beta5]$ gcc --version
gcc (GCC) 3.3 20030304 (Apple Computer, Inc. build 1666)
Copyright (C) 2002 Free Software Foundation, Inc.


[postgres ＠ StgG5 postgresql]$ tar zxf /Volumes/Wk1/postgresql/archives/
postgresql-8.0.0beta5.tar.gz 
[postgres ＠ StgG5 postgresql-8.0.0beta5]$cd postgresql-8.0.0beta5/
    以下２行は、私の環境依存（readline をそこにおいているため）
    [postgres ＠ StgG5 postgresql-8.0.0beta5]$ export LDFLAGS=-L/sw/lib
    [postgres ＠ StgG5 postgresql-8.0.0beta5]$ export CPPFLAGS=-I/sw/include/

[postgres ＠ StgG5 postgresql-8.0.0beta5]$ ./configure --prefix /Volumes/
Wk1/postgresql/pg800b5
[postgres ＠ StgG5 postgresql-8.0.0beta5]$ make
[postgres ＠ StgG5 postgresql-8.0.0beta5]$ make install

異常なし。
そこで、postmaster 起動　(TCP/IP 接続)

[postgres ＠ StgG5 postgresql-8.0.0beta5]$ export PGDATA=/Volumes/Wk1/
postgresql/pg800b5/pg8db
[postgres ＠ StgG5 postgresql-8.0.0beta5]$ /Volumes/Wk1/postgresql/pg800b5/
bin/initdb --no-locale
[postgres ＠ StgG5 postgresql-8.0.0beta5]$ /Volumes/Wk1/postgresql/pg800b5/
bin/pg_ctl -o"-i" -l logfile start
postmaster starting
LOG:  database system was shut down at 2004-11-23 10:55:11 JST
LOG:  checkpoint record is at 0/A46450
LOG:  redo record is at 0/A46450; undo record is at 0/0; shutdown TRUE
LOG:  next transaction ID: 492; next OID: 17230
LOG:  database system is ready
[postgres ＠ StgG5 postgresql-8.0.0beta5]$ ps -ax|grep post
  368  ??  Ss     0:00.00 /usr/sbin/postfix-watch
29212 std  S      0:00.16 /Volumes/Wk1/postgresql/pg800b5/bin/postmaster
29215 std  S      0:00.00 postgres: writer process                      
      
29216 std  S      0:00.01 postgres: stats buffer process                
      
29217 std  S      0:00.01 postgres: stats collector process             
      
29228 std  S+     0:00.00 grep post
[postgres ＠ StgG5 postgresql-8.0.0beta5]$  

OK、チャンと background writer が動いている。
では、regression test はっと

[postgres ＠ StgG5 postgresql-8.0.0beta5]$ cd src/test/regress/
[postgres ＠ StgG5 regress]$ export PGHOST=localhost
[postgres ＠ StgG5 regress]$ /Volumes/Wk1/postgresql/pg800b5/bin/psql -l
       List of databases
    Name    |  Owner   | Encoding  
------------+----------+-----------
 template0  | postgres | SQL_ASCII
 template1  | postgres | SQL_ASCII
(3 rows)

[postgres ＠ StgG5 regress]$ 

[postgres ＠ StgG5 regress]$ time make installcheck
make -C ../../../contrib/spi refint.so autoinc.so
make[1]: `refint.so' is up to date.
make[1]: `autoinc.so' is up to date.
rm -rf ./testtablespace
mkdir ./testtablespace
/bin/sh ./pg_regress --schedule=./serial_schedule --multibyte=SQL_ASCII
(using postmaster on localhost, default port)
============== dropping database "regression"         ==============
dropdb: database removal failed: ERROR:  database "regression" does not exist
============== creating database "regression"         ==============
CREATE DATABASE
============== dropping regression test user accounts ==============
============== installing PL/pgSQL                    ==============
============== running regression test queries        ==============
test boolean              ... ok
test char                 ... ok
ーー省略ーー
test stats                ... ok
test tablespace           ... ok

======================
 All 96 tests passed. 
======================


real    0m48.684s
user    0m3.110s
sys     0m4.850s
[postgres ＠ StgG5 regress]$  

全部パス。
そこで、定番の

[postgres ＠ StgG5 regress]$ cd ../../../contrib/pgbench/
[postgres ＠ StgG5 regress]$ make
[postgres ＠ StgG5 regress]$ /Volumes/Wk1/postgresql/pg800b5/bin/createdb pgbench
CREATE DATABASE
[postgres ＠ StgG5 regress]$ time ./pgbench -i -s 10 pgbench
creating tables...
10000 tuples done.
vacuum...done.
ーー省略ーー
real    0m47.073s
user    0m2.420s
sys     0m1.440s
[postgres ＠ StgG5 regress]$ ./pgbench -c 32 -t 64 -s 10 pgbench
starting vacuum...end.
transaction type: TPC-B (sort of)
scaling factor: 10
number of clients: 32
number of transactions per client: 64
number of transactions actually processed: 2048/2048
tps = 41.318114 (including connections establishing)
tps = 41.965248 (excluding connections establishing)
[postgres ＠ StgG5 regress]$

以上。。