diff options
author | cvs2svn <cvs2svn@FreeBSD.org> | 2005-01-21 15:36:45 +0000 |
---|---|---|
committer | cvs2svn <cvs2svn@FreeBSD.org> | 2005-01-21 15:36:45 +0000 |
commit | 7011c19a8c96a2f8fb7c04d61cb28cdc507584a6 (patch) | |
tree | 22c0efaf2b6bb5b461389f9bac9542c7e3a5909a /databases/postgresql91-server/files | |
parent | a33896596d7008d70bca9b6ce72347e2d7b6fd9a (diff) |
Notes
Diffstat (limited to 'databases/postgresql91-server/files')
10 files changed, 0 insertions, 310 deletions
diff --git a/databases/postgresql91-server/files/502.pgsql b/databases/postgresql91-server/files/502.pgsql deleted file mode 100644 index a1cf9ba4f2ee..000000000000 --- a/databases/postgresql91-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_vaccum_enable="NO" -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/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/patch-configure b/databases/postgresql91-server/files/patch-configure deleted file mode 100644 index efeca517d300..000000000000 --- a/databases/postgresql91-server/files/patch-configure +++ /dev/null @@ -1,59 +0,0 @@ ---- configure.orig Wed Jun 26 21:28:24 2002 -+++ configure Wed Jun 26 21:35:16 2002 -@@ -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/postgresql91-server/files/patch-src-interfaces-jdbc-build-xml b/databases/postgresql91-server/files/patch-src-interfaces-jdbc-build-xml deleted file mode 100644 index 89806a159665..000000000000 --- a/databases/postgresql91-server/files/patch-src-interfaces-jdbc-build-xml +++ /dev/null @@ -1,14 +0,0 @@ ---- src/interfaces/jdbc/build.xml.orig Thu Jun 24 11:51:44 2004 -+++ src/interfaces/jdbc/build.xml Thu Sep 2 01:51:36 2004 -@@ -113,10 +113,7 @@ - - <target name="compile" depends="prepare,check_versions,driver"> - -- <available classname="org.postgresql.Driver" property="old.driver.present" /> -- <fail message="Old driver was detected on classpath or in jre/lib/ext, please remove and try again." if="old.driver.present" /> -- -- <javac classpath="${srcdir}" srcdir="${srcdir}" destdir="${builddir}" debug="${debug}"> -+ <javac includeAntRuntime="no" classpath="${srcdir}" srcdir="${srcdir}" destdir="${builddir}" debug="${debug}"> - <!-- This is the core of the driver. It is common for all three versions. --> - <include name="${package}/*.java" /> - <include name="${package}/core/**" /> diff --git a/databases/postgresql91-server/files/patch-src-interfaces-libpgtcl-Makefile b/databases/postgresql91-server/files/patch-src-interfaces-libpgtcl-Makefile deleted file mode 100644 index 44c60a29157e..000000000000 --- a/databases/postgresql91-server/files/patch-src-interfaces-libpgtcl-Makefile +++ /dev/null @@ -1,11 +0,0 @@ ---- src/interfaces/libpgtcl/Makefile.orig Tue Feb 10 08:26:48 2004 -+++ src/interfaces/libpgtcl/Makefile Thu Mar 11 21:12:25 2004 -@@ -21,7 +21,7 @@ - OBJS= pgtcl.o pgtclCmds.o pgtclId.o - - SHLIB_LINK = $(libpq) $(TCL_LIB_SPEC) $(TCL_LIBS) \ -- $(filter -lintl -lssl -lcrypto -lkrb5 -lcrypt, $(LIBS)) $(THREAD_LIBS) -+ $(filter -lintl -lssl -lcrypto -lkrb5 -lcrypt -L% -ltcl83 -ltcl84, $(LIBS)) $(THREAD_LIBS) - - all: submake-libpq all-lib - diff --git a/databases/postgresql91-server/files/patch-src-makefiles-Makefile.freebsd b/databases/postgresql91-server/files/patch-src-makefiles-Makefile.freebsd deleted file mode 100644 index 9b4571d5dc30..000000000000 --- a/databases/postgresql91-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/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 b9842b0c94f6..000000000000 --- a/databases/postgresql91-server/files/patch-src:backend:utils:misc:postgresql.conf.sample +++ /dev/null @@ -1,24 +0,0 @@ ---- src/backend/utils/misc/postgresql.conf.sample~ Wed Oct 8 05:49:38 2003 -+++ src/backend/utils/misc/postgresql.conf.sample Tue Nov 18 05:08:08 2003 -@@ -136,9 +136,9 @@ - - # - Syslog - - --#syslog = 0 # range 0-2; 0=stdout; 1=both; 2=syslog --#syslog_facility = 'LOCAL0' --#syslog_ident = 'postgres' -+syslog = 2 # range 0-2; 0=stdout; 1=both; 2=syslog -+syslog_facility = 'LOCAL0' -+syslog_ident = 'postgres' - - # - When to Log - - -@@ -162,7 +162,7 @@ - # milliseconds. Zero prints all queries. - # Minus-one disables. - --#silent_mode = false # DO NOT USE without Syslog! -+silent_mode = true # DO NOT USE without Syslog! - - # - What to Log - - diff --git a/databases/postgresql91-server/files/pgsql.sh.tmpl b/databases/postgresql91-server/files/pgsql.sh.tmpl deleted file mode 100644 index 3f8706d6af0c..000000000000 --- a/databases/postgresql91-server/files/pgsql.sh.tmpl +++ /dev/null @@ -1,51 +0,0 @@ -#!/bin/sh - -# $FreeBSD$ -# -# For postmaster startup options, edit $PGDATA/postgresql.conf -# -# Note that PGDATA is set in ~pgsql/.profile, don't try to manipulate it here! -# - -PREFIX=%%PREFIX%% -PGBIN=${PREFIX}/bin - -case $1 in -start) - [ -x ${PGBIN}/pg_ctl ] && { - echo -n ' pgsql' - su -l pgsql -c \ - "[ -d \${PGDATA} ] && exec ${PREFIX}/bin/pg_ctl start -s -w" - } - ;; - -stop) - [ -x ${PGBIN}/pg_ctl ] && { - echo -n ' pgsql' - su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl stop -s -m fast" - } - ;; - -restart) - [ -x ${PGBIN}/pg_ctl ] && { - exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl restart -s -m fast" - } - ;; - -reload) - [ -x ${PGBIN}/pg_ctl ] && { - exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl reload" - } - ;; - -status) - [ -x ${PGBIN}/pg_ctl ] && { - exec su -l pgsql -c "exec ${PREFIX}/bin/pg_ctl status" - } - ;; - -*) - echo "usage: `basename $0` {start|stop|restart|reload|status}" >&2 - exit 64 - ;; -esac 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" |