PostgreSQL 8.1.1 on Solaris10 x86

PostgreSQL 8.1.1 を x86 Solari10 上でビルドしたときの備忘録

1. コンフィグオプションとビルド

> export PATH=/opt/sfw/bin:/usr/sfw/bin:/usr/ccs/bin:${PATH}

> ./configure \
–prefix=/export/postgres \
–with-pam \
–with-openssl \
–enable-nls \
–enable-thread-safety \
–with-includes=/opt/sfw/include:/usr/sfw/include \
–with-libraries=/opt/sfw/lib:/usr/sfw/lib

> make
> make install

2. ユーザ追加

> groupadd -g 70 postgres
> useradd -g 70 -u 70 -d /export/postgres postgres

3. 環境変数設定

> chown postgres:postgres /export/postgres
> vi /export/postgres/.profile

PATH=/usr/css/bin:${PATH}<br /> PATH=/export/postgres/bin:${PATH}<br /> PATH=/usr/sfw/bin:/usr/sfw/sbin:/opt/sfw/bin:/opt/sfw/sbin:${PATH}<br /> export PATH<br /> LD_LIBRARY_PATH=/export/lib:/opt/csw/lib:/opt/sfw/lib:/usr/sfw/lib<br /> export LD_LIBRARY_PATH

4. データベース初期化

> initdb -D /export/postgres/data

5. SMF管理にするための設定 (参考ページ)
> vi /var/svc/manifest/application/postgresql.xml
<?xml version=”1.0″?><br /> <!DOCTYPE service_bundle SYSTEM “/usr/share/lib/xml/dtd/service_bundle.dtd.1”><br /> <service_bundle type=’manifest’ name=’postgresql’><br /> <service<br /> name=’application/postgresql’<br /> type=’service’<br /> version=’1′><br /> <instance name=’postmaster’ enabled=’false’><br /> <exec_method<br /> type=’method’<br /> name=’start’<br /> exec=’su – postgres -c “/export/postgres/bin/pg_ctl start -D /export/postgres/data -l /export/postgres/logfile”‘<br /> timeout_seconds=’60’ /><br /> <exec_method<br /> type=’method’<br /> name=’stop’<br /> exec=’su – postgres -c “/export/postgres/bin/pg_ctl stop -D /export/postgres/data”‘<br /> timeout_seconds=’60’ /><br /> <exec_method<br /> type=’method’<br /> name=’refresh’<br /> exec=’su – postgres -c “/export/postgres/bin/pg_ctl restart -D /export/postgres/data”‘<br /> timeout_seconds=’60’ /><br /> </instance><br /> <stability value=’Unstable’ /><br /> </service><br /> </service_bundle>
> svccfg import /var/svc/manifest/application/postgresql.xml
> svcadm enable postgresql

GentooのPortageがSolaris上でまともに動けば楽なんだけどなぁ・・・・