diff options
Diffstat (limited to 'databases/postgresql92-server/files')
16 files changed, 0 insertions, 404 deletions
diff --git a/databases/postgresql92-server/files/502.pgsql b/databases/postgresql92-server/files/502.pgsql deleted file mode 100644 index d2235e414cd2..000000000000 --- a/databases/postgresql92-server/files/502.pgsql +++ /dev/null @@ -1,94 +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 -# 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 - -case "$daily_pgsql_backup_enable" in - [Yy][Ee][Ss]) - - # 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 - dbnames=`su -l pgsql -c "umask 077; psql -q -t -A -d template1 -c SELECT\ datname\ FROM\ pg_database\ WHERE\ datname!=\'template0\'"` - 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" - for db in ${dbnames}; 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 - 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 - ;; -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/postgresql92-server/files/dot.cshrc.in b/databases/postgresql92-server/files/dot.cshrc.in deleted file mode 100644 index 4069398b376e..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/dot.profile.in b/databases/postgresql92-server/files/dot.profile.in deleted file mode 100644 index 954e22eae8f8..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/extra-patch-icu4 b/databases/postgresql92-server/files/extra-patch-icu4 deleted file mode 100644 index 28c8a8cfff33..000000000000 --- a/databases/postgresql92-server/files/extra-patch-icu4 +++ /dev/null @@ -1,30 +0,0 @@ ---- configure.in.orig 2010-03-25 22:25:10.655197193 +0100 -+++ configure.in 2010-03-25 22:25:13.611658318 +0100 -@@ -945,15 +945,19 @@ - fi - - if test "$with_icu" = yes ; then -- 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_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_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_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/postgresql92-server/files/patch-doc-Makefile b/databases/postgresql92-server/files/patch-doc-Makefile deleted file mode 100644 index 8e08132e175b..000000000000 --- a/databases/postgresql92-server/files/patch-doc-Makefile +++ /dev/null @@ -1,16 +0,0 @@ ---- doc/Makefile.orig 2009-05-15 15:58:05.000000000 +0200 -+++ doc/Makefile 2009-05-15 15:58:18.000000000 +0200 -@@ -25,9 +25,10 @@ - - .NOTPARALLEL: - --ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) --found_html = yes --endif -+# FreeBSD has a separate port for installing the documentation -+#ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) -+#found_html = yes -+#endif - - ifneq ($(wildcard $(srcdir)/man.tar.gz),) - # SCO OpenServer's man system is sufficiently different to not bother. diff --git a/databases/postgresql92-server/files/patch-plpython-Makefile b/databases/postgresql92-server/files/patch-plpython-Makefile deleted file mode 100644 index 3357b699da8a..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/patch-src-backend-Makefile b/databases/postgresql92-server/files/patch-src-backend-Makefile deleted file mode 100644 index 6d6fb0ce660b..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample deleted file mode 100644 index 4c32ae4a26bb..000000000000 --- a/databases/postgresql92-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ /dev/null @@ -1,28 +0,0 @@ ---- ./src/backend/utils/misc/postgresql.conf.sample.orig 2009-08-24 22:08:40.000000000 +0200 -+++ ./src/backend/utils/misc/postgresql.conf.sample 2009-10-04 19:21:09.000000000 +0200 -@@ -230,6 +230,7 @@ - - # - Where to Log - - -+log_destination = 'syslog' - #log_destination = 'stderr' # Valid values are combinations of - # stderr, csvlog, syslog and eventlog, - # depending on platform. csvlog -@@ -264,6 +265,7 @@ - #syslog_facility = 'LOCAL0' - #syslog_ident = 'postgres' - -+silent_mode = on - #silent_mode = off # Run server silently. - # DO NOT USE without syslog or - # logging_collector -@@ -367,6 +369,9 @@ - #track_counts = on - #track_functions = none # none, pl, all - #track_activity_query_size = 1024 -+ -+# 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/postgresql92-server/files/pkg-message-client.in b/databases/postgresql92-server/files/pkg-message-client.in deleted file mode 100644 index 3183bc136aa6..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/pkg-message-contrib.in b/databases/postgresql92-server/files/pkg-message-contrib.in deleted file mode 100644 index 2b29ffd33041..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/pkg-message-plperl.in b/databases/postgresql92-server/files/pkg-message-plperl.in deleted file mode 100644 index 5d0c83920563..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/pkg-message-plpython.in b/databases/postgresql92-server/files/pkg-message-plpython.in deleted file mode 100644 index c413582b6295..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/pkg-message-pltcl.in b/databases/postgresql92-server/files/pkg-message-pltcl.in deleted file mode 100644 index 0902b858de0b..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/pkg-message-server.in b/databases/postgresql92-server/files/pkg-message-server.in deleted file mode 100644 index 54f397448198..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/pkgIndex.tcl.in b/databases/postgresql92-server/files/pkgIndex.tcl.in deleted file mode 100644 index bd8329b15c69..000000000000 --- a/databases/postgresql92-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/postgresql92-server/files/postgresql.in b/databases/postgresql92-server/files/postgresql.in deleted file mode 100644 index 405d2efaa4d3..000000000000 --- a/databases/postgresql92-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" |