安裝(Installation)‎ > ‎GNU/Linux‎ > ‎

Debian/Ubuntu





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 (相同)
  
Comments