diff options
Diffstat (limited to 'databases/postgresql80-server/files')
| -rw-r--r-- | databases/postgresql80-server/files/pkg-message-client.in | 32 | ||||
| -rw-r--r-- | databases/postgresql80-server/files/pkg-message-contrib.in | 3 | ||||
| -rw-r--r-- | databases/postgresql80-server/files/pkg-message-plperl.in | 3 | ||||
| -rw-r--r-- | databases/postgresql80-server/files/pkg-message-plpython.in | 3 | ||||
| -rw-r--r-- | databases/postgresql80-server/files/pkg-message-pltcl.in | 3 | ||||
| -rw-r--r-- | databases/postgresql80-server/files/pkg-message-server.in | 61 | ||||
| -rw-r--r-- | databases/postgresql80-server/files/postgresql.in (renamed from databases/postgresql80-server/files/pgsql.sh.tmpl) | 0 |
7 files changed, 105 insertions, 0 deletions
diff --git a/databases/postgresql80-server/files/pkg-message-client.in b/databases/postgresql80-server/files/pkg-message-client.in new file mode 100644 index 000000000000..722d50cb4244 --- /dev/null +++ b/databases/postgresql80-server/files/pkg-message-client.in @@ -0,0 +1,32 @@ +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... diff --git a/databases/postgresql80-server/files/pkg-message-contrib.in b/databases/postgresql80-server/files/pkg-message-contrib.in new file mode 100644 index 000000000000..2b29ffd33041 --- /dev/null +++ b/databases/postgresql80-server/files/pkg-message-contrib.in @@ -0,0 +1,3 @@ +The PostgreSQL contrib utilities have been installed. Please see +%%PREFIX%%/share/doc/postgresql/contrib/README +for more information. diff --git a/databases/postgresql80-server/files/pkg-message-plperl.in b/databases/postgresql80-server/files/pkg-message-plperl.in new file mode 100644 index 000000000000..5d0c83920563 --- /dev/null +++ b/databases/postgresql80-server/files/pkg-message-plperl.in @@ -0,0 +1,3 @@ +PL/Perl has been installed. Check the createlang(l) manpage for more +info. You can install PL/Perl as trusted or untrusted, by using either +"createlang plperl" or "createlang plperlu". diff --git a/databases/postgresql80-server/files/pkg-message-plpython.in b/databases/postgresql80-server/files/pkg-message-plpython.in new file mode 100644 index 000000000000..c413582b6295 --- /dev/null +++ b/databases/postgresql80-server/files/pkg-message-plpython.in @@ -0,0 +1,3 @@ +PL/Python has been installed. Check the createlang(l) manpage for more +info. You can install PL/Python by using "createlang plpythonu" (it +exists as an untrusted language only). diff --git a/databases/postgresql80-server/files/pkg-message-pltcl.in b/databases/postgresql80-server/files/pkg-message-pltcl.in new file mode 100644 index 000000000000..0902b858de0b --- /dev/null +++ b/databases/postgresql80-server/files/pkg-message-pltcl.in @@ -0,0 +1,3 @@ +PL/Tcl has been installed. Check the createlang(l) manpage for more +info. You can install pltcl as trusted or untrusted, by using either +"createlang pltcl" or "createlang pltclu". diff --git a/databases/postgresql80-server/files/pkg-message-server.in b/databases/postgresql80-server/files/pkg-message-server.in new file mode 100644 index 000000000000..88c35ccff457 --- /dev/null +++ b/databases/postgresql80-server/files/pkg-message-server.in @@ -0,0 +1,61 @@ +For procedural languages and postgresql functions, please note that +you might have to update them when updating 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, %%PREFIX%%/etc/periodic/daily/502.pgsql, that you +may find useful. Per default, it perfoms vacuum on all databases +nightly. See the script for instructions. + +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 (configurations 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 %%PREFIX%%/share/postgresql/odbc.sql +to get the functions required for ODBC compliance. + +If you need to store any characters besides strict ASCII in your +database, you will want to set a character set, and possibly a +collation locale, before initializing the database. Add something +similar to this to /etc/login.conf: +--- +postgres:\ + :setenv=LC_ALL=en_US.UTF-8,LC_COLLATE=C:\ + :tc=default: +--- +and run `cap_mkdb /etc/login.conf'. +Then add 'postgresql_class="postgres"' to /etc/rc.conf. + +====================================================================== + +To initialize the database, run + + %%PREFIX%%/etc/rc.d/postgresql initdb + +You can then start PostgreSQL by running: + + %%PREFIX%%/etc/rc.d/postgresql start + +For postmaster settings, see ~pgsql/data/postgresql.conf + +NB. FreeBSD's PostgreSQL port now by default logs to syslog + See ~pgsql/data/postgresql.conf for more info + +====================================================================== + +To run PostgreSQL at startup, add +'postgresql_enable="YES"' to /etc/rc.conf + diff --git a/databases/postgresql80-server/files/pgsql.sh.tmpl b/databases/postgresql80-server/files/postgresql.in index d3014f580dc0..d3014f580dc0 100644 --- a/databases/postgresql80-server/files/pgsql.sh.tmpl +++ b/databases/postgresql80-server/files/postgresql.in |
