diff options
| author | Vanilla I. Shu <vanilla@FreeBSD.org> | 2002-02-19 08:23:22 +0000 | 
|---|---|---|
| committer | Vanilla I. Shu <vanilla@FreeBSD.org> | 2002-02-19 08:23:22 +0000 | 
| commit | 0c0bcdc10ba6c2d0bbf6c831f5bc05a32470a2e7 (patch) | |
| tree | e2c20382071c1aac790898564dea14a5b332a404 /databases/postgresql80-server/files/post-install-notes | |
| parent | APP_TITLE was set twice. (diff) | |
Upgrade to 7.2, and spilit into several ports.
PR:		ports/34855
Submitted by:	maintainer.
Diffstat (limited to 'databases/postgresql80-server/files/post-install-notes')
| -rw-r--r-- | databases/postgresql80-server/files/post-install-notes | 54 | 
1 files changed, 39 insertions, 15 deletions
diff --git a/databases/postgresql80-server/files/post-install-notes b/databases/postgresql80-server/files/post-install-notes index 9347fc51c247..5480550a1ed4 100644 --- a/databases/postgresql80-server/files/post-install-notes +++ b/databases/postgresql80-server/files/post-install-notes @@ -1,25 +1,49 @@ +The PostgreSQL port has a collection of "side orders": -Now that PostgreSQL is installed, you should read the documentation and -implementation guides. These can be found at: +p5-Pg +  A perl5 API for client access to PostgreSQL databases. -		http://www.PostgreSQL.org/docs +postgresql-tcltk  +  If you want tcl/tk client support. You get a neat GUI, pgaccess, as +  a bonus! -You may wish to subscribe to the PostgreSQL user-support mailing list. -Send an e-mail to pgsql-questions-request@postgresql.org with the -text "subscribe" in the message body. +postgresql-jdbc +  For Java JDBC support. -If you built PostgreSQL with TCL/TK support, you can use the pgaccess -utility to get a TCL/TK based database frontend for database -operations. You do NOT need to install the pgaccess port separately. +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. -If you built in the TCL support, you can load the Pg package into your -TCL scripts as easily as ``package require Pgtcl''. +ruby-postgres, py-PyGreSQL +  For client access to PostgreSQL databases using the ruby & python +  languages. -If you built with Java support, add -/usr/local/share/java/classes/postgresql.jar to your classpath. +postgresql-plperl, postgresql-pltcl & postgresql-plruby +  For using perl5, tcl & ruby as procedural languages. + +etc etc...  If you have many tables and many clients running, consider raising  kern.maxfiles using sysctl(8). -Use createlang(1) to install languages into your database. -Supported languages are 'plpgsql', 'pltcl', 'pltclu', and 'plperl'. +You should vacuum and backup your database regularly. There is a +periodic script, /usr/local/share/postgresql/502.pgsql, that you may +use. + +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.  | 
