4. 在 pgsql.home.net 从 port 安装 postgreSQL 8.4.1
$ su -
$ cd /usr/ports/database/postgres84-server
$ make config
┌─────────────────────┐
│ Options for postgresql-server 8.4.1 │
│ ┌────────────────────────┐ │
│ │[X] NLS Use internationalized messages │ │
│ │[ ] PAM Build with PAM support (server only) │ │
│ │[ ] LDAP Build with LDAP authentication support │ │
│ │[ ] MIT_KRB5 Build with MIT's kerberos support │ │
│ │[ ] HEIMDAL_KRB5 Builds with Heimdal kerberos support │ │
│ │[ ] OPTIMIZED_CFLAGS Builds with compiler optimizations (-O3) │ │
│ │[X] XML Build with XML data type (server) │ │
│ │[X] TZDATA Use internal timezone database (server) │ │
│ │[ ] DEBUG Builds with debugging symbols │ │
│ │[X] INTDATE Builds with 64-bit date/time type (server)│ │
│ │ │ │
$ make
$ make install
$ exit
$ cd /usr/ports/database/postgres84-server
$ make config
┌─────────────────────┐
│ Options for postgresql-server 8.4.1 │
│ ┌────────────────────────┐ │
│ │[X] NLS Use internationalized messages │ │
│ │[ ] PAM Build with PAM support (server only) │ │
│ │[ ] LDAP Build with LDAP authentication support │ │
│ │[ ] MIT_KRB5 Build with MIT's kerberos support │ │
│ │[ ] HEIMDAL_KRB5 Builds with Heimdal kerberos support │ │
│ │[ ] OPTIMIZED_CFLAGS Builds with compiler optimizations (-O3) │ │
│ │[X] XML Build with XML data type (server) │ │
│ │[X] TZDATA Use internal timezone database (server) │ │
│ │[ ] DEBUG Builds with debugging symbols │ │
│ │[X] INTDATE Builds with 64-bit date/time type (server)│ │
│ │ │ │
$ make
$ make install
$ exit
当编译 perl5.10 或 postgres 时，会自动跳进其他套件选项画面，
如 libiconv, m4, libxslt
我个人喜好的选择如下：
┌───────────────────────┐
│ Options for libiconv 1.13.1 │
│ ┌────────────────────────┐ │
│ │ [X] EXTRA_ENCODINGS Include extra character sets │ │
│ │ [X] EXTRA_PATCHES Apply patches to fix CP932 add EUCJP-MS │ │
┌─────────────────────────┐
│ Options for m4 1.4.13,1 │
│ ┌───────────────────────────┐ │
│ │ [X] LIBSIGSEGV Use libsigsegv for better diagnostics │ │
┌─────────────────────────┐
│ Options for libxslt 1.1.26 │
│ ┌────────────────────────────┐ │
│ │ [X] MEM_DEBUG Enable memory debugging │ │
│ │ [X] CRYPTO Enable crypto support for exslt
│ Options for libiconv 1.13.1 │
│ ┌────────────────────────┐ │
│ │ [X] EXTRA_ENCODINGS Include extra character sets │ │
│ │ [X] EXTRA_PATCHES Apply patches to fix CP932 add EUCJP-MS │ │
┌─────────────────────────┐
│ Options for m4 1.4.13,1 │
│ ┌───────────────────────────┐ │
│ │ [X] LIBSIGSEGV Use libsigsegv for better diagnostics │ │
┌─────────────────────────┐
│ Options for libxslt 1.1.26 │
│ ┌────────────────────────────┐ │
│ │ [X] MEM_DEBUG Enable memory debugging │ │
│ │ [X] CRYPTO Enable crypto support for exslt
安装 postgresql-contrib
$ su -
$ cd /usr/ports/databases/postgresql-contrib
$ make
$ make install
$ exit
安装 p5-postgresql-plperl
$ su -
$ cd /usr/ports/databases/p5-postgresql-plperl
$ make
$ make install
$ exit
$ cd /usr/ports/databases/postgresql-contrib
$ make
$ make install
$ exit
安装 p5-postgresql-plperl
$ su -
$ cd /usr/ports/databases/p5-postgresql-plperl
$ make
$ make install
$ exit
