2007/02/20

PostgreSQLインストールメモ

scorn:~ hisaboh$ port search postgresql
postgresql databases/postgresql 7.4.12 The most advanced open-source database available anywhere
postgresql7 databases/postgresql7 7.4.16 The most advanced open-source database available anywhere
postgresql80 databases/postgresql8 8.0.11 The most advanced open-source database available anywhere
postgresql81 databases/postgresql81 8.1.8 The most advanced open-source database available anywhere
postgresql81-doc databases/postgresql81-doc 8.1.8 Documentation for the postgresql database
postgresql81-server databases/postgresql81-server 8.1.8 run postgresql81 as server
postgresql82 databases/postgresql82 8.2.3 The most advanced open-source database available anywhere
postgresql82-doc databases/postgresql82-doc 8.2.3 Documentation for the postgresql database
postgresql82-server databases/postgresql82-server 8.2.3 run postgresql82 as server
postgresql_autodoc databases/postgresql_autodoc 1.25 Automatic documentation generator for postgresql databases
postgresql-jdbc java/postgresql-jdbc 8.0-311 PostgreSQL JDBC driver
py-postgresql-exception python/py-postgresql-exception 0.2 exceptions for the py-postgresql modules
py-postgresql-greentrunk python/py-postgresql-greentrunk 0.1 greentrunk interface to postgresql
py-postgresql-layout python/py-postgresql-layout 0.3 layout for the py-postgresql modules
py-postgresql-pqueue python/py-postgresql-pqueue 0.1 pure python implementation of the pq protocol
py-postgresql-proboscis python/py-postgresql-proboscis 0.1 postgresql database connector in pure python
scorn:~ hisaboh$ port variants postgresql82
postgresql82 has the variants:
python
krb5
perl
darwin_8
scorn:~ hisaboh$ sudo port install postgresql82 +python +perl
Password:
---> Fetching m4
---> Attempting to fetch m4-1.4.4.tar.bz2 from ftp://ftp.gnu.org/gnu/m4
---> Verifying checksum(s) for m4
---> Extracting m4
---> Configuring m4
---> Building m4 with target all
---> Staging m4 into destroot
---> Installing m4 1.4.4_0
---> Activating m4 1.4.4_0
---> Cleaning m4
---> Fetching bison
---> Attempting to fetch bison-2.3.tar.bz2 from ftp://ftp.gnu.org/gnu/bison
---> Verifying checksum(s) for bison
---> Extracting bison
---> Configuring bison
---> Building bison with target all
---> Staging bison into destroot
---> Installing bison 2.3_0
---> Activating bison 2.3_0
---> Cleaning bison
---> Fetching postgresql82
---> Attempting to fetch postgresql-base-8.2.3.tar.bz2 from ftp://ftp2.ch.postgresql.org/mirror/postgresql/source/v8.2.3
---> Attempting to fetch postgresql-opt-8.2.3.tar.bz2 from ftp://ftp2.ch.postgresql.org/mirror/postgresql/source/v8.2.3
---> Attempting to fetch postgresql-test-8.2.3.tar.bz2 from ftp://ftp2.ch.postgresql.org/mirror/postgresql/source/v8.2.3
---> Verifying checksum(s) for postgresql82
---> Extracting postgresql82
---> Configuring postgresql82
---> Building postgresql82
---> Staging postgresql82 into destroot
---> Installing postgresql82 8.2.3_0+darwin_8+perl+python

To use the postgresql server, install the postgresql82-server port
---> Activating postgresql82 8.2.3_0+darwin_8+perl+python
---> Cleaning postgresql82
scorn:~ hisaboh$ port variants postgresql82-server
postgresql82-server has no variants
scorn:~ hisaboh$ sudo port install postgresql82-server
Password:
---> Fetching postgresql82-server
---> Verifying checksum(s) for postgresql82-server
---> Extracting postgresql82-server
---> Configuring postgresql82-server
---> Building postgresql82-server with target all
---> Staging postgresql82-server into destroot
---> Creating launchd control script
###########################################################
# A startup item has been generated that will aid in
# starting postgresql82-server with launchd. It is disabled
# by default. Execute the following command to start it,
# and to cause it to launch at startup:
#
# sudo launchctl load -w /Library/LaunchDaemons/org.macports.postgresql82-server.plist
###########################################################
---> Installing postgresql82-server 8.2.3_0

To create a database instance, after install do
sudo mkdir -p /opt/local/var/db/postgresql82/defaultdb
sudo chown postgres:postgres /opt/local/var/db/postgresql82/defaultdb
sudo su postgres -c '/opt/local/lib/postgresql82/bin/initdb -D /opt/local/var/db/postgresql82/defaultdb'

To tweak your DBMS, consider increasing kern.sysv.shmmax by adding an increased kern.sysv.shmmax .. to /etc/sysctl.conf
---> Activating postgresql82-server 8.2.3_0
---> Cleaning postgresql82-server
scorn:~ hisaboh$

2007/02/19

MacPortsの継続的なアップデート

$ sudo port selfupdate
$ port outdated
$ sudo port upgrade outdated


MacPorts パッケージの継続的なアップデート方法

2007/02/13

rhaco版WorkStyle1.0リリース

PHPのフレームワークrhacoによる WorkStyle実装をリリースしました。
本当は11日に出していましたが、今日rhaco1.0.1が出たので晴れて利用可能になりました。

http://workstyle.yher.org/

今回はデモがあるので試してみてください。
http://workstyle.yher.org/demo/

バグや要望があったら、こちらにどうぞ。
http://task.yher.org/

2007/02/09

.htaccess Editor

各設定を行うことにより.htaccessを動的に作成するエディタ。
ベーシック認証用の.passwdも作成してくれる。
便利!

http://www.htaccesseditor.com/