Ubuntu 9.04 套件
p postgresql - object-relational SQL database (supported version)
i postgresql-8.3 - object-relational SQL database, version 8.3 server p postgresql-8.3-ip4r - IPv4 and IPv4 range index types for PostgreSQL 8.3
p postgresql-8.3-orafce - Oracle support functions for PostgreSQL
v postgresql-8.3-pljava -
p postgresql-8.3-pljava-gcj - Java procedural language for PostgreSQL
p postgresql-8.3-pllua - Lua procedural language for PostgreSQL
p postgresql-8.3-plproxy - PL/Proxy is a proxy language used for remote database
p postgresql-8.3-plr - Procedural language interface between PostgreSQL 8.3 and R
p postgresql-8.3-plruby - Ruby procedural language for PostgreSQL
p postgresql-8.3-plsh - PL/sh procedural language for PostgreSQL 8.3
p postgresql-8.3-postgis - geographic objects support for PostgreSQL 8.3
p postgresql-8.3-prefix - Prefix Range module for PostgreSQL
p postgresql-8.3-slony1 - replication system for PostgreSQL
p postgresql-autodoc - Utility to create a PostgreSQL database schema overview in HTML, DOT an
p postgresql-client - front-end programs for PostgreSQL (supported version)
i A postgresql-client-8.3 - front-end programs for PostgreSQL 8.3
i A postgresql-client-common - manager for multiple PostgreSQL client versions
i A postgresql-common - PostgreSQL database-cluster manager p postgresql-contrib - additional facilities for PostgreSQL (supported version)
p postgresql-contrib-8.3 - additional facilities for PostgreSQL
p postgresql-doc - documentation for the PostgreSQL database management system
p postgresql-doc-8.3 - documentation for the PostgreSQL database management system
p postgresql-filedump-8.3 - Utility to format PostgreSQL files
p postgresql-plperl-8.3 - PL/Perl procedural language for PostgreSQL 8.3
p postgresql-plpython-8.3 - PL/Python procedural language for PostgreSQL 8.3
v postgresql-plr -
p postgresql-pltcl-8.3 - PL/Tcl procedural language for PostgreSQL 8.3
p postgresql-server-dev-8.3 - development files for PostgreSQL 8.3 server-side programming
Kernel 選項的調整
Linux
缺省設置只適合小安裝(缺省最大共享內存是 32MB)。不過,其它的缺省值都相當大,通常不需要改變。最大的共享內存段設置可以用 sysctl 接口設置。比如,要允許 128MB ,並且最大的總共享內存數為 2097152 頁(缺省):
$ sysctl -w kernel.shmmax=134217728
$ sysctl -w kernel.shmall=2097152
你可以把這些設置放到 /etc/sysctl.conf 裡,在重啟後保持有效。
老版本裡可能沒有 sysctl 程序,但是同樣的改變可以通過操作 /proc 文件系統來做:
$ echo 134217728 >/proc/sys/kernel/shmmax
$ echo 2097152 >/proc/sys/kernel/shmall
Ubuntu 9.04
$ echo 134217728 >/proc/sys/kernel/shmmax (原為: 33554432)
$ echo 2097152 >/proc/sys/kernel/shmall (相同)