From 5b1dcdfc6fde3d24f31e5afec5e3d67d11a4e639 Mon Sep 17 00:00:00 2001 From: Palle Girgensohn Date: Wed, 6 Dec 2006 16:50:34 +0000 Subject: Welcome new release of the world's most advanced open source database: PostgreSQL 8.2.0 Complete release notes are available at http://www.postgresql.org/docs/current/static/release-8-2.html --- ...h-src:backend:utils:misc:postgresql.conf.sample | 13 +++- databases/postgresql83-server/files/pgsql.sh.tmpl | 59 ------------------ .../files/pkg-message-client.in | 32 ++++++++++ .../files/pkg-message-contrib.in | 3 + .../files/pkg-message-plperl.in | 3 + .../files/pkg-message-plpython.in | 3 + .../postgresql83-server/files/pkg-message-pltcl.in | 3 + .../files/pkg-message-server.in | 70 ++++++++++++++++++++++ databases/postgresql83-server/files/postgresql.in | 64 ++++++++++++++++++++ 9 files changed, 189 insertions(+), 61 deletions(-) delete mode 100644 databases/postgresql83-server/files/pgsql.sh.tmpl create mode 100644 databases/postgresql83-server/files/pkg-message-client.in create mode 100644 databases/postgresql83-server/files/pkg-message-contrib.in create mode 100644 databases/postgresql83-server/files/pkg-message-plperl.in create mode 100644 databases/postgresql83-server/files/pkg-message-plpython.in create mode 100644 databases/postgresql83-server/files/pkg-message-pltcl.in create mode 100644 databases/postgresql83-server/files/pkg-message-server.in create mode 100644 databases/postgresql83-server/files/postgresql.in (limited to 'databases/postgresql83-server/files') diff --git a/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample index da57f46e3552..7c2831c41be0 100644 --- a/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ b/databases/postgresql83-server/files/patch-src:backend:utils:misc:postgresql.conf.sample @@ -1,5 +1,5 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Tue Nov 8 00:45:49 2005 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 8 00:47:16 2005 +--- src/backend/utils/misc/postgresql.conf.sample.orig Sun May 21 22:11:02 2006 ++++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 7 17:23:50 2006 @@ -206,6 +206,7 @@ # - Where to Log - @@ -16,3 +16,12 @@ #silent_mode = off # DO NOT USE without syslog or # redirect_stderr +@@ -339,6 +341,8 @@ + #--------------------------------------------------------------------------- + # AUTOVACUUM PARAMETERS + #--------------------------------------------------------------------------- ++ ++autovacuum = on + + #autovacuum = off # enable autovacuum subprocess? + #autovacuum_naptime = 60 # time between autovacuum runs, in secs diff --git a/databases/postgresql83-server/files/pgsql.sh.tmpl b/databases/postgresql83-server/files/pgsql.sh.tmpl deleted file mode 100644 index 3456ed3d7282..000000000000 --- a/databases/postgresql83-server/files/pgsql.sh.tmpl +++ /dev/null @@ -1,59 +0,0 @@ -#!/bin/sh - -# $FreeBSD$ -# -# PROVIDE: postgresql -# REQUIRE: LOGIN -# KEYWORD: shutdown -# -# Add the following line to /etc/rc.conf to enable PostgreSQL: -# -# postgresql_enable="YES" -# # optional -# postgresql_data="%%PREFIX%%/pgsql/data" -# postgresql_flags="-w -s -m fast" -# -# This scripts takes one of the following commands: -# -# start stop restart reload status initdb -# -# For postmaster startup options, edit ${postgresql_data}/postgresql.conf - -prefix=%%PREFIX%% -command=${prefix}/bin/pg_ctl - -. %%RC_SUBR%% - -load_rc_config postgresql - -# set defaults -postgresql_enable=${postgresql_enable:-"NO"} -postgresql_flags=${postgresql_flags:-"-w -s -m fast"} -postgresql_user=pgsql -eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data"} -postgresql_class=${postgresql_class:-"default"} - -name=postgresql -rcvar=`set_rcvar` -command_args="-D ${postgresql_data} ${postgresql_flags}" -extra_commands="reload initdb" - -start_cmd="postgresql_command start" -stop_cmd="postgresql_command stop" -restart_cmd="postgresql_command restart" -reload_cmd="postgresql_command reload" -status_cmd="postgresql_command status" - -initdb_cmd="postgresql_initdb" - -postgresql_command() -{ - su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}" -} - -postgresql_initdb() -{ - su -l -c ${postgresql_class} ${postgresql_user} -c "exec ${prefix}/bin/initdb -D ${postgresql_data}" -} - -run_rc_command "$1" diff --git a/databases/postgresql83-server/files/pkg-message-client.in b/databases/postgresql83-server/files/pkg-message-client.in new file mode 100644 index 000000000000..722d50cb4244 --- /dev/null +++ b/databases/postgresql83-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/postgresql83-server/files/pkg-message-contrib.in b/databases/postgresql83-server/files/pkg-message-contrib.in new file mode 100644 index 000000000000..2b29ffd33041 --- /dev/null +++ b/databases/postgresql83-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/postgresql83-server/files/pkg-message-plperl.in b/databases/postgresql83-server/files/pkg-message-plperl.in new file mode 100644 index 000000000000..5d0c83920563 --- /dev/null +++ b/databases/postgresql83-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/postgresql83-server/files/pkg-message-plpython.in b/databases/postgresql83-server/files/pkg-message-plpython.in new file mode 100644 index 000000000000..c413582b6295 --- /dev/null +++ b/databases/postgresql83-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/postgresql83-server/files/pkg-message-pltcl.in b/databases/postgresql83-server/files/pkg-message-pltcl.in new file mode 100644 index 000000000000..0902b858de0b --- /dev/null +++ b/databases/postgresql83-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/postgresql83-server/files/pkg-message-server.in b/databases/postgresql83-server/files/pkg-message-server.in new file mode 100644 index 000000000000..cd6c42ed2090 --- /dev/null +++ b/databases/postgresql83-server/files/pkg-message-server.in @@ -0,0 +1,70 @@ +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. + +The port is set up to use autovacuum for new databases, but you might +also want to vacuum and perhaps backup your database regularly. There +is a periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that +you may find useful. You can use it to backup and perfom vacuum on all +databases nightly. Per default, it perfoms `vacuum analyze'. See the +script for instructions. For autovacuum settings, please review +~pgsql/data/postgresql.conf. + +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. + +Please note that if you use the rc script, +%%PREFIX%%/etc/rc.conf/postgresql, to initialize the database, unicode +(UTF-8) will be used to store character data by default. Set +postgresql_initdb_flags or use login.conf settings described below to +alter this behaviour. See the start rc script for more info. + +To set limits, environment stuff like locale and collation and other +things, you can set up a class in /etc/login.conf before initializing +the database. Add something similar to this to /etc/login.conf: +--- +postgres:\ + :lang=en_US.UTF-8:\ + :setenv=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 logs to syslog by default + 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/postgresql83-server/files/postgresql.in b/databases/postgresql83-server/files/postgresql.in new file mode 100644 index 000000000000..a44c713d6b25 --- /dev/null +++ b/databases/postgresql83-server/files/postgresql.in @@ -0,0 +1,64 @@ +#!/bin/sh + +# $FreeBSD$ +# +# PROVIDE: postgresql +# REQUIRE: LOGIN +# KEYWORD: shutdown +# +# Add the following line to /etc/rc.conf to enable PostgreSQL: +# +# postgresql_enable="YES" +# # optional +# postgresql_data="%%PREFIX%%/pgsql/data" +# postgresql_flags="-w -s -m fast" +# postgresql_initdb_flags="--encoding=utf-8 --lc_collate=C" +# postgresql_class="default" +# +# See %%PREFIX%%/share/doc/postgresql/README-server for more info +# +# This scripts takes one of the following commands: +# +# start stop restart reload status initdb +# +# For postmaster startup options, edit ${postgresql_data}/postgresql.conf + +prefix=%%PREFIX%% +command=${prefix}/bin/pg_ctl + +. %%RC_SUBR%% + +load_rc_config postgresql + +# set defaults +postgresql_enable=${postgresql_enable:-"NO"} +postgresql_flags=${postgresql_flags:-"-w -s -m fast"} +postgresql_user=pgsql +eval postgresql_data=${postgresql_data:-"~${postgresql_user}/data"} +postgresql_class=${postgresql_class:-"default"} +postgresql_initdb_flags=${postgresql_initdb_flags:-"--encoding=utf-8 --lc_collate=C"} + +name=postgresql +rcvar=`set_rcvar` +command_args="-D ${postgresql_data} ${postgresql_flags}" +extra_commands="reload initdb" + +start_cmd="postgresql_command start" +stop_cmd="postgresql_command stop" +restart_cmd="postgresql_command restart" +reload_cmd="postgresql_command reload" +status_cmd="postgresql_command status" + +initdb_cmd="postgresql_initdb" + +postgresql_command() +{ + su -l ${postgresql_user} -c "exec ${command} ${command_args} ${rc_arg}" +} + +postgresql_initdb() +{ + su -l -c ${postgresql_class} ${postgresql_user} -c "exec ${prefix}/bin/initdb -D ${postgresql_data}" +} + +run_rc_command "$1" -- cgit v1.2.3