diff options
Diffstat (limited to 'databases/postgresql73-server/files')
20 files changed, 0 insertions, 490 deletions
diff --git a/databases/postgresql73-server/files/502.pgsql b/databases/postgresql73-server/files/502.pgsql deleted file mode 100644 index 0959155..0000000 --- a/databases/postgresql73-server/files/502.pgsql +++ /dev/null @@ -1,97 +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_enable="YES" -daily_pgsql_backup_enable="NO" - -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 ${backupdir}; chmod 700 ${backupdir}; chown pgsql ${backupdir} - fi - - echo - echo "PostgreSQL maintenance" - - # Protect the data - umask 077 - dbnames=`su -l pgsql -c "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 "pg_dumpall -g | gzip -9 > ${file}.gz" - for db in ${dbnames}; do - echo -n " $db" - file=${backupdir}/pgdump_${db}_${now} - su -l pgsql -c "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 "vacuuming..." - 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/postgresql73-server/files/dot.cshrc.in b/databases/postgresql73-server/files/dot.cshrc.in deleted file mode 100644 index 4069398..0000000 --- a/databases/postgresql73-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/postgresql73-server/files/dot.profile.in b/databases/postgresql73-server/files/dot.profile.in deleted file mode 100644 index 6da911d..0000000 --- a/databases/postgresql73-server/files/dot.profile.in +++ /dev/null @@ -1,25 +0,0 @@ -# both new and old layout's paths, but new path first... -PATH=%%PREFIX%%/bin:${PATH} - -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/postgresql73-server/files/patch-configure b/databases/postgresql73-server/files/patch-configure deleted file mode 100644 index ed7555e..0000000 --- a/databases/postgresql73-server/files/patch-configure +++ /dev/null @@ -1,71 +0,0 @@ ---- configure.orig Wed Jun 26 21:28:24 2002 -+++ configure Wed Jun 26 21:35:16 2002 -@@ -441,6 +441,11 @@ - -docdir=* | --docdir=* | --infodi=* | --infod=* | --doc=* | --inf=*) - docdir=$ac_optarg ;; - -+ -infodir | --infodir | --infodi | --infod | --info | --inf) -+ ac_prev=infodir ;; -+ -infodir=* | --infodir=* | --infodi=* | --infod=* | --info=* | --inf=*) -+ infodir=$ac_optarg ;; -+ - -libdir | --libdir | --libdi | --libd) - ac_prev=libdir ;; - -libdir=* | --libdir=* | --libdi=* | --libd=*) -@@ -2007,11 +2007,13 @@ - EOF - - -- if test -d "$krb4_prefix/include"; then -- INCLUDES="$INCLUDES -I$krb4_prefix/include" -- fi -- if test -d "$krb4_prefix/lib"; then -- LIBDIRS="$LIBDIRS -L$krb4_prefix/lib" -+ if test "$krb4_prefix" != "/usr"; then -+ if test -d "$krb4_prefix/include"; then -+ INCLUDES="$INCLUDES -I$krb4_prefix/include" -+ fi -+ if test -d "$krb4_prefix/lib"; then -+ LIBDIRS="$LIBDIRS -L$krb4_prefix/lib" -+ fi - fi - - krb_srvtab="/etc/srvtab" -@@ -2052,11 +2054,13 @@ - EOF - - -- if test -d "$krb5_prefix/include"; then -- INCLUDES="$INCLUDES -I$krb5_prefix/include" -- fi -- if test -d "$krb5_prefix/lib"; then -- LIBDIRS="$LIBDIRS -L$krb5_prefix/lib" -+ if test "$krb5_prefix" != "/usr"; then -+ if test -d "$krb5_prefix/include"; then -+ INCLUDES="$INCLUDES -I$krb5_prefix/include" -+ fi -+ if test -d "$krb5_prefix/lib"; then -+ LIBDIRS="$LIBDIRS -L$krb5_prefix/lib" -+ fi - fi - - krb_srvtab="FILE:\$(sysconfdir)/krb5.keytab" -@@ -2157,11 +2161,13 @@ - EOF - - -- if test -d "${openssl_prefix}/include" ; then -- INCLUDES="$INCLUDES -I${openssl_prefix}/include" -- fi -- if test -d "${openssl_prefix}/lib" ; then -- LIBDIRS="$LIBDIRS -L${openssl_prefix}/lib" -+ if test "${openssl_prefix}" != "/usr"; then -+ if test -d "${openssl_prefix}/include" ; then -+ INCLUDES="$INCLUDES -I${openssl_prefix}/include" -+ fi -+ if test -d "${openssl_prefix}/lib" ; then -+ LIBDIRS="$LIBDIRS -L${openssl_prefix}/lib" -+ fi - fi - - fi diff --git a/databases/postgresql73-server/files/patch-doc-Makefile b/databases/postgresql73-server/files/patch-doc-Makefile deleted file mode 100644 index 53a4622..0000000 --- a/databases/postgresql73-server/files/patch-doc-Makefile +++ /dev/null @@ -1,11 +0,0 @@ ---- doc/Makefile~ 2002-11-28 00:21:20.000000000 +0100 -+++ doc/Makefile 2008-01-07 11:50:06.000000000 +0100 -@@ -26,7 +26,7 @@ - .NOTPARALLEL: - - ifneq ($(wildcard $(srcdir)/postgres.tar.gz),) --found_html := yes -+#found_html := yes - endif - - ifneq ($(wildcard $(srcdir)/man.tar.gz),) diff --git a/databases/postgresql73-server/files/patch-plpython-Makefile b/databases/postgresql73-server/files/patch-plpython-Makefile deleted file mode 100644 index a130315..0000000 --- a/databases/postgresql73-server/files/patch-plpython-Makefile +++ /dev/null @@ -1,11 +0,0 @@ ---- src/pl/plpython/Makefile~ Thu Mar 4 08:06:19 2004 -+++ src/pl/plpython/Makefile Thu Mar 4 08:06:44 2004 -@@ -8,7 +8,7 @@ - # On some platforms we can only build PL/Python if libpython is a - # shared library. Since there is no official way to determine this, - # we see if there is a file that is named like a shared library. --ifneq (,$(wildcard $(python_configdir)/libpython*$(DLSUFFIX)*)) -+ifneq (,$(wildcard $(python_configdir)/../../libpython*$(DLSUFFIX)*)) - shared_libpython = yes - endif - diff --git a/databases/postgresql73-server/files/patch-src-bin-initdb-Makefile b/databases/postgresql73-server/files/patch-src-bin-initdb-Makefile deleted file mode 100644 index 406613b..0000000 --- a/databases/postgresql73-server/files/patch-src-bin-initdb-Makefile +++ /dev/null @@ -1,11 +0,0 @@ ---- src/bin/initdb/Makefile.orig Tue Jan 9 11:31:36 2007 -+++ src/bin/initdb/Makefile Tue Jan 9 11:32:07 2007 -@@ -13,7 +13,7 @@ - top_builddir = ../../.. - include $(top_builddir)/src/Makefile.global - --all: initdb -+all: submake-libpq submake-libpgport initdb - - initdb: initdb.sh $(top_builddir)/src/Makefile.global - sed -e 's/@VERSION@/$(VERSION)/g' \ diff --git a/databases/postgresql73-server/files/patch-src-interfaces-jdbc-build-xml b/databases/postgresql73-server/files/patch-src-interfaces-jdbc-build-xml deleted file mode 100644 index 44a6e79..0000000 --- a/databases/postgresql73-server/files/patch-src-interfaces-jdbc-build-xml +++ /dev/null @@ -1,11 +0,0 @@ ---- src/interfaces/jdbc/build.xml.orig Fri Mar 28 09:55:21 2003 -+++ src/interfaces/jdbc/build.xml Fri Mar 28 09:57:29 2003 -@@ -101,7 +101,7 @@ - - <!-- This is the core of the driver. It is common for all three versions. --> - <target name="compile" depends="prepare,check_versions,driver"> -- <javac srcdir="${srcdir}" destdir="${builddir}" debug="${debug}"> -+ <javac includeAntRuntime="no" srcdir="${srcdir}" destdir="${builddir}" debug="${debug}"> - <include name="${package}/**" /> - - <exclude name="${package}/jdbc1/**" unless="jdbc1"/> diff --git a/databases/postgresql73-server/files/patch-src-interfaces-libpgtcl-Makefile b/databases/postgresql73-server/files/patch-src-interfaces-libpgtcl-Makefile deleted file mode 100644 index 318deac..0000000 --- a/databases/postgresql73-server/files/patch-src-interfaces-libpgtcl-Makefile +++ /dev/null @@ -1,11 +0,0 @@ ---- src/interfaces/libpgtcl/Makefile.orig Wed Dec 11 05:08:05 2002 -+++ src/interfaces/libpgtcl/Makefile Sat Oct 23 17:37:20 2004 -@@ -25,7 +25,7 @@ - # If crypt is a separate library, rather than part of libc, it may need - # to be referenced separately to keep (broken) linkers happy. (This is - # braindead; users of libpq should not need to know what it depends on.) --SHLIB_LINK+= $(filter -L%, $(LDFLAGS)) $(filter -lcrypt, $(LIBS)) -+SHLIB_LINK+= $(filter -L%, $(LDFLAGS)) $(filter -lcrypt -ltcl83 -ltcl84, $(LIBS)) - - all: submake-libpq all-lib - diff --git a/databases/postgresql73-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql73-server/files/patch-src-makefiles-Makefile.freebsd deleted file mode 100644 index 9b4571d..0000000 --- a/databases/postgresql73-server/files/patch-src-makefiles-Makefile.freebsd +++ /dev/null @@ -1,17 +0,0 @@ ---- src/makefiles/Makefile.freebsd.orig Wed Aug 29 21:14:40 2001 -+++ src/makefiles/Makefile.freebsd Sat Jan 31 17:51:25 2004 -@@ -7,7 +7,7 @@ - endif - - DLSUFFIX = .so --CFLAGS_SL = -fpic -DPIC -+CFLAGS_SL = -fPIC -DPIC - - %.so: %.o - ifdef ELF_SYSTEM -@@ -23,3 +23,5 @@ - endif - - sqlmansect = 7 -+ -+allow_nonpic_in_shlib = yes diff --git a/databases/postgresql73-server/files/patch-src:backend:utils:misc:postgresql.conf.sample b/databases/postgresql73-server/files/patch-src:backend:utils:misc:postgresql.conf.sample deleted file mode 100644 index e9ad932..0000000 --- a/databases/postgresql73-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ /dev/null @@ -1,24 +0,0 @@ ---- src/backend/utils/misc/postgresql.conf.sample.orig Sun Mar 30 23:38:13 2003 -+++ src/backend/utils/misc/postgresql.conf.sample Thu Oct 28 05:24:07 2004 -@@ -119,7 +119,7 @@ - #client_min_messages = notice # Values, in order of decreasing detail: - # debug5, debug4, debug3, debug2, debug1, - # log, info, notice, warning, error --#silent_mode = false -+silent_mode = true - - #log_connections = false - #log_pid = false -@@ -145,9 +145,9 @@ - # - # Syslog - # --#syslog = 0 # range 0-2 --#syslog_facility = 'LOCAL0' --#syslog_ident = 'postgres' -+syslog = 2 # range 0-2 -+syslog_facility = 'LOCAL0' -+syslog_ident = 'postgres' - - - # diff --git a/databases/postgresql73-server/files/pkg-message-client.in b/databases/postgresql73-server/files/pkg-message-client.in deleted file mode 100644 index 722d50cb..0000000 --- a/databases/postgresql73-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 autovacuum, pgcrypto and many other cool - things. - -etc... diff --git a/databases/postgresql73-server/files/pkg-message-contrib.in b/databases/postgresql73-server/files/pkg-message-contrib.in deleted file mode 100644 index 2b29ffd..0000000 --- a/databases/postgresql73-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/postgresql73-server/files/pkg-message-plperl.in b/databases/postgresql73-server/files/pkg-message-plperl.in deleted file mode 100644 index 5d0c839..0000000 --- a/databases/postgresql73-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/postgresql73-server/files/pkg-message-plpython.in b/databases/postgresql73-server/files/pkg-message-plpython.in deleted file mode 100644 index c413582..0000000 --- a/databases/postgresql73-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/postgresql73-server/files/pkg-message-pltcl.in b/databases/postgresql73-server/files/pkg-message-pltcl.in deleted file mode 100644 index 0902b85..0000000 --- a/databases/postgresql73-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/postgresql73-server/files/pkg-message-server.in b/databases/postgresql73-server/files/pkg-message-server.in deleted file mode 100644 index d2367e2..0000000 --- a/databases/postgresql73-server/files/pkg-message-server.in +++ /dev/null @@ -1,67 +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. - -You should vacuum and backup your database regularly. There is a -periodic script, %%PREFIX%%/etc/periodic/daily/502.pgsql, that you may -find useful. 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. - -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/postgresql73-server/files/pkgIndex.tcl.in b/databases/postgresql73-server/files/pkgIndex.tcl.in deleted file mode 100644 index bd8329b..0000000 --- a/databases/postgresql73-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/postgresql73-server/files/postgresql.in b/databases/postgresql73-server/files/postgresql.in deleted file mode 100644 index 405d2ef..0000000 --- a/databases/postgresql73-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" diff --git a/databases/postgresql73-server/files/regresspatch-src-test-regress-pgregress-sh b/databases/postgresql73-server/files/regresspatch-src-test-regress-pgregress-sh deleted file mode 100644 index 7273152..0000000 --- a/databases/postgresql73-server/files/regresspatch-src-test-regress-pgregress-sh +++ /dev/null @@ -1,12 +0,0 @@ ---- src/test/regress/pg_regress.sh~ Wed Nov 13 17:40:29 2002 -+++ src/test/regress/pg_regress.sh Sat Jan 8 05:31:17 2005 -@@ -348,6 +348,9 @@ - (exit 2); exit - fi - -+ # make rest of this script happy -+ echo "syslog = 0" >> $PGDATA/postgresql.conf -+ echo "silent_mode = false" >> $PGDATA/postgresql.conf - - # ---------- - # Start postmaster |
