[pgsql-jp: 28966] Re: MacOSX でcreatedb のエラー
Yoichi Shimada
yshim ＠ storgate.co.jp
2003年 2月 6日 (木) 20:42:27 JST
島田@Storgate と申します。
2003.02.06, 17:44, Nakamura Kazuto san Wrote;
>中村です。
>あと、現在は 7.3.1 が最新版です。
>
>以下のインストール手順で気になった点は
>$ make check
>を行ってないところでしょうか。
MacOSX の話題、嬉しいです。
最新は 7.3.2 です。 以下ご参照あれ。
7.3.1 の方にはチョットショックかも。。
<http://www.postgresql.org/news.php?NewsID=128>
私の環境
MacOS 10.2.3
$ gcc --version
gcc (GCC) 3.1 20020420 (prerelease)
Copyright (C) 2002 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
$ make --version
GNU Make version 3.79, by Richard Stallman and Roland McGrath.
Built for powerpc-apple-darwin6.0
Copyright (C) 1988, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99
Free Software Foundation, Inc.
This is free software; see the source for copying conditions.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
早速、make , install してみました。
手順は以下の通りです。
<http://developer.apple.com/internet/macosx/postgres.html>
また、configure 時に readline 関連で error がでたので
上記の手順内にあるように "Fink" をインストールし（1時間ほどかかった）
<http://fink.sourceforge.net/news/jag-bootstrap.php>
fink install readline
としてから、再度 configure しました。（パラメータは以下）
そして、 make all と root にて make install
[postgres]% pg_config --configure
'--enable-multibyte' '--enable-syslog' '--with-includes=/sw/include/' '--
with-libraries=/sw/lib'
initdb ....
[postgres]% pg_ctl -D /Volumes/Work/pgsql/data -l logfile start
postmaster successfully started
[postgres] postgres% createdb test1
CREATE DATABASE
[postgres] postgres% psql -l
List of databases
Name | Owner | Encoding
-----------+----------+-----------
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
test1 | postgres | SQL_ASCII
(3 rows)
とりあえず、動いている。
以下、regression test の実行。チョット長いのですがあしからず。
make install する前に、一度 make check とすべきですが、
さぼってしまったので、
[postgres] % make installcheck
make -C src/test installcheck
make -C regress installcheck
sed -e 's, ＠ bindir@,/usr/local/pgsql/bin,g' \
-e 's, ＠ libdir@,/usr/local/pgsql/lib,g' \
-e 's, ＠ pkglibdir@,/usr/local/pgsql/lib,g' \
-e 's, ＠ datadir@,/usr/local/pgsql/share,g' \
-e 's/@VERSION@/7.3.2/g' \
-e 's/@host_tuple@/powerpc-apple-darwin6.3/g' \
-e 's, ＠ GMAKE@,make,g' \
-e 's/@enable_shared@/yes/g' \
-e 's/@GCC@/yes/g' \
pg_regress.sh >pg_regress
--snip--
gcc -traditional-cpp -flat_namespace -bundle -undefined suppress -o
autoinc.so autoinc.o
rm refint.o autoinc.o
/bin/sh ./pg_regress --schedule=./serial_schedule --multibyte=SQL_ASCII
(using postmaster on Unix socket, default port)
============== dropping database "regression" ==============
ERROR: DROP DATABASE: database "regression" does not exist
dropdb: database removal failed
============== creating database "regression" ==============
CREATE DATABASE
ALTER DATABASE
============== dropping regression test user accounts ==============
============== installing PL/pgSQL ==============
============== running regression test queries ==============
test boolean ... ok
test char ... ok
test name ... ok
test varchar ... ok
test text ... ok
test int2 ... ok
test int4 ... ok
test int8 ... ok
test oid ... ok
test float4 ... ok
test float8 ... ok
test bit ... ok
test numeric ... ok
test strings ... ok
test numerology ... ok
test point ... ok
test lseg ... ok
test box ... ok
test path ... ok
test polygon ... ok
test circle ... ok
test date ... ok
test time ... ok
test timetz ... ok
test timestamp ... ok
test timestamptz ... ok
test interval ... ok
test abstime ... ok
test reltime ... ok
test tinterval ... ok
test inet ... ok
test comments ... ok
test oidjoins ... ok
test type_sanity ... ok
test opr_sanity ... ok
test geometry ... ok
test horology ... ok
test insert ... ok
test create_function_1 ... ok
test create_type ... ok
test create_table ... ok
test create_function_2 ... ok
test copy ... ok
test constraints ... ok
test triggers ... ok
test create_misc ... ok
test create_aggregate ... ok
test create_operator ... ok
test create_index ... ok
test inherit ... ok
test vacuum ... ok
test create_view ... ok
test sanity_check ... ok
test errors ... ok
test select ... ok
test select_into ... ok
test select_distinct ... ok
test select_distinct_on ... ok
test select_implicit ... ok
test select_having ... ok
test subselect ... ok
test union ... ok
test case ... ok
test join ... ok
test aggregates ... ok
test transactions ... ok
test random ... ok
test portals ... ok
test arrays ... ok
test btree_index ... ok
test hash_index ... ok
test privileges ... ok
test misc ... ok
test select_views ... ok
test portals_p2 ... ok
test rules ... ok
test foreign_key ... ok
test cluster ... ok
test limit ... ok
test plpgsql ... ok
test copy2 ... ok
test temp ... ok
test domain ... ok
test rangefuncs ... ok
test prepare ... ok
test without_oid ... ok
test conversion ... ok
test truncate ... ok
test alter_table ... ok
======================
All 89 tests passed.
======================
rm regress.o
---------------------------------
Storgate Co., LTD, Japan
http://www.storgate.co.jp
---------------------------------
pgsql-jp メーリングリストの案内