• 丰搜首页
• 文档中心
• 视频中心
• 丰搜贴吧
• 问题集锦
• 更多功能

选择显示字体大小

• 最大
• 较大
• 标准

postgresql 7.4.6

postgresql 7.4.6 post-install-notes

the postgresql port has a collection of "side orders":

postgresql-doc
for all of the html documentation

p5-pg
a perl5 api for client access to postgresql databases.

postgresql-tcltk
if you want tcl/tk client support.

postgresql-jdbc
for java jdbc support.

postgresql-odbc
for client access from unix applications using odbc as access
method. not needed to access unix postgresql servers from win32
using odbc. see below.

ruby-postgres, py-pygresql
for client access to postgresql databases using the ruby & python
languages.

p5-postgresql-plperl, postgresql-pltcl & postgresql-plruby
for using perl5, tcl & ruby as procedural languages.

postgresql-contrib
lots of contributed utilities, postgresql functions and
datatypes. there you find autovacuum, pgcrypto and many other cool
things.

etc etc...

for procedural languages and postgresql functions, please note that
you might have to update them when updating the server. for example,
the "elog" method disappeared in postgresql-7.4, so postgresql-contrib
must be updated along with the server.

if you have many tables and many clients running, consider raising
kern.maxfiles using sysctl(8), or reconfigure your kernel
appropriately.

you should vacuum and backup your database regularly. there is a
periodic script, /usr/local/share/postgresql/502.pgsql, that you may
find useful.

to allow many simultaneous connections to your postgresql server, you
should raise the systemv shared memory limits in your kernel. here are
example values for allowing up to 180 clients (tinkering in
postgresql.conf also needed, of course):
options sysvshm
options sysvsem
options sysvmsg
options shmmaxpgs=65536
options semmni=40
options semmns=240
options semume=40
options semmnu=120

if you plan to access your postgresql server using odbc, please
consider running the sql script /usr/local/share/postgresql/odbc.sql
to get the functions required for odbc compliance.
======================================================================

to initialize the database, you should run initdb as the "pgsql" user