summaryrefslogtreecommitdiff
path: root/databases/postgresql91-server/files
diff options
context:
space:
mode:
authorcvs2svn <cvs2svn@FreeBSD.org>2011-02-11 03:06:03 +0000
committercvs2svn <cvs2svn@FreeBSD.org>2011-02-11 03:06:03 +0000
commitb36e665e56175a7588102bec06e2ac62ffff3b5e (patch)
treed8c04c2dd9d515238e6ff20e97948fc22f7f82be /databases/postgresql91-server/files
parent- Update to 1.16.2 (diff)
This commit was manufactured by cvs2svn to create tag 'RELEASE_8_2_0'.release/8.2.0
Notes
Notes: svn path=/head/; revision=268906 svn path=/tags/RELEASE_8_2_0/; revision=268908; tag=release/8.2.0
Diffstat (limited to 'databases/postgresql91-server/files')
-rw-r--r--databases/postgresql91-server/files/502.pgsql112
-rw-r--r--databases/postgresql91-server/files/dot.cshrc.in11
-rw-r--r--databases/postgresql91-server/files/dot.profile.in22
-rw-r--r--databases/postgresql91-server/files/extra-patch-icu446
-rw-r--r--databases/postgresql91-server/files/patch-doc-Makefile28
-rw-r--r--databases/postgresql91-server/files/patch-plpython-Makefile11
-rw-r--r--databases/postgresql91-server/files/patch-src-backend-Makefile11
-rw-r--r--databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample28
-rw-r--r--databases/postgresql91-server/files/pkg-message-client.in32
-rw-r--r--databases/postgresql91-server/files/pkg-message-contrib.in3
-rw-r--r--databases/postgresql91-server/files/pkg-message-plperl.in3
-rw-r--r--databases/postgresql91-server/files/pkg-message-plpython.in3
-rw-r--r--databases/postgresql91-server/files/pkg-message-pltcl.in3
-rw-r--r--databases/postgresql91-server/files/pkg-message-server.in70
-rw-r--r--databases/postgresql91-server/files/pkgIndex.tcl.in4
-rw-r--r--databases/postgresql91-server/files/postgresql.in63
16 files changed, 0 insertions, 450 deletions
diff --git a/databases/postgresql91-server/files/502.pgsql b/databases/postgresql91-server/files/502.pgsql
deleted file mode 100644
index 281189a59c46..000000000000
--- a/databases/postgresql91-server/files/502.pgsql
+++ /dev/null
@@ -1,112 +0,0 @@
-#!/bin/sh
-#
-# $FreeBSD$
-#
-# Maintenance shell script to vacuum and backup database
-# Put this in /usr/local/etc/periodic/daily, and it will be run
-# every night
-#
-# Written by Palle Girgensohn <girgen@pingpong.net>
-#
-# In public domain, do what you like with it,
-# and use it at your own risk... :)
-#
-
-# Define these variables in either /etc/periodic.conf or
-# /etc/periodic.conf.local to override the default values.
-#
-# daily_pgsql_backup_enable="YES" # do backup of all databases
-# daily_pgsql_backup_enable="foo bar db1 db2" # only do backup of a limited selection of databases
-# daily_pgsql_vacuum_enable="YES" # do vacuum
-
-daily_pgsql_vacuum_args="-z"
-daily_pgsql_pgdump_args="-b -F c"
-# backupdir is relative to ~pgsql home directory unless it begins with a slash:
-daily_pgsql_backupdir="~pgsql/backups"
-daily_pgsql_savedays="7"
-
-# If there is a global system configuration file, suck it in.
-#
-if [ -r /etc/defaults/periodic.conf ]
-then
- . /etc/defaults/periodic.conf
- source_periodic_confs
-fi
-
-# allow '~´ in dir name
-eval backupdir=${daily_pgsql_backupdir}
-
-rc=0
-
-pgsql_backup() {
- # daily_pgsql_backupdir must be writeable by user pgsql
- # ~pgsql is just that under normal circumstances,
- # but this might not be where you want the backups...
- if [ ! -d ${backupdir} ] ; then
- echo Creating ${backupdir}
- mkdir -m 700 ${backupdir}; chown pgsql ${backupdir}
- fi
-
- echo
- echo "PostgreSQL backups"
-
- # Protect the data
- umask 077
- rc=$?
- now=`date "+%Y-%m-%dT%H:%M:%S"`
- file=${daily_pgsql_backupdir}/pgglobals_${now}
- su -l pgsql -c "umask 077; pg_dumpall -g | gzip -9 > ${file}.gz"
-
- db=$1
- while shift; do
- echo -n " $db"
- file=${backupdir}/pgdump_${db}_${now}
- su -l pgsql -c "umask 077; pg_dump ${daily_pgsql_pgdump_args} -f ${file} ${db}"
- [ $? -gt 0 ] && rc=3
- db=$1
- done
-
- if [ $rc -gt 0 ]; then
- echo
- echo "Errors were reported during backup."
- fi
-
- # cleaning up old data
- find ${backupdir} \( -name 'pgdump_*' -o -name 'pgglobals_*' \) \
- -a -mtime +${daily_pgsql_savedays} -delete
- echo
-}
-
-case "$daily_pgsql_backup_enable" in
- [Yy][Ee][Ss])
- dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"`
- pgsql_backup $dbnames
- ;;
-
- [Nn][Oo])
- ;;
-
- "")
- ;;
-
- *)
- pgsql_backup $daily_pgsql_backup_enable
- ;;
-esac
-
-case "$daily_pgsql_vacuum_enable" in
- [Yy][Ee][Ss])
-
- echo
- echo "PostgreSQL vacuum"
- su -l pgsql -c "vacuumdb -a -q ${daily_pgsql_vacuum_args}"
- if [ $? -gt 0 ]
- then
- echo
- echo "Errors were reported during vacuum."
- rc=3
- fi
- ;;
-esac
-
-exit $rc
diff --git a/databases/postgresql91-server/files/dot.cshrc.in b/databases/postgresql91-server/files/dot.cshrc.in
deleted file mode 100644
index 4069398b376e..000000000000
--- a/databases/postgresql91-server/files/dot.cshrc.in
+++ /dev/null
@@ -1,11 +0,0 @@
-setenv PGLIB %%PREFIX%%/lib
-
-# note: PGDATA can be overridden by the -D startup option
-setenv PGDATA $HOME/data
-
-#You might want to set some locale stuff here
-#setenv PGDATESTYLE ISO
-#setenv LC_ALL sv_SE.ISO_8859-1
-
-# if you want to make regression tests use this TZ
-#setenv TZ PST8PDT
diff --git a/databases/postgresql91-server/files/dot.profile.in b/databases/postgresql91-server/files/dot.profile.in
deleted file mode 100644
index 954e22eae8f8..000000000000
--- a/databases/postgresql91-server/files/dot.profile.in
+++ /dev/null
@@ -1,22 +0,0 @@
-PGLIB=%%PREFIX%%/lib
-
-# note: PGDATA can be overridden by the -D startup option
-PGDATA=${HOME}/data
-
-export PATH PGLIB PGDATA
-
-# if you use the periodic script from share/postgresql/502.pgsql, you
-# can set these
-#PGDUMP_ARGS="-b -F c"
-#PGBACKUPDIR=${HOME}/backups
-#PGBACKUP_SAVE_DAYS=7
-#export PGBACKUPDIR PGDUMP_ARGS PGBACKUP_SAVE_DAYS
-
-#You might want to set some locale stuff here
-#PGDATESTYLE=ISO
-#LC_ALL=sv_SE.ISO_8859-1
-#export PGDATESTYLE LC_ALL
-
-# if you want to make regression tests use this TZ
-#TZ=PST8PDT
-#export TZ
diff --git a/databases/postgresql91-server/files/extra-patch-icu4 b/databases/postgresql91-server/files/extra-patch-icu4
deleted file mode 100644
index bf28a732a2bd..000000000000
--- a/databases/postgresql91-server/files/extra-patch-icu4
+++ /dev/null
@@ -1,46 +0,0 @@
---- configure.in.orig 2010-12-17 10:24:25.585364941 +0100
-+++ configure.in 2010-12-17 10:25:08.921592644 +0100
-@@ -947,23 +947,27 @@
- fi
-
- if test "$with_icu" = yes ; then
-- AC_CHECK_LIB(icui18n, ucol_open_44, [], [
-- AC_CHECK_LIB(icui18n, ucol_open_43, [], [
-- AC_CHECK_LIB(icui18n, ucol_open_3_8, [], [
-- AC_CHECK_LIB(icui18n, ucol_open_3_6, [], [
-- AC_CHECK_LIB(icui18n, ucol_open_3_4, [], [AC_MSG_ERROR([library 'icui18n' is required for ICU])])
-- ])
-- ])
-- ])
-+ AC_CHECK_LIB(icui18n, ucol_open_46, [], [
-+ AC_CHECK_LIB(icui18n, ucol_open_44, [], [
-+ AC_CHECK_LIB(icui18n, ucol_open_43, [], [
-+ AC_CHECK_LIB(icui18n, ucol_open_3_8, [], [
-+ AC_CHECK_LIB(icui18n, ucol_open_3_6, [], [
-+ AC_CHECK_LIB(icui18n, ucol_open_3_4, [], [AC_MSG_ERROR([library 'icui18n' is required for ICU])])
-+ ])
-+ ])
-+ ])
-+ ])
- ])
-- AC_CHECK_LIB(icuuc, ucnv_fromUChars_44, [], [
-- AC_CHECK_LIB(icuuc, ucnv_fromUChars_43, [], [
-- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_8, [], [
-- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_6, [], [
-- AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_4, [], [AC_MSG_ERROR([library 'icuuc' is required for ICU])])
-- ])
-- ])
-- ])
-+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_46, [], [
-+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_44, [], [
-+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_43, [], [
-+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_8, [], [
-+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_6, [], [
-+ AC_CHECK_LIB(icuuc, ucnv_fromUChars_3_4, [], [AC_MSG_ERROR([library 'icuuc' is required for ICU])])
-+ ])
-+ ])
-+ ])
-+ ])
- ])
- fi
-
diff --git a/databases/postgresql91-server/files/patch-doc-Makefile b/databases/postgresql91-server/files/patch-doc-Makefile
deleted file mode 100644
index a366d4ca2620..000000000000
--- a/databases/postgresql91-server/files/patch-doc-Makefile
+++ /dev/null
@@ -1,28 +0,0 @@
---- doc/src/sgml/Makefile.orig 2010-06-12 23:40:31.000000000 +0200
-+++ doc/src/sgml/Makefile 2010-09-19 22:07:11.210759927 +0200
-@@ -15,14 +15,14 @@
-
- # Make "html" the default target, since that is what most people tend
- # to want to use.
--html:
-+man:
-
- subdir = doc/src/sgml
- top_builddir = ../../..
- include $(top_builddir)/src/Makefile.global
-
-
--all: html man
-+all: man
-
- distprep: html distprep-man
-
-@@ -285,7 +285,7 @@
- ## Install
- ##
-
--install: install-html
-+##install: install-html
-
- ifneq ($(PORTNAME), sco)
- install: install-man
diff --git a/databases/postgresql91-server/files/patch-plpython-Makefile b/databases/postgresql91-server/files/patch-plpython-Makefile
deleted file mode 100644
index 3357b699da8a..000000000000
--- a/databases/postgresql91-server/files/patch-plpython-Makefile
+++ /dev/null
@@ -1,11 +0,0 @@
---- src/pl/plpython/Makefile.orig Fri Nov 19 20:23:01 2004
-+++ src/pl/plpython/Makefile Tue Dec 28 23:32:16 2004
-@@ -9,7 +9,7 @@
- # shared library. Since there is no official way to determine this
- # (at least not in pre-2.3 Python), we see if there is a file that is
- # named like a shared library.
--ifneq (,$(wildcard $(python_libdir)/libpython*$(DLSUFFIX)*))
-+ifneq (,$(wildcard $(python_libdir)/../../libpython*$(DLSUFFIX)*))
- shared_libpython = yes
- endif
-
diff --git a/databases/postgresql91-server/files/patch-src-backend-Makefile b/databases/postgresql91-server/files/patch-src-backend-Makefile
deleted file mode 100644
index 6d6fb0ce660b..000000000000
--- a/databases/postgresql91-server/files/patch-src-backend-Makefile
+++ /dev/null
@@ -1,11 +0,0 @@
---- src/backend/Makefile.orig 2009-07-07 15:58:33.000000000 +0200
-+++ src/backend/Makefile 2009-07-07 15:58:57.000000000 +0200
-@@ -107,6 +107,8 @@
- # Update the commonly used headers before building the subdirectories
- $(SUBDIRS:%=%-recursive): $(top_builddir)/src/include/parser/gram.h $(top_builddir)/src/include/utils/fmgroids.h $(top_builddir)/src/include/utils/probes.h
-
-+symlinks: $(top_builddir)/src/include/parser/gram.h $(top_builddir)/src/include/utils/fmgroids.h $(top_builddir)/src/include/utils/probes.h
-+
-
- # The postgres.o target is needed by the rule in Makefile.global that
- # creates the exports file when MAKE_EXPORTS = true.
diff --git a/databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
deleted file mode 100644
index 3c1609fdbbc7..000000000000
--- a/databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample
+++ /dev/null
@@ -1,28 +0,0 @@
---- src/backend/utils/misc/postgresql.conf.sample.orig 2010-10-01 16:25:44.000000000 +0200
-+++ src/backend/utils/misc/postgresql.conf.sample 2010-10-05 07:37:35.626282933 +0200
-@@ -256,6 +256,7 @@
-
- # - Where to Log -
-
-+log_destination = 'syslog'
- #log_destination = 'stderr' # Valid values are combinations of
- # stderr, csvlog, syslog, and eventlog,
- # depending on platform. csvlog
-@@ -290,6 +291,7 @@
- #syslog_facility = 'LOCAL0'
- #syslog_ident = 'postgres'
-
-+silent_mode = on
- #silent_mode = off # Run server silently.
- # DO NOT USE without syslog or
- # logging_collector
-@@ -394,6 +396,9 @@
- #track_counts = on
- #track_functions = none # none, pl, all
- #track_activity_query_size = 1024 # (change requires restart)
-+
-+# On FreeBSD, this is a performance hog, so keep it off if you need speed
-+update_process_title = off
- #update_process_title = on
- #stats_temp_directory = 'pg_stat_tmp'
-
diff --git a/databases/postgresql91-server/files/pkg-message-client.in b/databases/postgresql91-server/files/pkg-message-client.in
deleted file mode 100644
index 3183bc136aa6..000000000000
--- a/databases/postgresql91-server/files/pkg-message-client.in
+++ /dev/null
@@ -1,32 +0,0 @@
-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 pg_standby, pgcrypto and many other cool
- things.
-
-etc...
diff --git a/databases/postgresql91-server/files/pkg-message-contrib.in b/databases/postgresql91-server/files/pkg-message-contrib.in
deleted file mode 100644
index 2b29ffd33041..000000000000
--- a/databases/postgresql91-server/files/pkg-message-contrib.in
+++ /dev/null
@@ -1,3 +0,0 @@
-The PostgreSQL contrib utilities have been installed. Please see
-%%PREFIX%%/share/doc/postgresql/contrib/README
-for more information.
diff --git a/databases/postgresql91-server/files/pkg-message-plperl.in b/databases/postgresql91-server/files/pkg-message-plperl.in
deleted file mode 100644
index 5d0c83920563..000000000000
--- a/databases/postgresql91-server/files/pkg-message-plperl.in
+++ /dev/null
@@ -1,3 +0,0 @@
-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/postgresql91-server/files/pkg-message-plpython.in b/databases/postgresql91-server/files/pkg-message-plpython.in
deleted file mode 100644
index c413582b6295..000000000000
--- a/databases/postgresql91-server/files/pkg-message-plpython.in
+++ /dev/null
@@ -1,3 +0,0 @@
-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/postgresql91-server/files/pkg-message-pltcl.in b/databases/postgresql91-server/files/pkg-message-pltcl.in
deleted file mode 100644
index 0902b858de0b..000000000000
--- a/databases/postgresql91-server/files/pkg-message-pltcl.in
+++ /dev/null
@@ -1,3 +0,0 @@
-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/postgresql91-server/files/pkg-message-server.in b/databases/postgresql91-server/files/pkg-message-server.in
deleted file mode 100644
index 54f397448198..000000000000
--- a/databases/postgresql91-server/files/pkg-message-server.in
+++ /dev/null
@@ -1,70 +0,0 @@
-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.d/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/postgresql91-server/files/pkgIndex.tcl.in b/databases/postgresql91-server/files/pkgIndex.tcl.in
deleted file mode 100644
index bd8329b15c69..000000000000
--- a/databases/postgresql91-server/files/pkgIndex.tcl.in
+++ /dev/null
@@ -1,4 +0,0 @@
-# Package-index file for Pgtcl-package. Enables you to load PostgreSQL
-# interface functions right into you TCL-interpreter as simply as
-# package require Pgtcl
-package ifneeded Pgtcl 1.3 "load %%PREFIX%%/lib/libpgtcl.so"
diff --git a/databases/postgresql91-server/files/postgresql.in b/databases/postgresql91-server/files/postgresql.in
deleted file mode 100644
index 405d2efaa4d3..000000000000
--- a/databases/postgresql91-server/files/postgresql.in
+++ /dev/null
@@ -1,63 +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"
-# 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
-
-command=%%PREFIX%%/bin/pg_ctl
-
-. /etc/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 ${postgresql_initdb_flags} -D ${postgresql_data}"
-}
-
-run_rc_command "$1"